我写了一下,但是一点小区,小区就没了,保存不了
protected void Page_Load(object sender, EventArgs e)
{
InitEnterpriseList();
}
protected void InitEnterpriseList()
{
#region 添加供热企业
SqlConnection cn = new SqlConnection(DataCenter.DataAccess.DbConstants.ConnectionString);
cn.Open();
SqlCommand cmd = new SqlCommand("select * from Enterprise", cn);
SqlDataReader read = null;
read = cmd.ExecuteReader();
while (read.Read())
{
LE = new LinkButton();
LE.ID = "LE" + read.GetValue(0).ToString();
LE.Text = read.GetValue(2).ToString() + " ";
LE.Click += new EventHandler(LinkDistrict_Click);
this.td1.Controls.Add(LE);
}
cn.Close();
#endregion }
private void LinkDistrict_Click(object sender, EventArgs e)
{
#region 添加小区
InitEnterpriseList();
SqlConnection cn = new SqlConnection(DataCenter.DataAccess.DbConstants.ConnectionString);
cn.Open();
SqlCommand cmd = new SqlCommand("select * from District where EnterpriseId = " + ((LinkButton)sender).ID.Replace("LE", "") + "", cn);
SqlDataReader read = null;
read = cmd.ExecuteReader();
while (read.Read())
{
LD = new LinkButton();
LD.ID = "LD" + read.GetValue(0).ToString();
LD.Text = read.GetValue(3).ToString() + " ";
LD.Click += new EventHandler(LinkBuild_Click);
this.td2.Controls.Add(LD);
}
cn.Close();
#endregion
} private void LinkBuild_Click(object sender, EventArgs e)
{
#region 添加大楼
SqlConnection cn = new SqlConnection(DataCenter.DataAccess.DbConstants.ConnectionString);
cn.Open();
SqlCommand cmd = new SqlCommand("select * from Build where DistrictId = " + ((LinkButton)sender).ID.Replace("LD", "") + "", cn);
SqlDataReader read = null;
read = cmd.ExecuteReader();
while (read.Read())
{
LB = new LinkButton();
LB.ID = "LD" + read.GetValue(0).ToString();
LB.Text = read.GetValue(3).ToString() + " ";
LB.Click += new EventHandler(LinkUnit_Click);
this.td3.Controls.Add(LB);
}
cn.Close();
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
InitEnterpriseList();
}
protected void InitEnterpriseList()
{
#region 添加供热企业
SqlConnection cn = new SqlConnection(DataCenter.DataAccess.DbConstants.ConnectionString);
cn.Open();
SqlCommand cmd = new SqlCommand("select * from Enterprise", cn);
SqlDataReader read = null;
read = cmd.ExecuteReader();
while (read.Read())
{
LE = new LinkButton();
LE.ID = "LE" + read.GetValue(0).ToString();
LE.Text = read.GetValue(2).ToString() + " ";
LE.Click += new EventHandler(LinkDistrict_Click);
this.td1.Controls.Add(LE);
}
cn.Close();
#endregion }
private void LinkDistrict_Click(object sender, EventArgs e)
{
#region 添加小区
InitEnterpriseList();
SqlConnection cn = new SqlConnection(DataCenter.DataAccess.DbConstants.ConnectionString);
cn.Open();
SqlCommand cmd = new SqlCommand("select * from District where EnterpriseId = " + ((LinkButton)sender).ID.Replace("LE", "") + "", cn);
SqlDataReader read = null;
read = cmd.ExecuteReader();
while (read.Read())
{
LD = new LinkButton();
LD.ID = "LD" + read.GetValue(0).ToString();
LD.Text = read.GetValue(3).ToString() + " ";
LD.Click += new EventHandler(LinkBuild_Click);
this.td2.Controls.Add(LD);
}
cn.Close();
#endregion
} private void LinkBuild_Click(object sender, EventArgs e)
{
#region 添加大楼
SqlConnection cn = new SqlConnection(DataCenter.DataAccess.DbConstants.ConnectionString);
cn.Open();
SqlCommand cmd = new SqlCommand("select * from Build where DistrictId = " + ((LinkButton)sender).ID.Replace("LD", "") + "", cn);
SqlDataReader read = null;
read = cmd.ExecuteReader();
while (read.Read())
{
LB = new LinkButton();
LB.ID = "LD" + read.GetValue(0).ToString();
LB.Text = read.GetValue(3).ToString() + " ";
LB.Click += new EventHandler(LinkUnit_Click);
this.td3.Controls.Add(LB);
}
cn.Close();
#endregion
}
解决方案 »
- 如何把xml保存到ie临时文件夹里,下次访问直接调用本地
- 希望在用户输入密码三次失败后一个小时或一天不让登陆,谁有过类似的开发啊?
- override protected void OnInit(EventArgs e)
- ★★求助!!关于FileUpload上传文件并用GridView显示的菜鸟问题!!★★
- gridview换页后,怎么得到行的内容?????立马结贴
- (数据库方面的)大家帮帮忙,急急!!!
- ===========一个不错的网络U盘项目,希望大家可以进来讨论它的技术实现
- 怎么取得动态生成的textbox中的值
- 用Microsoft Visual Studio .NET设计页面远比DW MX差,大家是怎么协调的?
- ASPNET里面内置的上传组件支持直接上传到数据库中吗?
- web.config问题
- from标签的action地址怎么写?
http://blog.csdn.net/qingyun1029/article/details/6666811