当前文件： DutySystem/App_Code/Common/ShareCommon.cs[1K，2009-6-12 11:41:29]，打开代码结构图

		            
 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/// ShareCommon 的摘要说明
15/// </summary>
16public class ShareCommon
17...{
18    public ShareCommon()
19    ...{
20        //
21        // TODO: 在此处添加构造函数逻辑
22        //
23    }
24
25    string sqlConnectionString = string.Empty;
26
27    public static string SqlConnectionString
28    ...{
29        get ...{ return 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 = new SqlConnection(SqlConnectionString))
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    public static void executeNonQuery(string sql)
47    ...{
48        using (SqlConnection conn = new SqlConnection(SqlConnectionString))
49        ...{
50            try
51            ...{
52                conn.Open();
53                SqlCommand cmd = new SqlCommand(sql, conn);
54                cmd.ExecuteNonQuery();
55            }
56            catch (SqlException ex)
57            ...{
58                Debug.WriteLine(ex.ToString());
59            }
60            finally
61            ...{
62                conn.Close();
63            }
64
65        }
66    }
67
68   
69}
70