Hi,<BR>I have stored procedure that returns two "select" results. (old recordsets). The first result I use to populate some parameters. The second result I want to save as a dataset<BR><BR>Public Class Customer<BR> Public name as String<BR> Public address as string<BR> Public accounts as dataset()<BR>End Class<BR><BR>Dim result As SqlDataReader = myCommand.ExecuteReader()<BR>Dim myCust As New Customer()<BR><BR>' Read the resultset<BR>While result.Read()<BR> myCust.Company = result("company")<BR> myCust.Name = result("name")<BR>End While<BR><BR>result.NextResult()<BR>'how do I populate the accounts dataset with the results of the next select statement????<BR><BR><BR>
using NextResult()
- Thread starter Gentolase
- Start date