这是程序类中的代码?我向请问一下里面的每个函数都是什么意思?做什么?在实现什么功能时才会用到? 小弟刚学C#.net有 很多不懂,希望大家帮帮忙,谢谢啦!
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);
SqlDataReader read = sqlcom.ExecuteReader();
return read;
}
public bool ExceSQL(string strSqlCom)
{
sqlcom = new SqlCommand(strSqlCom, sqlcon);
try
{
sqlcom.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
sqlcon.Close();
}
}
public bool BinData(GridView dl, string SqlCom)
{
dl.DataSource = this.ExceDS(SqlCom);
try
{
dl.DataBind();
return true;
}
catch
{
return false;
}
finally
{
sqlcon.Close();
}
}
}