代码一如下:
SqlConnection MyConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
string strSel1 = "select * from yqlj order by px asc";
DataSet MyDataSet = new DataSet();
SqlDataAdapter myCommand = new SqlDataAdapter(strSel1,MyConnection);
myCommand.Fill(MyDataSet);
DataList4.DataSource=MyDataSet;
DataList4.DataBind();代码二如下:
SqlConnection MyConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
string strSel1 = "select * from yqlj order by px asc";
DataSet MyDataSet = new DataSet();
SqlDataAdapter myCommand = new SqlDataAdapter(strSel1,MyConnection);
myCommand.Fill(MyDataSet);
DataList4.DataSource=MyDataSet;
DataList4.DataBind();
//释放SqlDataAdapter
myCommand.Dispose();
请问一下这两个代码有什么区别,我一直用第一种,不知你二种好在哪里?
SqlConnection MyConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
string strSel1 = "select * from yqlj order by px asc";
DataSet MyDataSet = new DataSet();
SqlDataAdapter myCommand = new SqlDataAdapter(strSel1,MyConnection);
myCommand.Fill(MyDataSet);
DataList4.DataSource=MyDataSet;
DataList4.DataBind();代码二如下:
SqlConnection MyConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
string strSel1 = "select * from yqlj order by px asc";
DataSet MyDataSet = new DataSet();
SqlDataAdapter myCommand = new SqlDataAdapter(strSel1,MyConnection);
myCommand.Fill(MyDataSet);
DataList4.DataSource=MyDataSet;
DataList4.DataBind();
//释放SqlDataAdapter
myCommand.Dispose();
请问一下这两个代码有什么区别,我一直用第一种,不知你二种好在哪里?
using(SqlConnection MyConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]))
{
string strSel1 = "select * from yqlj order by px asc";
DataSet MyDataSet = new DataSet();
SqlDataAdapter myCommand = new SqlDataAdapter(strSel1,MyConnection);
myCommand.Fill(MyDataSet);
//释放SqlDataAdapter
myCommand.Dispose();
DataList4.DataSource=MyDataSet;
DataList4.DataBind();
}其实也不怎么好...