在网页中添加一个GradView，一个Button，一点button将MyStudents表中的数据显示在GradView中(DataSet，DataTable，List（选作）)

---DataSet2.aspx--
    </div>
    <asp:GridView ID="GridView1" runat="server">
    </asp:GridView>
    <br />
    <asp:Button ID="Button1" runat="server" οnclick="Button1_Click" Text="Button" />
-------DataSet2.aspx.cs----------
   protected void Button1_Click(object sender, EventArgs e)
        {
            string constr = "Data Source=LOVE-PC\\SQLEXPRESSPC;Initial catalog=School;user id=sa;password=admin";
            string sql = "select * from MyStudents";

            SqlDataAdapter adpter=new SqlDataAdapter(sql,constr);//内部自动商城connection对象和command对象
            #region  //Adapter到数据集dataset中
            //DataSet ds = new DataSet();
            //adpter.Fill(ds);
            //GridView1.DataBind();
            //GridView1.DataSource = ds.Tables[0];
            //GridView1.DataBind();
         #endregion

           

            #region Adapter到数据表中Datable
            DataTable dt = new DataTable();

            //在SqlDataAdapter中会封装sqlconnection,sqlcommand,sqldatareader这些东西
            adpter.Fill(0, 10, dt);
            #endregion
            GridView1.DataSource = dt;
            GridView1.DataBind();
          
        }