这个是DataOperate类public class DataOperate
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
public DataOperate()
{
}
public bool DataCom(string sqlstr)
{
con.Open();
SqlCommand sqlcomm = new SqlCommand(sqlstr, con);
try
{
sqlcomm.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
con.Close();
}
}
public bool gvBind(GridView gv, string sqlstr)
{
con.Open();
SqlDataAdapter sqldataadapter = new SqlDataAdapter(sqlstr, con);
DataSet mydataset = new DataSet();
sqldataadapter.Fill(mydataset);
gv.DataSource = mydataset;
try
{
gv.DataBind();
return true;
}
catch
{
return false;
}
finally
{
con.Close();
}
}
public bool dataBind(DataList dl, string sqlstr)
{
con.Open();
SqlDataAdapter myadapter = new SqlDataAdapter(sqlstr, con);
DataSet mydataset = new DataSet();
myadapter.Fill(mydataset);
dl.DataSource = mydataset;
try
{
dl.DataBind();
return true;
}
catch
{
return false;
}
finally
{
con.Close();
}
}
}
{
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
public DataOperate()
{
}
public bool DataCom(string sqlstr)
{
con.Open();
SqlCommand sqlcomm = new SqlCommand(sqlstr, con);
try
{
sqlcomm.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
con.Close();
}
}
public bool gvBind(GridView gv, string sqlstr)
{
con.Open();
SqlDataAdapter sqldataadapter = new SqlDataAdapter(sqlstr, con);
DataSet mydataset = new DataSet();
sqldataadapter.Fill(mydataset);
gv.DataSource = mydataset;
try
{
gv.DataBind();
return true;
}
catch
{
return false;
}
finally
{
con.Close();
}
}
public bool dataBind(DataList dl, string sqlstr)
{
con.Open();
SqlDataAdapter myadapter = new SqlDataAdapter(sqlstr, con);
DataSet mydataset = new DataSet();
myadapter.Fill(mydataset);
dl.DataSource = mydataset;
try
{
dl.DataBind();
return true;
}
catch
{
return false;
}
finally
{
con.Close();
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货