sqlreader Do...while problem

[Agnes]

drBranchForm = sqldatareader
For Each drBranch In dtUserBranch
Do While drBranchForm.Re ad
.......... Problem (A)
Loop
Next

I found that the datarreader only loop onces , ?? How can I make it restart
the sqldatareader ???
Thanks

[Ken Tucker [MVP]]

Hi,

Here is an working example. Would have to see more of your code to
figure out the problem you are having.

Dim conn As SqlConnection

Dim strConn As String

Dim drCustomer As SqlDataReader

Dim daCustomer As SqlDataAdapter

Dim cmd As SqlCommand

Dim ds As New DataSet

strConn = "Server = " & Environment.Mac hineName & ";"

strConn &= "Database = NorthWind;"

strConn &= "Integrated Security = SSPI;"

conn = New SqlConnection(s trConn)

cmd = New SqlCommand("Sel ect * from Customers", conn)

conn.Open()

drCustomer = cmd.ExecuteRead er

Do While drCustomer.Read

Trace.WriteLine (drCustomer.Ite m("CustomerID") .ToString)

Loop

conn.Close()

Ken

-----------------------------------

"Agnes" <ag***@dynamict ech.com.hk> wrote in message
news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..
drBranchForm = sqldatareader
For Each drBranch In dtUserBranch
Do While drBranchForm.Re ad
.......... Problem (A)
Loop
Next

I found that the datarreader only loop onces , ?? How can I make it restart
the sqldatareader ???
Thanks

[Gary Lam]

Do you know if you have many transaction you need to call NextResult ??

again, need to provide us more code please ^_^

From http://www.developmentnow.com/g/38_2...ile-problem.ht

Posted via DevelopmentNow. com Group
http://www.developmentnow.com

[Gary Lam]

However you can just try something like this.
Dim drBranchForm As SqlDataReader
drBranchForm = myCommand.Execu teReader()
' Always call Read before accessing data.
While drBranchForm.Re ad()
Console.WriteLi ne(( drBranchForm.Ge tInt32(0) & ", " & drBranchForm.Ge tString(1)))
End While
' always call Close when done reading.
drBranchForm.Cl ose()

take out the FOR EACH loop first.

Hope this can help ^_^
From http://www.developmentnow.com/g/38_2...le-problem.htm

Posted via DevelopmentNow. com Groups
http://www.developmentnow.com