使用动态生成DataTable后,把DataTable绑定到DataGrid

  ///

   DataTable dt = new DataTable();
   dt.Columns.Add(new DataColumn("字段0标题", typeof(string)));
   dt.Columns.Add(new DataColumn("字段1标题", typeof(string)));
   dt.Columns.Add(new DataColumn("字段2标题", typeof(string)));
   dt.Columns.Add(new DataColumn("字段3标题", typeof(string)));
   dt.Columns.Add(new DataColumn("字段4标题", typeof(string)));

   SqlCommand cmd2 = new SqlCommand(strSql,db.conn);
   cmd2.Connection.Open();
   SqlDataReader dr1 = cmd2.ExecuteReader();
   
   while(dr1.Read())
   {
    DataRow dd;
    dd = dt.NewRow();
    dd[0] = "";
    dd[1] = ""+dr1["txtemname"].ToString()+"" ;
    dd[2] =  dr1["em_position"];
    dd[3] =  dr1["txtemmobile"];
    dt.Rows.Add(dd);
   }
   cmd2.Connection.Close();
   DataView dv = new DataView(dt);
   DataGrid1.DataSource =dv;
   DataGrid1.DataBind();
  }