A sample of the difference between a dataset and a DataTable _ Practical tips

DataSet: DataSet. Typically contains multiple DataTable, in which dataset["table name" is used to get the DataTable

DataTable: Data table.

One:
SqlDataAdapter
Da=new
SqlDataAdapter (CMD);
DataTable
Dt=new
DataTable ();
Da. Fill (DT);
-----------------
Put the data directly into the
In a DataTable,

Two:
SqlDataAdapter
Da=new
SqlDataAdapter (CMD);
DataSet
Dt=new
DataSet ();
Da. Fill (DT);
－－－－－－－－－－－－－－－－
The data results are placed in the dataset, and to use that DataTable, you can do this: dataset[0]

More common usage:
SqlDataAdapter
Da=new
SqlDataAdapter (CMD);
DataSet
Dt=new
DataSet ();
Da. Fill (DT, "Table1");
When used: This Takes a DataTable:
dataset["Table1"]

Specific applications:
SqlConnection con = new SqlConnection ("server=.; database=stucoursedb1;uid=sa;pwd=xhz; ");
SqlDataAdapter SDA = new SqlDataAdapter ("SELECT * from student", con);
DataSet ds = new DataSet ();
Sda. Fill (ds, "stutable");
This. Gridview1.datasource = ds. tables["Stutable"];
This. Gridview1.databind ();
Ds. Dispose ();
Con. Close ();
Con. Dispose ();