datatable 和datareader

           public void select(){

string source ="Provider=Microsoft.Jet.OleDb.4.0;" + "data source=E:\\test.mdb";

            using(OleDbConnection conn =new OleDbConnection(source))
            {
               conn.Open();
                      

         

              string select = @"select * from result";

              OleDbCommand cmd = new OleDbCommand(select,conn); 

              OleDbDataReader dr = cmd.ExecuteReader();   /*创建一个reader*/

              DataTable dt= new DataTable();  /*存放要在Gridview里面显示的最后结果*/
              dt.Load(dr);     /*就这一句用DataReader来把查询到的数据插入到DataTable中*/

               dr.Close();                        /*记得用完要关闭reader*/

              GridView1.DataSource=dt;
              

               conn.Close();

}