DataReader Read() Command Hangs For Up To 30 Minutes
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.
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
I have two datareaders: [Code] When i'm running the code i get this error in the highlighted line: "There is already an open DataReader associated with this Command which must be closed first." I used different variables in both readers, why do i get this error? do i have to open a new sqlConnection for this task?
and in class that starts new thread started every time users change some data(very often)
[Code]...
1. other parts of application are targeting other SQL server...just this adapter is updating only one row(table has two columns, some id and last time any of users changed something.
This reader is done in the form load event and is the very first thing done so I don't understand why it's telling me there is an open DataReader. I've also set MARS=True in my connection string so obviously it is something else.Here's my code and like I said the routine is called at the top of the form load event. The error occurs on the
I get the following message "There is already an open DataReader associated with this Command which must be closed first." Is the insert statement the most effiecient way to write to the table row by row?
Dim comment As String Dim cnx As Data.SqlClient.SqlConnection = SqlCnx.SourceDB Dim cmd As New Data.SqlClient.SqlCommand("select number,comment from [Comments]", cnx) Dim daComments As New SqlClient.SqlDataAdapter Dim bsComments As New BindingSource cmd.CommandTimeout = "360" cmd.CommandType = CommandType.Text cnx.Open()
I'm trying to put together a quick example for another thread about treeviews, and I'm getting a problem when I have a recursive routine, getting the message.
Quote:
There is already an open DataReader associated with this Command which must be closed first.
I'm a tad confused as I am explicitly creating a new command every time through the loop, so I'm not sure (unless its something ADO is doing behind the scenes) how the datareaders higher up the tree are interfering.
Here's my code :
Private Sub SetupChildren(ByVal ParentID As Integer, ByRef ParentNode As TreeNode) Dim MyCommand As New SqlCommand("SELECT * FROM Groups WHERE ParentGroup=@ParentGroup", m_myConnection)
[Code]...
Obviously I could close the data reader down before calling the next level of recursion but it would prevent the code continuing the loop at the current level when it had finished processing children.
I am trying to check the value of a field before decided what to input into a drop down list in ASP.net.
I am using datareader.Read() in order to read the recordset so I can do this. However this then skips the first row of data . . The drop down box is basically a list of sizes and colours . . . So currently I am missing the first size.
Here is the code:
Using cmd As New SqlCommand("doGetAllSizesForProduct", oConn) cmd.CommandType = CommandType.StoredProcedure cmd.Parameters.AddWithValue("@id", CType(Request.QueryString("id"), Integer))
What i want to do is to read a value either null or not null from my oracle database using DataReader and store in a textbox. But i have an error.InvalidOperationExcepionHow can i avoid this error.Or is it possible to catch the exception to ignore null values read by the datareader?If the option is to catch the exception how may i do it?
Dim Dr1 As OleDb.OleDbDataReader = Cmd3.ExecuteReader Dr1.Read() lect_name = Dr1.GetValue(1).ToString
i have a form with one combobox and textbox now on other hand i have a sql database named balance with two column one as customername and and another as obbalance now i had binded all the customer name to the combobox now what i have to do is wen user selects a customername from the combobox the textbox should show the obbalance of the selected?
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 ?
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"
I'm looking to read from a command prompt window so I can redirect the output to my project. I've looked all over the net and the only codes that I've seen don't work in VB 2008.
I'm making a program that has to execute commands in cmd.exe, but without actually opening it. I set RedirectStandardOutput to True, and I need a way to read the result of the command from the stream. Right now, I use ReadToEnd(), but there's no end to the stream, apparently. How do I read the result of the command?[code]...
I'm working on a small project that lets me read and write to and from command prompt, i have this code but one line does not work .Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click[code]...
How can I get a label to display what a command line application is showing. I made it so it can show the final result, but I want it to update live as the app is running.
I have made an application that requires executing an external command prompt application, and I need to be able to read the result from its completion of each file it processes.
The external application works by specifying an input directory, it then scans for a series of compatible files and then converts them all one by one in a single command. I need to be able to read each line it writes and provide the appropriate feedback in my application. It would be nice if i could hide the window it creates too. Code I have tried working from:
Code: Private Sub btnRead_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRead.Click Dim CMD As New Threading.Thread(AddressOf GETCMD)
Just wondering if there is anyway to read each line of text that is output from a console application?
Basically I want to use PSEXEC through a vb.net GUI application and I would like to be able to read any error codes that may occur from the command line.
how do i have my app read a line from a textfile and if that line equals "whatever" proceed with command, this case a msgbox.so much work to do and so many choices to choose from...
I am using this to capture output from the command line: url...Is there a way to modify that, so I can get the results as they are updated? [code]Is there a way to capture that output every time it is updated so I can change a text box as it get updated?
I'll start off by saying I am using Visual Studio 2008 Standard. I am creating a program that will open installed programs using short code. For instance, if a user types in 'npp' then Notepad++ opens. I have it working just fine to respond to the predefined commands, but I would like to expand it so that the user can define their own settings simply by typing the program directory and the custom short code they want: Example: If I am an end user and would like to say define a short code for Windows Media Player, I would simply type the following: (Assuming Excel or likewise is used to open the csv file).
Hey Overflow, I have an application which serves as a user interface for a spartan/command line program.
I have the program running on a separate process, and my application monitors it to see if it is responding and how mush CPU it is utilising.
Now I have a list of files in my program (listbox) which are to be sent to the application, which happens fine. But I want to be able to read text from the com-line so as to determine when the first file has been processed.
Com-line says one of "selecting settings", "unsupported format" and "cannot be fixed". What I want to be able to do is when it says one of these three things, remove item(0) in listbox1.
I thought of programming an event which handles com_exe.print or something or other, if possible.
I have an application that provides a countdown for 60 minutes and I'm currently using the win form timer and it updates some labels and a progressbar. Now I have to change this to be a countdown for 360 minutes. Will the win form timer be sufficient or should I implement a Timers.Timer instead?