C#的SQL操作类实例
本文实例讲述了C#的SQL操作类，分享给大家供大家参考。具体方法如下：
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Text;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingSystem.Windows.Forms;
namespaceyjgl
{
///<summary>
///数据访问基础类(SQL)
///</summary>
classBaseOperate
{
#region 建立数据库连接
///<summary>
///建立数据库连接.
///</summary>
///<returns>返回SqlConnection对象</returns>
publicSqlConnectiongetcon()
{
stringM_str_sqlcon="DataSource=PC-200201010009;Database=db_yjzl;UserID=sa;PWD=123";//连接字符串
SqlConnectionmycon=newSqlConnection(M_str_sqlcon); //创建连接对象
returnmycon;
}
#endregion
#region 执行SqlCommand命令
///<summary>
///执行SqlCommand
///</summary>
///<paramname="M_str_sqlstr">SQL语句</param>
publicvoidgetcom(stringM_str_sqlstr)
{
SqlConnectionsqlcon=this.getcon(); //获取连接字符串
sqlcon.Open(); //打开连接
try
{
SqlCommandsqlcom=newSqlCommand(M_str_sqlstr,sqlcon); //通过SQL语句和连接对象创建命令对象
sqlcom.ExecuteNonQuery(); //对sqlcon执行SQL语句并返回受影响的行数
sqlcom.Dispose(); //释放sqlcom'
}
catch(SqlExceptione)
{
MessageBox.Show(e.ToString(),"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
finally
{
sqlcon.Close();
sqlcon.Dispose();
}
}
#endregion
#region 创建DataSet对象
///<summary>
///创建一个DataSet对象
///</summary>
///<paramname="M_str_sqlstr">SQL语句</param>
///<paramname="M_str_table">表名</param>
///<returns>返回DataSet对象</returns>
publicDataSetgetds(stringM_str_sqlstr,stringM_str_table) //查询
{
SqlConnectionsqlcon=this.getcon();
SqlDataAdaptersqlda=newSqlDataAdapter(M_str_sqlstr,sqlcon);
DataSetmyds=newDataSet();
sqlda.Fill(myds,M_str_table);
returnmyds;
}
#endregion
#region 创建SqlDataReader对象
///<summary>
///创建一个SqlDataReader对象
///</summary>
///<paramname="M_str_sqlstr">SQL语句</param>
///<returns>返回SqlDataReader对象</returns>
publicSqlDataReadergetread(stringM_str_sqlstr)
{
SqlConnectionsqlcon=this.getcon();
SqlCommandsqlcom=newSqlCommand(M_str_sqlstr,sqlcon);
sqlcon.Open();
SqlDataReadersqlread=sqlcom.ExecuteReader(CommandBehavior.CloseConnection);
returnsqlread;
}
#endregion
}
}
希望本文所述对大家的C#程序设计有所帮助。