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#程序设计有所帮助。