当前文件： AssignWorkSystem/App_Code/Common/SqlCommon.cs[1K，2009-6-12 11:32:51]，打开代码结构图

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Web;
 5using System.Web.Security;
 6using System.Web.UI;
 7using System.Web.UI.WebControls;
 8using System.Web.UI.WebControls.WebParts;
 9using System.Web.UI.HtmlControls;
10using System.Data.SqlClient;
11using System.Diagnostics;
12
13/**//// <summary>
14/// SqlCommon 的摘要说明
15/// </summary>
16public class SqlCommon
17...{
18    public SqlCommon()
19    ...{
20        //
21        // TODO: 在此处添加构造函数逻辑
22        //
23    }
24
25    public static SqlConnection Connection
26    ...{
27        get
28        ...{
29            return new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["SqlConnString"].ToString());
30        }
31    }
32
33    public static DataSet dsBySql(string sql)
34    ...{
35        DataSet ds = null;
36        using (SqlConnection conn = Connection)
37        ...{
38            conn.Open();
39            SqlDataAdapter da = new SqlDataAdapter(sql, conn);
40            ds = new DataSet();
41            da.Fill(ds);
42            return ds;
43        }
44
45    }
46
47    public static void executeNonQuery(string sql)
48    ...{
49        using (SqlConnection conn = Connection)
50        ...{
51            try
52            ...{
53                conn.Open();
54                SqlCommand cmd = new SqlCommand(sql, conn);
55                cmd.ExecuteNonQuery();
56            }
57            catch (SqlException ex)
58            ...{
59                Debug.WriteLine(ex.ToString());
60            }
61            finally
62            ...{
63                conn.Close();
64            }
65
66        }
67    }
68}
69