当前文件路径：AJAXGetWeather/App_Code/WebService.cs

		            
 1using System;
 2using System.Web;
 3using System.Collections;
 4using System.Web.Services;
 5using System.Web.Services.Protocols;
 6using AjaxControlToolkit;
 7using System.Data;
 8using System.Data.SqlClient;
 9using System.Collections.Generic;
10using System.Collections.Specialized;
11/**//// <summary>
12/// WebService 的摘要说明
13/// </summary>
14[WebService(Namespace = "http://tempuri.org/")]
15[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
16[System.Web.Script.Services.ScriptService]
17public class WebService : System.Web.Services.WebService
18...{
19
20    public WebService()
21    ...{
22
23        //如果使用设计的组件，请取消注释以下行 
24        //InitializeComponent(); 
25    }
26
27    [WebMethod]
28    public CascadingDropDownNameValue[] GetCapital(string knownCategoryValues, string category)
29    ...{
30        List<CascadingDropDownNameValue> provinceList = new List<CascadingDropDownNameValue>();
31
32        string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
33
34        SqlConnection sqlConn = new SqlConnection(connectionString);
35
36        sqlConn.Open();
37
38        string strSql = "Select * From Capital order by CapitalID";
39
40        SqlCommand sqlCmd = new SqlCommand(strSql, sqlConn);
41
42        SqlDataReader dtrProvince = sqlCmd.ExecuteReader();
43
44        while (dtrProvince.Read())
45        ...{
46            provinceList.Add(new CascadingDropDownNameValue(dtrProvince["CapitalName"].ToString(), dtrProvince["CapitalCode"].ToString()));
47        }
48
49        dtrProvince.Close();
50
51        sqlConn.Close();
52
53        return provinceList.ToArray();
54    }
55    [WebMethod]
56    public CascadingDropDownNameValue[] GetCity(string knownCategoryValues, string category)
57    ...{
58        StringDictionary provinceList = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues);
59
60        string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
61
62        SqlConnection sqlConn = new SqlConnection(connectionString);
63
64        sqlConn.Open();
65
66        string strSql = "Select * From City Where DomainID='" + provinceList["Capital"] + "'";
67
68        SqlCommand sqlCmd = new SqlCommand(strSql, sqlConn);
69
70        SqlDataReader dtrCity = sqlCmd.ExecuteReader();
71
72        List<CascadingDropDownNameValue> cityList = new List<CascadingDropDownNameValue>();
73
74        while (dtrCity.Read())
75        ...{
76            cityList.Add(new CascadingDropDownNameValue(dtrCity["CityName"].ToString(), dtrCity["CityCode"].ToString()));
77        }
78
79        dtrCity.Close();
80
81        return cityList.ToArray();
82    }
83}
84
85