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

		            
 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//该源码下载自www.51aspx.com(５１ａsｐｘ．ｃｏｍ)
12
13/**//// <summary>
14/// GetName 的摘要说明
15/// </summary>
16public class GetName
17...{
18    static String Names;
19
20    static String Names1;
21
22    SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]);
23
24    public GetName()
25    ...{
26        //
27        // TODO: 在此处添加构造函数逻辑
28        //
29    }
30    //得到城市的名字
31    public String Name(String code)
32    ...{
33        String sql = "select * from City where CityCode='" + code + "'";
34
35        SqlCommand cmd = new SqlCommand(sql, con);
36
37        try
38        ...{
39            con.Open();
40
41            SqlDataReader MyReader = cmd.ExecuteReader();
42
43            if (MyReader.Read())
44            ...{
45                Names = MyReader.GetString(1).ToString();
46            }
47        }
48        catch (Exception ex)
49        ...{
50            throw (ex);
51        }
52        finally
53        ...{
54            con.Close();
55        }
56        return Names;
57    }
58    //得到省会的名字
59    public String Name1(String code)
60    ...{
61        String sql = "select * from Capital where CapitalCode='" + code + "'";
62
63        SqlCommand cmd = new SqlCommand(sql, con);
64
65        try
66        ...{
67            con.Open();
68
69            SqlDataReader MyReader = cmd.ExecuteReader();
70
71            if (MyReader.Read())
72            ...{
73                Names1 = MyReader.GetString(1).ToString();
74            }
75        }
76        catch (Exception ex)
77        ...{
78            throw (ex);
79        }
80        finally
81        ...{
82            con.Close();
83        }
84        return Names1;
85    }
86}
87