SQL Server数据库基本操作类

苏童

http://blog.51cto.com/images/editer/InBlock.gifusing System;

http://blog.51cto.com/images/editer/InBlock.gifusing System.Collections.Generic;

http://blog.51cto.com/images/editer/InBlock.gifusing System.Text;

http://blog.51cto.com/images/editer/InBlock.gif

http://blog.51cto.com/images/editer/InBlock.gifnamespace map_1.baseclass

http://blog.51cto.com/images/editer/InBlock.gif{

http://blog.51cto.com/images/editer/InBlock.gif        class Sql_DataBase

http://blog.51cto.com/images/editer/InBlock.gif        {

http://blog.51cto.com/images/editer/InBlock.gif建立数据库连接#region    建立数据库连接

http://blog.51cto.com/images/editer/InBlock.gif                ///

http://blog.51cto.com/images/editer/InBlock.gif                /// 建立数据库连接.

http://blog.51cto.com/images/editer/InBlock.gif                ///

http://blog.51cto.com/images/editer/InBlock.gif                /// 返回SqlConnection对象

http://blog.51cto.com/images/editer/InBlock.gif                public SqlConnection Get_con()

http://blog.51cto.com/images/editer/InBlock.gif                {

http://blog.51cto.com/images/editer/InBlock.gif                        string sqlstr = "Data Source=;Database=;Integrated Security=SSPI";

http://blog.51cto.com/images/editer/InBlock.gif                        SqlConnection myCoon = new SqlConnection(sqlstr);

http://blog.51cto.com/images/editer/InBlock.gif                        return myCoon;

http://blog.51cto.com/images/editer/InBlock.gif                }

http://blog.51cto.com/images/editer/InBlock.gif                #endregion

http://blog.51cto.com/images/editer/InBlock.gif

http://blog.51cto.com/images/editer/InBlock.gif执行SqlCommand命令#region    执行SqlCommand命令

http://blog.51cto.com/images/editer/InBlock.gif                ///

http://blog.51cto.com/images/editer/InBlock.gif                /// 执行SqlCommand

http://blog.51cto.com/images/editer/InBlock.gif                ///

http://blog.51cto.com/images/editer/InBlock.gif                /// SQL语句

http://blog.51cto.com/images/editer/InBlock.gif                public void getcom(string M_sqlstr)

http://blog.51cto.com/images/editer/InBlock.gif                {

http://blog.51cto.com/images/editer/InBlock.gif                        SqlConnection sqlcon = this.getcon();

http://blog.51cto.com/images/editer/InBlock.gif                        sqlcon.Open();

http://blog.51cto.com/images/editer/InBlock.gif                        SqlCommand sqlcom = new SqlCommand(M_sqlstr, sqlcon);

http://blog.51cto.com/images/editer/InBlock.gif                        sqlcom.ExecuteNonQuery();

http://blog.51cto.com/images/editer/InBlock.gif                        sqlcom.Dispose();

http://blog.51cto.com/images/editer/InBlock.gif                        sqlcon.Close();

http://blog.51cto.com/images/editer/InBlock.gif                        sqlcon.Dispose();

http://blog.51cto.com/images/editer/InBlock.gif                }

http://blog.51cto.com/images/editer/InBlock.gif                #endregion

http://blog.51cto.com/images/editer/InBlock.gif

http://blog.51cto.com/images/editer/InBlock.gif创建DataSet对象#region    创建DataSet对象

http://blog.51cto.com/images/editer/InBlock.gif                ///

http://blog.51cto.com/images/editer/InBlock.gif                /// 创建一个DataSet对象

http://blog.51cto.com/images/editer/InBlock.gif                ///

http://blog.51cto.com/images/editer/InBlock.gif                /// SQL语句

http://blog.51cto.com/images/editer/InBlock.gif                /// 表名

http://blog.51cto.com/images/editer/InBlock.gif                /// 返回DataSet对象

http://blog.51cto.com/images/editer/InBlock.gif                public DataSet getds(string M_sqlstr, string M_table)

http://blog.51cto.com/images/editer/InBlock.gif                {

http://blog.51cto.com/images/editer/InBlock.gif                        SqlConnection sqlcon = this.getcon();

http://blog.51cto.com/images/editer/InBlock.gif                        SqlDataAdapter sqlda = new SqlDataAdapter(M_sqlstr, sqlcon);

http://blog.51cto.com/images/editer/InBlock.gif                        DataSet myds = new DataSet();

http://blog.51cto.com/images/editer/InBlock.gif                        sqlda.Fill(myds, M_table);

http://blog.51cto.com/images/editer/InBlock.gif                        return myds;

http://blog.51cto.com/images/editer/InBlock.gif                }

http://blog.51cto.com/images/editer/InBlock.gif                #endregion

http://blog.51cto.com/images/editer/InBlock.gif

http://blog.51cto.com/images/editer/InBlock.gif创建SqlDataReader对象#region    创建SqlDataReader对象

http://blog.51cto.com/images/editer/InBlock.gif                ///

http://blog.51cto.com/images/editer/InBlock.gif                /// 创建一个SqlDataReader对象

http://blog.51cto.com/images/editer/InBlock.gif                ///

http://blog.51cto.com/images/editer/InBlock.gif                /// SQL语句

http://blog.51cto.com/images/editer/InBlock.gif                /// 返回SqlDataReader对象

http://blog.51cto.com/images/editer/InBlock.gif                public SqlDataReader getread(string M_sqlstr)

http://blog.51cto.com/images/editer/InBlock.gif                {

http://blog.51cto.com/images/editer/InBlock.gif                        SqlConnection sqlcon = this.getcon();

http://blog.51cto.com/images/editer/InBlock.gif                        SqlCommand sqlcom = new SqlCommand(M_sqlstr, sqlcon);

http://blog.51cto.com/images/editer/InBlock.gif                        sqlcon.Open();

http://blog.51cto.com/images/editer/InBlock.gif                        SqlDataReader sqlread = sqlcom.ExecuteReader(CommandBehavior.CloseConnection);

http://blog.51cto.com/images/editer/InBlock.gif                        return sqlread;

http://blog.51cto.com/images/editer/InBlock.gif                }

http://blog.51cto.com/images/editer/InBlock.gif                #endregion

http://blog.51cto.com/images/editer/InBlock.gif        }

http://blog.51cto.com/images/editer/InBlock.gif}