?? default.aspx.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;
public partial class _Default : System.Web.UI.Page
{
DataSet ds = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
//1
string SqlConnectionString =System.Configuration.ConfigurationManager.AppSettings["SQLCONNECTIONSTRING"].ToString();
SqlConnection con = new SqlConnection(SqlConnectionString);
SqlDataAdapter sda = new SqlDataAdapter("select * from Area ,Managers WHERE Managers.Area='東北大區'", con);
sda.Fill(ds);
this.DataGrid1.DataSource = ds;
this.DataGrid1.DataBind();
}
protected void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
//根據大區名字得到大區經理
DataSet ds2 = new DataSet();
string SqlConnectionString2 = System.Configuration.ConfigurationManager.AppSettings["SQLCONNECTIONSTRING"].ToString();
SqlConnection con2 = new SqlConnection(SqlConnectionString2);
SqlDataAdapter sda2 = new SqlDataAdapter("select * from Managers WHERE Area='東北大區'", con2);
sda2.Fill(ds2);
((Repeater)e.Item.FindControl("Repeater1")).DataSource = ds2;
((Repeater)e.Item.FindControl("Repeater1")).DataBind();
//綁定省
DataSet ds3 = new DataSet();
string SqlConnectionString3 = System.Configuration.ConfigurationManager.AppSettings["SQLCONNECTIONSTRING"].ToString();
SqlConnection con3 = new SqlConnection(SqlConnectionString3);
SqlDataAdapter sda3 = new SqlDataAdapter("select * from Province WHERE AreaID='C51FBB80-0152-4643-8A80-907745FAF597'", con3);
sda3.Fill(ds3);
((DataGrid)e.Item.FindControl("DataGrid2")).DataSource = ds3;
((DataGrid)e.Item.FindControl("DataGrid2")).DataBind();
}
}
protected void DataGrid2_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
//綁定省級客戶經理
DataSet ds4 = new DataSet();
string SqlConnectionString4 = System.Configuration.ConfigurationManager.AppSettings["SQLCONNECTIONSTRING"].ToString();
SqlConnection con4 = new SqlConnection(SqlConnectionString4);
SqlDataAdapter sda4 = new SqlDataAdapter("select * from Managers WHERE Area='東北大區'", con4);
sda4.Fill(ds4);
((Repeater)e.Item.FindControl("Repeater2")).DataSource = ds4;
((Repeater)e.Item.FindControl("Repeater2")).DataBind();
//綁定城市
DataSet ds5 = new DataSet();
string SqlConnectionString5 = System.Configuration.ConfigurationManager.AppSettings["SQLCONNECTIONSTRING"].ToString();
SqlConnection con5 = new SqlConnection(SqlConnectionString5);
SqlDataAdapter sda5 = new SqlDataAdapter("select * from City WHERE ProvinceID='C41DFF0A-BE9E-4EF9-ADB4-5D028529B733'", con5);
sda5.Fill(ds5);
((DataGrid)e.Item.FindControl("DataGrid3")).DataSource = ds;
((DataGrid)e.Item.FindControl("DataGrid3")).DataBind();
}
}
protected void DataGrid3_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
}
}
protected void DataGrid4_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -