《CSQL数据库操作类》由会员分享,可在线阅读,更多相关《CSQL数据库操作类(2页珍藏版)》请在金锄头文库上搜索。
1、usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Windows.Forms;namespaceyjgl/数据访问基础类(SQL)/classBaseOperate#region建立数据库连接/建立数据库连接./returns返回SqlConnection对象/returnspublicSqlConnectiongetcon()stringM_str_sqlcon=DataSource=PC-2002010100
2、09;Database=db_yjzl;UserID=sa;PWD=123;/连接字符串SqlConnectionmycon=newSqlConnection(M_str_sqlcon);/创建连接对象returnmycon;#endregion#region执行SqlCommand命令/summary/执行SqlCommand/summary/SQL语句publicvoidgetcom(stringM_str_sqlstr)SqlConnectionsqlcon=this.getcon();/获取连接字符串sqlcon.Open();/打开连接trySqlCommandsqlcom=newS
3、qlCommand(M_str_sqlstr,sqlcon);/通过SQL语句和连接对象创建命令对象sqlcom.ExecuteNonQuery();/对sqlcon执行SQL语句并返回受影响的行数sqlcom.Dispose();/释放sqlcomcatch(SqlExceptione)MessageBox.Show(e.ToString(),信息提示,MessageBoxButtons.OK,MessageBoxIcon.Information);finallysqlcon.Close();sqlcon.Dispose();#endregion#region创建DataSet对象/创建一个
4、DataSet对象/paramname=M_str_sqlstrSQL语句/param/paramname=M_str_table表名/param/returns返回DataSet对象/returnspublicDataSetgetds(stringM_str_sqlstr,stringM_str_table)/查询SqlConnectionsqlcon=this.getcon();SqlDataAdaptersqlda=newSqlDataAdapter(M_str_sqlstr,sqlcon);DataSetmyds=newDataSet();sqlda.Fill(myds,M_str_t
5、able);returnmyds;#endregion#region创建SqlDataReader对象/summary/创建一个SqlDataReader对象/summary/paramname=M_str_sqlstrSQL语句/param/returns返回SqlDataReader对象/returnspublicSqlDataReadergetread(stringM_str_sqlstr)SqlConnectionsqlcon=this.getcon();SqlCommandsqlcom=newSqlCommand(M_str_sqlstr,sqlcon);sqlcon.Open();SqlDataReadersqlread=sqlcom.ExecuteReader(CommandBehavior.CloseConnection);returnsqlread;#endregion