当前文件： myAjaxDropdownlist/App_Code/SqlDataAccess.cs[3K，2009-6-12 11:48:08]，打开代码结构图

		            
 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;
11
12/**//// <summary>
13/// SqlDataAccess 的摘要说明
14/// </summary>
15public class SqlDataAccess
16...{
17    public SqlDataAccess()
18    ...{
19        //
20        // TODO: 在此处添加构造函数逻辑
21        //
22    }
23    /**//// <summary>
24    /// 获取省的信息
25    /// </summary>
26    /// <param name="id"></param>
27    /// <returns></returns>
28    public static DataSet GetProvinceInfo()
29    ...{
30
31        string sql = "select * from province";
32        SqlCommand cmd = new SqlCommand();
33        //定义对象资源保存的范围，一旦using范围结束，将释放对方所占的资源
34        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
35        ...{
36            //调用执行方法，因为没有参数，所以最后一项直接设置为null
37            //注意返回结果是dataset类型
38            DataSet myds = SqlHelper.ExecuteDataSet(CommandType.Text, sql);
39            return myds;
40        }
41    }
42/**//// <summary>
43/// 获得市的信息
44/// </summary>
45/// <returns></returns>
46    public static DataSet GetCityInfo(string  sheng)
47    ...{
48
49        string sql = "select * from city where provinceId=" + sheng + "";
50        SqlCommand cmd = new SqlCommand();
51        //定义对象资源保存的范围，一旦using范围结束，将释放对方所占的资源
52        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
53        ...{
54            //调用执行方法，因为没有参数，所以最后一项直接设置为null
55            //注意返回结果是dataset类型
56            DataSet myds = SqlHelper.ExecuteDataSet(CommandType.Text, sql);
57            return myds;
58        }
59    }
60    /**//// <summary>
61    /// 获得区的信息
62    /// </summary>
63    /// <returns></returns>
64    public static DataSet GetAreaInfo(string shi)
65    ...{
66
67        string sql = "select * from area where cityId=" + shi + "";
68        SqlCommand cmd = new SqlCommand();
69        //定义对象资源保存的范围，一旦using范围结束，将释放对方所占的资源
70        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
71        ...{
72            //调用执行方法，因为没有参数，所以最后一项直接设置为null
73            //注意返回结果是dataset类型
74            DataSet myds = SqlHelper.ExecuteDataSet(CommandType.Text, sql);
75            return myds;
76        }
77    }
78    /**//// <summary>
79    /// 
80    /// </summary>
81    /// <param name="sql"></param>
82    /// <returns></returns>
83    public static DataSet GetInfo(string sql)
84    ...{
85        SqlCommand cmd = new SqlCommand();
86        //定义对象资源保存的范围，一旦using范围结束，将释放对方所占的资源
87        using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
88        ...{
89            //调用执行方法，因为没有参数，所以最后一项直接设置为null
90            //注意返回结果是dataset类型
91            DataSet myds = SqlHelper.ExecuteDataSet(CommandType.Text, sql);
92            return myds;
93        }
94    }
95}
96