asp.net数据库连接及数据库操作类

将连接字符串写在web.config文件里具体为
 <connectionStrings>
  <add name="SQLCONNECTIONSTRING" connectionString="server=.//; Data Source=localhost; Integrated Security=SSPI;Initial Catalog=guest_book;" providerName="System.Data.sqlClient"/>
 </connectionStrings>

然后在ADO.NET操作页面进行连接字符串的定义：
引入命名空间 using System.Configuration;
                  using System.Data.SqlClient;
private string myConnectionString = ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString;//连接字符串的定义操作函数的定义：
        /// <summary>
        /// 执行SQL语句，返回受影响行数，用于执行增删查改操作
        /// </summary>
        public int ExecuteSql(string StrSql)
        {
            using (SqlConnection con=new SqlConnection(myConnectionString))
            {
                using(SqlCommand cmd=new SqlCommand(StrSql,con))
                {
                    con.Open();
                    int row = cmd.ExecuteNonQuery();
                    return row;
                }
            }
        }
           
        /// <summary>
        /// 查询方法的封装，返回dataset对象，主要用于绑定数据源时用到
        /// </summary>
        public  DataSet Search(string StrSql)
        {
            using (SqlConnection con=new SqlConnection(myConnectionString))
            {
                DataSet ds = new DataSet();
                con.Open();
                SqlDataAdapter command = new SqlDataAdapter(StrSql, con);
                command.Fill(ds,"ds");
                return ds;
            }
        }

2009年8月3日