执行查询之后获取到datareader 转到datatable

 private void  select() /*查询按钮*/
        {
            string strDB ="Provider=Microsoft.Jet.OleDb.4.0;" + "data source=E:\\test.mdb";
                   
           
            using(OleDbConnection conn =new OleDbConnection(strDB))
            {
               conn.Open();
                      

              /*用DataReader来填充DataTable*/

              string select = @"select * from result";

              OleDbCommand cmd = new OleDbCommand(select,conn); 

              OleDbDataReader dr = cmd.ExecuteReader();   /*执行查询，获取一个datareader*/

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

               dr.Close();                        /*关闭 DataReader*/

               dataGridView1.DataSource=dt;
              
               conn.Close();      /*关闭连接r*/
               
            }
        }