Re: Returning multiple resultsets usind datadreader
- From: "Cor Ligthert[MVP]" <notmyfirstname@xxxxxxxxx>
- Date: Thu, 23 Aug 2007 05:29:38 +0200
Peter,
Can you explain me why you use this method, as far as I can see it now, it is going from NY to Wasinton to Jersey City over LA.
Normally we use direct the DataAdapter Fill, however there should be a reason?
It cannot be that it is quicker, because that is AFAIK culprit, you have to write at least more code while the result is the same, although you need probably after what you do now at least an acceptchanges of course, which is automaticly done by the fill.
However, there must be a reason and I am currious about that?
Cor
"Peter" <Peter@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht news:DFE56B5A-9795-4E18-99B8-C2F7829C1CCF@xxxxxxxxxxxxxxxx
I'm using this coding to get 2 resultsets thru datareader and then load them
into 2 datatables and bind the datatables to datagridviews. But
sdrGrid.NextResult() is returning false for some reason. Is that possible
the connection is closed?
Dim strConn As String = "Server=localhost;Database=northwind;" + _
"Integrated Security=SSPI"
Dim cnnNwind As SqlConnection = New SqlConnection(strConn)
Try
Dim strSql As String = "select * from customers;select * from
products"
Dim cmdGrid As New SqlCommand(strSql, cnnNwind)
cmdGrid.CommandType = CommandType.Text
cnnNwind.Open()
Dim sdrGrid As SqlDataReader = cmdGrid.ExecuteReader
Dim dt1 As New DataTable
dt1.Load(sdrGrid)
DGVP.DataSource = dt1
Dim dt2 As New DataTable
If sdrGrid.NextResult() = True Then
dt2.Load(sdrGrid)
DGVC.DataSource = dt2
End If
Catch exc As Exception
MsgBox(exc.Message)
Finally
cnnNwind.Close()
End Try
.
- Follow-Ups:
- Prev by Date: Re: My.Settings files
- Next by Date: Re: Delaying Program Execution in a Loop
- Previous by thread: Re: Set Focus to a ToolStripTextBox
- Next by thread: Re: Returning multiple resultsets usind datadreader
- Index(es):
Relevant Pages
|
