getname.cs

这一个能预报天气的软件

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
//该源码下载自www.51aspx.com(５１ａsｐｘ．ｃｏｍ)

/// <summary>
/// GetName 的摘要说明
/// </summary>
public class GetName
{
    static String Names;

    static String Names1;

    SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]);

    public GetName()
    {
        //
        // TODO: 在此处添加构造函数逻辑
        //
    }
    //得到城市的名字
    public String Name(String code)
    {
        String sql = "select * from City where CityCode='" + code + "'";

        SqlCommand cmd = new SqlCommand(sql, con);

        try
        {
            con.Open();

            SqlDataReader MyReader = cmd.ExecuteReader();

            if (MyReader.Read())
            {
                Names = MyReader.GetString(1).ToString();
            }
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            con.Close();
        }
        return Names;
    }
    //得到省会的名字
    public String Name1(String code)
    {
        String sql = "select * from Capital where CapitalCode='" + code + "'";

        SqlCommand cmd = new SqlCommand(sql, con);

        try
        {
            con.Open();

            SqlDataReader MyReader = cmd.ExecuteReader();

            if (MyReader.Read())
            {
                Names1 = MyReader.GetString(1).ToString();
            }
        }
        catch (Exception ex)
        {
            throw (ex);
        }
        finally
        {
            con.Close();
        }
        return Names1;
    }
}