1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using System.Data.SqlClient;
 5using System.Data;
 6
 7//该源码下载自www.51aspx.com(5１ａｓｐｘ．ｃｏｍ)
 8    //数据库操作类
 9    public class Sql
10    ...{
11        private string str = null;//数据库连接字符串
12        public SqlConnection Con;//sql数据连接组件实例化
13        public SqlCommand command = new SqlCommand();//初始化一个sql命令对象
14        public Sql()//类初始化，初始化数据连接连接
15        ...{
16            string path = System.Web.HttpContext.Current.Server.MapPath(System.Web.HttpContext.Current.Request.ApplicationPath);
17           // str = "Data Source=.\\SQLEXPRESS;AttachDbFilename=\"" + path + "\app_data\\ad.mdf\";Integrated Security=True;User Instance=True";
18            str = "Data Source=(local);Initial Catalog=ad;uid=sa;pwd=sa;";
19            
20            Con = new SqlConnection(str);
21        }
22        执行sql语句的代码#region 执行sql语句的代码
23        // 输入查询字符串，返回dataset
24        public DataSet getMyDataSet(string sql)
25        ...{
26            command.Connection = Con;//配置command对象
27            command.CommandText = sql;
28            DataSet dt = new DataSet();//初始化一个数据返回集合
29            SqlDataAdapter da = new SqlDataAdapter(command);
30            Con.Open();
31            da.Fill(dt);//执行语句
32
33            command.Connection.Close();//关闭连接
34            return dt;
35        }
36        // 执行非查询sql语句
37        public int  ExecuteSql(string sql)
38        ...{
39            if (Con.State != ConnectionState.Open)
40                Con.Open();//如果数据连接关闭，则打开
41            SqlCommand Com = new SqlCommand(sql, Con);
42          int result=  Com.ExecuteNonQuery();//执行非查询sql语句
43            Con.Close();
44            return result;
45        }
46        #endregion
47        执行存储过程的代码#region 执行存储过程的代码
48        //输入存储过程名称，执行查询存储过程
49        public DataSet getDataSet(string produreName)
50        ...{
51            command.Connection = Con;//赋予连接对象
52            command.CommandType = CommandType.StoredProcedure;//执行的类型为存储过程
53            command.CommandText = produreName;//赋予执行的存储过程名字
54            DataSet dt = new DataSet();
55            SqlDataAdapter da = new SqlDataAdapter(command);
56            Con.Open();//打开连接
57            da.Fill(dt);//填充数据
58            command.Connection.Close();
59            return dt;//返回数据集
60        }
61        //输入存储过程名，执行非查询存储过程
62        public bool exec(string produreName)
63        ...{
64            bool flag = false;//任务是否正确执行，初始化为false
65            command.Connection = Con;//赋予command对象以数据连接
66            command.CommandType = CommandType.StoredProcedure;
67            command.CommandText = produreName;
68            if (Con.State == ConnectionState.Closed) Con.Open();
69            try
70            ...{
71                command.ExecuteNonQuery();//执行存储过程
72                flag = true;//正确完成任务
73            }
74            finally
75            ...{
76                command.Connection.Close();//关闭连接
77            }
78            return flag;
79        }
80        #endregion
81    }
82    //该源码下载自www.51aspx.com(5１ａｓｐｘ．ｃｏｍ)