[Visual Basic]
Dim myCMD As SqlCommand = New SqlCommand("SELECT CategoryID, CategoryName FROM Categories;" & _ "SELECT EmployeeID, LastName FROM Employees", nwindConn) nwindConn.Open() Dim myReader As SqlDataReader = myCMD.ExecuteReader() Dim fNextResult As Boolean = True Do Until Not fNextResult Console.WriteLine(vbTab & myReader.GetName(0) & vbTab & myReader.GetName(1)) Do While myReader.Read() Console.WriteLine(vbTab & myReader.GetInt32(0) & vbTab & myReader.GetString(1)) Loop fNextResult = myReader.NextResult() Loop myReader.Close() nwindConn.Close() |