»Dotnet Ads
»Message Boards
Message Boards
Dotnet Books
»Member Details
Register
Login
LogOut
Submit Code
Submit Jobs
Submit Projects
»Competition
Community
Winners
Prizes
Write For Us
Members
»Other Resources
Links
Dotnet Resources
|
Getting multiple resultset from a queryThis code shows you how to get multiple resultset from a query to a datagrid
'' language VB.NET
''Query with 3 select statements
Dim strSQL as String = _
"Select * from Table1;
Select * from Table2;
Select * from Table3;"
Dim DS as New DataSet()
Dim daAdapter as new SqlDataAdapter(strSQL, cnConnection)
daAdapter.Fill(DS)
With dataGrid1
.DataSource = DS.Tables("Table")
.DataBind()
End With
With dataGrid2
.DataSource = DS.Tables("Table1")
.DataBind()
End With
With dataGrid3
.DataSource = DS.Tables("Table2")
.DataBind()
End With
|
|