?? data.cs
字號(hào):
?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;
/// <summary>
/// Data 的摘要說明
/// </summary>
public class Data
{
public Data()
{
//
// TODO: 在此處添加構(gòu)造函數(shù)邏輯
//
}
public DataTable GetProvince(string ProviceID)
{
string SearchProvince = "select * from povince";
if (!string.IsNullOrEmpty(ProviceID))
{
SearchProvince += "Where '" + ProviceID + "'";
}
return GetData(SearchProvince);
}
public DataTable GetCity(string ProviceID)
{
string SearchCity = "select * from city where father='" + ProviceID + "'";
return GetData(SearchCity);
}
private DataTable GetData(string sql)
{
using (System.Data.SqlClient.SqlConnection conn = DB.GetConn())
{
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sql, conn);
DataTable AimDT = new DataTable();
System.Data.SqlClient.SqlDataAdapter Adapter = new System.Data.SqlClient.SqlDataAdapter();
Adapter.SelectCommand = cmd;
conn.Open();
Adapter.Fill(AimDT);
return AimDT;
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -