VS 2008 - DataReader While Loop (Hang After Few Minutes)
Sep 9, 2009
How come my datareader looping at the while loop line it become totally no response and without error eventhough I got use the try catch error catching... it only will hang on after few minute... after few loop. Is it the data reader got time out limit?? If exceed the limit it will no response..? Inside my while loop it do a lot of transaction and each transaction also take quite long time... it will affect?
myCommand = New MySqlCommand("SELECT * FROM stk_cus_inv_hd WHERE DocType=?DocType;", conn1)
myCommand.Parameters.AddWithValue("?DocType", "CS")
myCommand.CommandTimeout = 99999
myReader = myCommand.ExecuteReader
While myreader.read <<---- it jam at here and totally no response my coding... but my interface is clickable...
my lot of work here...
End While
View 11 Replies
ADVERTISEMENT
Feb 7, 2010
I m trying to use two datareader in same loop but its not working. Here is the error and code below Error line: DR1 = MyCommand.ExecuteReader()Error message: There is already an open DataReader associated with this Command which must be closed first.
[Code]...
View 2 Replies
Jun 24, 2010
I have a datareader pulling data from Oracle. It all works fine but I have one issue. When I issue the read() command ala;
While dr.Read
Column1List.Add(dr.GetValue(0).ToString().Replace(vbCrLf, ""))
Column2List.Add(dr.GetValue(1).ToString().Replace(vbCrLf, ""))
[Code]....
When the code hits that " While dr.Read" line it will hang there for up to 30 minutes which is just a ridiculous amount of time to advance to the next record, which is what the documentation says is all that is happening here. It only occurs the first time it hits that line...once it gets past it once, it does not hang again as it goes through it's while loop.
View 3 Replies
Apr 28, 2011
I've wrote a program designed to loop through a text file containing email addresses and unsubscribe said email addresses in our CRM system. I'm having a problem with the following code...
Do While obj_filereader2.Peek() <> -1
strcuremail = obj_filereader2.ReadLine()
Dim dbqCustNo As String = "SQL CODE HERE - SELECT CUSTOMER NUMBER"
Dim exeCustNo As New SqlCommand()
Dim SQLdr As SqlDataReader
exeCustNo.Connection = ConnStr
[Code] ......
The program is falling over when trying to execute the update commands during the datareader loop, with the fabled 'There is already an open DataReader associated with this Command...' error. This program has evolved as I've found problems/better ways of working, so it might be a case of myself just not using the DataAdapter right - I'm guessing I should be using a function of the open DataReader rather than the ExecuteNonQuery command.
View 2 Replies
Sep 4, 2009
I am made program to get Picture Pixel and check Pixel colors.
between looping my Application Form HANG (STOP) and also how can stop loop between working (on Run time)?
in listbox1 picture List with path
For P = 0 To ListBox1.Items.Count - 1
DisplayPic.Image = System.Drawing.Image.FromFile(ListBox1.Items.Item(P))
Call GetPicPixel()
[Code].....
View 1 Replies
Mar 18, 2009
If my Select statement finds data that matches the criteria, how do I get myReader (DataReader) to read each record when there are more then one record found?
Dim myReader As MySql.Data.MySqlClient.MySqlDataReader
myReader = myCommand.ExecuteReader()
If myReader.Read() Then
[code]....
View 5 Replies
Nov 19, 2011
can i do ( ExecuteNonQuery within the loop of a datareader ) in vb.net please help me with example
View 3 Replies
May 20, 2009
We're using the Autocomplete functionality for some textboxes. We populate the AutoCompleteCustomSource with data from a database query using a datareader loop. The data in the query is sorted by 'recently used', the most recently used entries are at the top.
Let's say the sequence op the AutoCompleteCustomSource is
'AM1900'
'AF2000'
'AD1950'
After typing an 'A' in the textbox, I would expect the Suggested (or Appended) value to be 'AM1900'. The suggested value however is always the first item from an alphabetically sorted
AutoCompleteCustomSource list (i.e. 'AD1950')
View 2 Replies
Jun 23, 2010
I am trying to send and receive data using the SerialPort component. I am sending data to an Texas Instruments MSP430 which simply echos the sent character. I wanted my VB solution to read characters from a file, send a single character, and wait until the echoed character is received before sending another.
I have been fairly successful thus far but I have run into a little catch. When I attempt to send large files (323505+ characters) my MSP430 just hangs there and will not receive any more characters. My VB app return to VS '08 with timeout errors (timeout set to 1 minute).
I wanted to post my VB code here to see if the problem is from my VB app. I will be posting this problem on the IT usergroup to sort out anything on the MCU end. Here is the pastbin of the data write and the data receive subs:[URl]..
View 2 Replies
Sep 21, 2009
I use the 'Process' object to run EXE from my application. It works fine when it run on Windows XP and 2003. When it run on Windows server 2008, it hangs up: the process is stayed in background but never returns. It never goes ahead for the next commands. What could be the reason? [Code]
View 6 Replies
Feb 4, 2012
I use the 'Process' object to run EXE from my application. It works fine when it run on Windows XP and 2003. When it run on Windows server 2008, it hangs up: the process is stayed in background but never returns. It never goes ahead for the next commands
View 2 Replies
Feb 20, 2012
I have an SQL statement like:
SELECT FNAME, LNAME, CITY from EMPLOYEE
How do I create a multi-dimensional array from a datareader which should store values like:
John, Doe, LA
Mike, Johnson, PASADENA
Freddy, Kruger, Long Beach
View 3 Replies
Jun 7, 2012
i have develop an application which write to comport. what i am exp is application hang while writing to port i cant minimize nor move the exe. the better part is it does task successfully for what it is made for.
View 9 Replies
Feb 9, 2010
I am using the System.Net.Mail namespace to create and send email messages. Everything was working fine until a couple of QC members of our team noticed something strange.
If they send emails from within my application and then leave the application open for a while (perhaps working on other tasks on the PC), when they try and activate my application again, it appears to be hung. The CPU is not pegged and everything appears to be normal in the task manager. We narrowed it down and it appears that this issue only manifests itself when MS Outlook is also opened and connected to a server.
I was playing around with process monitor, but nothing I saw was really glaring. I actually started deleting some threads on the PC and eventually my application became usable again.
View 6 Replies
Jul 21, 2009
I am looking for formula that is accurate in converting Minutes to Decimal Minutes i.e 30 minutes is 50 Minutes in Decimals so 1.3 hours is 1.50 and not 1.5 i have used Minutes/60 but it is not accurate as some times i have to Multiply the result by 100 and some time 1000 to get correct results based on single digit Try 1/60, 10/60 99/60 or 100/60.What would be the most efficient and correct way to Convert the time into Minutes ?
View 10 Replies
Aug 17, 2009
I have a problem with my project. here is the problem:
My code for login is as follows:
dim conn as SqlConnection = New SqlConnection("Data Source.................)
dim cmd as SqlCommand = New SqlCommand("Loguser",conn)
cmd.CammandType = CommandType.StoredProcedure
[CODE]...
Now the error i get is that "there is a datareader associate with this connection that need to be closed"
View 4 Replies
Jan 27, 2010
I am working on a project which requires me to connect to a MySQL database. From there I query the database and need to do work on the returned values.
I can query the database just fine. However, now I need to do work on the results. The two columns returned are user_name and user_password. The rows are the user accounts. I would like to take my query results and put each column into its own arrary().
[code..]
Instead of writing the results to the console, I would like to write each column to an individual array. Is there an easier way to accomplish this task? Or, what is the code I must place within the loop to do this.
View 3 Replies
Oct 15, 2010
I am doing the basic reading form one table,.it is opening the connection,no problems.i got 5 rows in Categories table with two columns .i got some data as well.using datareader i am trying to read the data.It is not going into while loop
[Code]...
View 5 Replies
Jan 14, 2010
Ok so I want my program to keep sending a messagebox pop up at a speed that the user can pick for as long as they choose such as."How many hours" 5."How many minutes" 10..Then that will countdown every minute.[code]
View 3 Replies
Oct 21, 2010
to obtain double quantity between 2 hours I do this:
[Code]...
But how would it be inversely?For example if I have a number (double), how I know at all the hours and minutes are they?
[Code]...
View 1 Replies
Sep 28, 2010
I am losing my leading zero in the minutes below. I thought having the "mm" would place two digits for the time.
DateTime.Now.ToString("mm")
View 2 Replies
Jun 28, 2009
i have 1 timer 1 textbox how can i make so if i put a "1" in textbox1.text the timer1 will only wait 1 minute ? if i put 2 in textbox1.text it will wait 2 min ETC
View 8 Replies
Mar 29, 2009
[code]I am facing difficulty in coding when intRow loop for the 2nd round. Error message "There is already an open DataReader associated with this Command which must be closed " appear in the above red highlight vb.net code.
View 6 Replies
Jan 11, 2011
How can I fill this Percentage array with Sql data reader..
Dim StudentID As Integer = Me.ComboBox1.SelectedValue
Dim Percentage() As Integer
Dim con As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=D:Database
[code].....
View 5 Replies
Mar 16, 2010
The code works fine, but I don't know if is necessary while sentence, maybe there is another option..
Dim CMD As New OleDb.OleDbCommand
CMD.Connection = otraConexion
CMD.CommandText = "SELECT * from procedencias"
[Code]....
View 3 Replies
Feb 19, 2010
I use firebird server for 2 years and I used this code
[Code]...
View 4 Replies
May 14, 2008
This is some of my code. But how do I populate a datagridview using the datareader.
Dim strSQL As String = "SELECT peopleid,firstnames,surname FROM people;"
Dim cmd As New MySqlCommand(strSQL, con)
'cmd.Parameters.AddWithValue("Parameter1", strName)
Dim reader As MySqlDataReader = cmd.ExecuteReader
and how can I handle null field values.
View 10 Replies
Mar 10, 2009
have another problem regarding with time again. After getting a user input time in "H:mm", in what way can I add like an additional 15 minutes to it? Something like this:
1 - User inputs the time in textbox
2 - Adding 15 mins(which is in an array) to the time
[Code]...
View 4 Replies
Jun 2, 2010
I'm not even sure where to start. I would like to create something like the ADO DataReader but that works in a TCP Client/Server scenario.Basically, in the TCP Client, I want to be able to call a certain command in the TCP Server which will return a DataReader like object, which I can then iterate through such as:
while dr.Read from the client. In each loop, I would parse out the various fields as in a normal DataReader.The reason I want to do this is to gain the inherent efficiency of the DataReader object since it doesn't first load ALL of the data. To my understanding, the typical TCP Client/Server setup using streams, would first load all of the data on the server, then transport ALL of that data to the client for processing. I want to avoid that, and just stream the data as the client requests through the Read() command which means the connection will remain open to the server while the Read() command is being issued by the client, or until explicitly closed by the client.
View 5 Replies
Mar 28, 2010
Im creating an application that will take a screenshot of the desktop. Save the photo, Then upload it via FTP, And do it every 2 minutes. I know how you all like to say how i can do it, But can someone provide a code since.
View 8 Replies
