【求助】c#.net 类中一段代码的解释
来源:百度知道 编辑:UC知道 时间:2024/06/03 01:16:22
public class SqlData
{
private SqlConnection sqlcon;
private SqlCommand sqlcom;
private SqlDataAdapter sqldata;
public SqlData()
{
sqlcon = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
sqlcon.Open();
}
public DataSet ExceDS(string SqlCom)
{
try
{
sqlcom = new SqlCommand(SqlCom, sqlcon);
sqldata = new SqlDataAdapter();
sqldata.SelectCommand = sqlcom;
DataSet da = new DataSet();
sqldata.Fill(da);
return da;
}
finally
{
sqlcon.Close();
}
}
public SqlDataReader ExceRead(string SqlCom)
{
sqlcom = new SqlCommand(SqlCom,sqlcon);
public class SqlData
{
private SqlConnection sqlcon;
private SqlCommand sqlcom;
private SqlDataAdapter sqldata;
public SqlData()
{
sqlcon = new SqlConnection(ConfigurationManager.AppSettings["conStr"]); //取配置文件的连接字符串
sqlcon.Open(); //打开数据库
}
//传进来一个sql文,绑定到dataset,返回dataset对象。
public DataSet ExceDS(string SqlCom)
{
try
{
sqlcom = new SqlCommand(SqlCom, sqlcon);
sqldata = new SqlDataAdapter();
sqldata.SelectCommand = sqlcom;
DataSet da = new DataSet();
sqldata.Fill(da);
return da;
}
finally
{
sqlcon.Close(); //关闭数据库
}
}
//传进来一个sql文,主要用于检索数据的时候。
public SqlDataReader ExceRead(string SqlCom)
{
sqlcom = new SqlCommand(SqlCom,sqlcon);
SqlDataReader read = sqlcom.ExecuteReader();
return read;
}
//传进来一个sql文,update,insers,delect 时候使用
true成功,false 失败
public bo