protected void Button1_Click1(object sender, EventArgs e)
{
string constr = "Data Source=.;initial catalog=Test;user id=sa;password=910809";
string sql = "select * from MyStudents";
SqlDataAdapter adpter = new SqlDataAdapter(sql, constr);//内部自动生成connection对象和command对象
#region Adapter到数据集dataset中
System.Data.DataSet ds = new System.Data.DataSet();
adpter.Fill(ds);
#endregion
#region Adapter到数据表DataTable中
DataTable dt = new DataTable();
adpter.Fill(dt);
// 在sqlDataAdapter中会封装sqlconnection,sqlcommand,sqldatareader这些东西。
#endregion
GridView1.DataSource = ds;
GridView1.DataBind();
效果图: