ADO.NET 中DataTable中加载数据又两种方法
第一种
第二种
第一种
//
使用fill方法填充DataTable
private void useDataTableByFill()
... {
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConnectionString"].ConnectionString);
DataTable myDataTable = new DataTable();
SqlDataAdapter myDp = new SqlDataAdapter("select * from authors", myConnection);
myDp.Fill(myDataTable);
GridView1.DataSource = myDataTable.DefaultView;
GridView1.DataBind();
myConnection.Dispose();
myDp.Dispose();
}
private void useDataTableByFill()
... {
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConnectionString"].ConnectionString);
DataTable myDataTable = new DataTable();
SqlDataAdapter myDp = new SqlDataAdapter("select * from authors", myConnection);
myDp.Fill(myDataTable);
GridView1.DataSource = myDataTable.DefaultView;
GridView1.DataBind();
myConnection.Dispose();
myDp.Dispose();
}
第二种
//
使用DataReader方法
private void useDataTableByDataReader()
... {
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConnectionString"].ConnectionString);
DataTable myDataTable = new DataTable();
SqlCommand myCommand = new SqlCommand("select * from authors", myConnection);
myConnection.Open();
SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
myDataTable.Load(dr);
GridView1.DataSource = myDataTable.DefaultView;
GridView1.DataBind();
dr.Close();
dr.Dispose();
myCommand.Dispose();
}
private void useDataTableByDataReader()
... {
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlConnectionString"].ConnectionString);
DataTable myDataTable = new DataTable();
SqlCommand myCommand = new SqlCommand("select * from authors", myConnection);
myConnection.Open();
SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
myDataTable.Load(dr);
GridView1.DataSource = myDataTable.DefaultView;
GridView1.DataBind();
dr.Close();
dr.Dispose();
myCommand.Dispose();
}