Intimate contact asp.net (9)

We continue to the previous content, hehe, this time is mainly about the powerful function of dataset:. The last time we blew up.
Bubbles (The meaning of the words do not count, Hunan people can understand it:), this time must not break the promise:)
Storing multiple data tables in a dataset
Many of us in the ASP are accustomed to using the Recordset object to manipulate the database, but the recordset has a missing
The point is that a recordset can only store one datasheet, and when we need to manipulate multiple tables, we have to work on multiple re
Back and forth in the Cordset, although these are not used after the habit, but for a novice, this is
A very troublesome thing to do. Just those variable names can muddy you, now well, in the ASP.net, only need
A dataset can handle everything. greatly facilitates our program. We still look the same.
Preface, and then to explain carefully.
<% @ Page language= "C #"%>
<% @ Import namespace= "System.Data"%>
<% @ Import namespace= "System.Data.ADO"%>
<script language= "C #" runat= "Server" >
public void Page_Load (Object Src,eventargs E)
{
Join statement
String myConnString = "Driver={microsoft Access Driver (*.mdb)};
Dbq=c:/test/test.mdb; ";
String strComm1 = "SELECT * from UserList";
String strComm2 = "SELECT * from Booklist";
Open a Join
ADOConnection myconnection = new ADOConnection (myConnString);
Open two DataSetCommand
Adodatasetcommand MyComm1 = new Adodatasetcommand (strcomm1,myconnection);
Adodatasetcommand MyComm2 = new Adodatasetcommand (strcomm2,myconnection);
DataSet myDataSet = new DataSet ();
Save a userlist,booklist table in a dataset
Mycomm1.filldataset (myDataSet, "userlist");
Mycomm2.filldataset (myDataSet, "Booklist");
DataGrid1.DataSource = mydataset.tables["UserList"]. DefaultView;