I have a an application that opens a SQL connection and over the course of a few hours creates and disposes of tens of thousands of DataReader objects. You could look at it as just one big loop. As the time goes by, the memory usage steadily climbs until the application/system runs out of memory and crashes.
Psuedo code would look something like
SQLConnection.Connect
Do Until x =1000000
Create New DataReader
Use DataReader
Close DataReader
[Code] .....
Even though I dispose of the DataReader object when I am done with it, the memory usage keeps climbing. I found that every time I am finished with the DataReader I have to close the SQLConnection and dispose of it. When I do that it keeps the memory usage very low and the processor usage is barely noticeable. I would think I could just open the SQL connection once and close it when I am done.
I have compiled a Vb.Net program in which I used R Programming through R(D)COM. The statconnector library works fine. The program gives output without any error. However whenever I try to deploy the code and create a setup file, and I run the setup file, I get the following error: There is connection for this connection ID (Exception from HRESULT: OLE_E_NOCONNECTION)
i have a string "David John Roplay" i need to replace first occourance of the space " " into double space " "i have used String.Replace() but it is relplacing all the spaces.
This should be fairly simple but i'm having one of those days, can any1 advise me as to how to replace the first and third occurance of a character within a string, i have looked at replace but that cannot work as the string could be of different lengths, all i want to do is replace the first and third occurance?
Im working on a program for my work and it is starting to get pretty in depth. Is there any way to replace just one occurence of a string. I tried this:
Dose anybody know how I can tally instances of a particular text occurrence within a txt file using VB.net. Better explanation if I use a textbox and type in a text how I can use VB.net to search a txt file for that piece of text and return the amount counted in another textbox or label.
Dim t As String = source For Each m As System.Text.RegularExpressions.Match In System.Text.RegularExpressions.Regex.Matches(t, ">.*?<") search = m.Value.Substring(1).Remove(m.Value.Length - 2) If search = "" Or haku = " " And counter < 337 Then
[code]....
What you see here, is a code that picks everything written in between > and < markers from a source code on a website. What it returns is always a time stamp in between 00:00 and 23:59 and a string. Or almost always. There is a few instances where there are two times in a row and not every other, effectively breaking the system.Also, when this happens, the first time of the two has a "-" after it, i.e 18:00- What I've been trying to do, is making the program recognize when there is an extra character (the -), delete the extra character, and then jump over the next result in the search (the following time). This would completely resolve the problem.
The thing is, no matter how much I go through it in my head, I can't seem to think of a way to affect the NEXT result without screwing up the current result or all the following results. As you can see, my code is faulty. What it does now is an emergency method (as my teacher review of the code is coming up real soon) it jumps over the time with the extra character, and lists the following time. This however is not ultimately wanted, because in the bigger scheme of things, it displays the incorrect time for the incorrect string.
Search variable holds all the results of the regex search, for easier handling, and is used for checking for the extra character.Length6 variable is boolean for determining if the result had the "-" or not. The column ariable is to list the time and the string on the same line in the textbox.Jump is the variable that makes the code skip the conditioned result from the search.The counter variable, that might seem extra, is just for extra conditioning, its use is to prevent the first 337 instances of the search.
i am trying to run a stored procedure from my vb .net application and i am getting an error that says something like this:
"..under default settings sql server does not allow remote connections"
i have checked with my sql configurations and i have allowed remote connections but i am getting this error. besides i am connecting to my local machine so why should it give me a remote connection error.
I wan't a method with which to find a string within another string. It should return the position of the first occurrence of the substring. (In VB 2008 !)
I need to find the first occurrence of a certain word's position in a textbox, on how to do this? Once I find out how I can get the position of the word i am searching for I can then pull the data I need from the textbox. I am using visual studio 2010 / visual basic.Since I have no clue where to start on this code, I will post what code i will be using to get rid of the data i don't need from the textbox.
Dim s As String = TextBox1.Text TextBox1.Text = (TextBox1.Text.Remove(450))i figure I can do this in a few steps to bring the searched info out of the textbox. I am open to other ideas on how to gather my data from the file or textbox. Here is what I have to do: Pull all of the players names from a replay file and put them in separate text boxes or even a listbox.
have a list of 84000 words , and have some articles in these articles i want to replace first occurrence of each word i have in listbox e.g [code]but it used to replace the whole mytext i want to replace words in mytext and also it hang the system and very very slow and replace all occurrences.
I have my program set up to download a web page with a webclient. Normally, I could just use .Substring, but there are about 25 things I need to pluck out of this page, and .Substring, or at least the way I have it set up, takes the first occurrence. The good news is, they are all URLs; they are all similar too.
Each URL is as follows: [URL]
Now, of course, this URL is just made up, but each URL starts with [URL] and ends with 'video'.
How can I hook this up so that it scans the entire page (contained in a string, read from a StreamReader connected to a WebClient), finds each URL, and then adds it to a listview?
I making a connection through word 2003 VBA to SQL server 2005 using the following codeDim cn As ADODB.ConnectionSet cn = New Connectioncn.ConnectionString = "Provider=SQLNCLI;Server=LEXAE29150SQLEXPRESS;" & _"Database=MCarter.mdf;Integrated Security=SSPI;"cn.openetc.cn.close.All runs fine up to cn.open.I then get the message error 'Cannot open database "MC.dbf" request by the login. The Login failed'.Tryed websearching but no succes. Been on it a week and the boss is doing his nut. I'm lost and unsure what wrong.The SQL server is set for windows authenticity and SOL Server login.In the MC database under security users my user name (Login) is their and setup as owner and sysadmin.SQLServer is running on the same machine as the word.dot.
I wrote a program in Visual Basic 2008 on my laptop that runs windows vista 64 bit, well the program attempts to access an Sql server that I am running on my laptop and it continues to give me the following error:
I get a Type 'System.Data.SqlClient.SqlDataReader' has no constructors. error on the 5th line of code below and I get a Variable 'e' hides a variable in an enclosing block. on the last line of code below (in my catch statement).
Here is my code:
Imports System.Data.SqlClient Public Class Form1 Dim myConnection As SqlConnection
I'm connecting to an ftp server in my .net application. After I send the file and try to close the connection, I'm getting an error. I'm trying to send the Quit command to the FTP server but getting no reply. I'm not sure what I'm doing wrong. I call this method: [code] Do you think something is wrong with the code of could it be a problem with the ftp server?
My app is a Reader for personal use. I have it setup By Books of the Bible and by Chapters and verses.
What I would like to be able to do, is to search for Pharaoh (any word) in a textbox, click the Search Button, and every occurrence of Pharaoh (not just the word, but the entire Verse: EX: Gen Ch7:14 Blah Blah Blah Pharaoh Blah Blah. Gen Ch9 :3 Blah Pharaoh Blah); to display inside a RTF or TextBox.
Using - VB2008 Express, XP Pro, Connecting to SQL 2005 across the internet The walk throughs have several good explanations although I don't see any about connecting over the internet.
i have visual studio 2005 installed in my pc.i have sql server 2000 as database.i have expertise in client server software written in vb6.now im trying to do the same in vb.net.i dont know how to establish a global connection in vb.net.how to do that in vb.net?in vb6 i would just write a public function in a module and it remains throughout my application.so how can i achieve the same thing in vb.net.
