这是两个下拉框的前后代码,麻烦稍微详细说下怎么改 限制模式:
<asp:DropDownList ID="ddlConMode" runat="server" AutoPostBack="True" Height="24px" OnSelectedIndexChanged="ddlConMode_SelectedIndexChanged" Width="85px">
<asp:ListItem Value="1">运营商</asp:ListItem>
<asp:ListItem Value="2">区域</asp:ListItem>
<asp:ListItem Value="3">线路</asp:ListItem>
<asp:ListItem Value="4">点位</asp:ListItem>
</asp:DropDownList>
限制范围:
<asp:DropDownList ID="ddlConArea" runat="server" AutoPostBack="True" Height="24px" Width="85px" OnSelectedIndexChanged="ddlConArea_SelectedIndexChanged">
</asp:DropDownList> protected void Page_Load(object sender, EventArgs e)
{
lblUserName.Text = Session["CarrierOperator"] as string;
SqlConnection conn = new SqlConnection(sqlConn);
conn.Open();
ddlConArea.SelectedIndexChanged += new System.EventHandler(ddlConArea_SelectedIndexChanged);
if (!this.IsPostBack)
{
string ConMode = ddlConMode.SelectedValue;
string sqlConMode = "";
string CarrCode = Session["CarrierCode"].ToString();
sqlConMode = "select 运营商名称,1 from 运营商 where 运营商代码 =" + CarrCode + "";
SqlDataAdapter sdaConMode = new SqlDataAdapter(sqlConMode, conn);
DataSet dsConMode = new DataSet();
sdaConMode.Fill(dsConMode);
ddlConArea.Items.Clear();
for (int i = 0; i < dsConMode.Tables[0].Rows.Count; i++)
{
ddlConArea.Items.Add(new ListItem(dsConMode.Tables[0].Rows[i][0].ToString(), dsConMode.Tables[0].Rows[i][1].ToString()));
}
string sqlAreaBelong = "select 区域名称,区域代码 from 区域 where 运营商代码 ='" + CarrCode + "'";
SqlDataAdapter sdaAreaBelong = new SqlDataAdapter(sqlAreaBelong, conn);
DataSet dsAreaBelong = new DataSet();
sdaAreaBelong.Fill(dsAreaBelong);
for (int i = 0; i < dsAreaBelong.Tables[0].Rows.Count; i++)
{
ddlAreaBelong.Items.Add(new ListItem(dsAreaBelong.Tables[0].Rows[i][0].ToString(), dsAreaBelong.Tables[0].Rows[i][1].ToString()));
}
}
}
protected void ddlConMode_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(sqlConn);
conn.Open();
string ConMode = ddlConMode.SelectedValue;
string sqlConMode = "";
string CarrCode = Session["CarrierCode"].ToString();
if (ConMode == "1")
{
sqlConMode = "select 运营商名称,1 from 运营商 where 运营商代码 =" + CarrCode + "";
}
if (ConMode == "2")
{
sqlConMode = "select 区域名称,2 from 区域 where 运营商代码 =" + CarrCode + "";
}
if (ConMode == "3")
{
sqlConMode = "select 线路名称,3 from 线路 join 区域 on 区域.区域代码 = 线路.区域代码 where 区域.运营商代码 =" + CarrCode + "";
}
if (ConMode == "4")
{
sqlConMode = "select 点位名称,4 from 机器配置 where 运营商代码 =" + CarrCode + "";
}
SqlDataAdapter sdaConMode = new SqlDataAdapter(sqlConMode, conn);
DataSet dsConMode = new DataSet();
sdaConMode.Fill(dsConMode);
ddlConArea.Items.Clear();
for (int i = 0; i < dsConMode.Tables[0].Rows.Count; i++)
{
ddlConArea.Items.Add(new ListItem(dsConMode.Tables[0].Rows[i][0].ToString(), dsConMode.Tables[0].Rows[i][1].ToString()));
}
conn.Close();
}
<asp:DropDownList ID="ddlConMode" runat="server" AutoPostBack="True" Height="24px" OnSelectedIndexChanged="ddlConMode_SelectedIndexChanged" Width="85px">
<asp:ListItem Value="1">运营商</asp:ListItem>
<asp:ListItem Value="2">区域</asp:ListItem>
<asp:ListItem Value="3">线路</asp:ListItem>
<asp:ListItem Value="4">点位</asp:ListItem>
</asp:DropDownList>
限制范围:
<asp:DropDownList ID="ddlConArea" runat="server" AutoPostBack="True" Height="24px" Width="85px" OnSelectedIndexChanged="ddlConArea_SelectedIndexChanged">
</asp:DropDownList> protected void Page_Load(object sender, EventArgs e)
{
lblUserName.Text = Session["CarrierOperator"] as string;
SqlConnection conn = new SqlConnection(sqlConn);
conn.Open();
ddlConArea.SelectedIndexChanged += new System.EventHandler(ddlConArea_SelectedIndexChanged);
if (!this.IsPostBack)
{
string ConMode = ddlConMode.SelectedValue;
string sqlConMode = "";
string CarrCode = Session["CarrierCode"].ToString();
sqlConMode = "select 运营商名称,1 from 运营商 where 运营商代码 =" + CarrCode + "";
SqlDataAdapter sdaConMode = new SqlDataAdapter(sqlConMode, conn);
DataSet dsConMode = new DataSet();
sdaConMode.Fill(dsConMode);
ddlConArea.Items.Clear();
for (int i = 0; i < dsConMode.Tables[0].Rows.Count; i++)
{
ddlConArea.Items.Add(new ListItem(dsConMode.Tables[0].Rows[i][0].ToString(), dsConMode.Tables[0].Rows[i][1].ToString()));
}
string sqlAreaBelong = "select 区域名称,区域代码 from 区域 where 运营商代码 ='" + CarrCode + "'";
SqlDataAdapter sdaAreaBelong = new SqlDataAdapter(sqlAreaBelong, conn);
DataSet dsAreaBelong = new DataSet();
sdaAreaBelong.Fill(dsAreaBelong);
for (int i = 0; i < dsAreaBelong.Tables[0].Rows.Count; i++)
{
ddlAreaBelong.Items.Add(new ListItem(dsAreaBelong.Tables[0].Rows[i][0].ToString(), dsAreaBelong.Tables[0].Rows[i][1].ToString()));
}
}
}
protected void ddlConMode_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(sqlConn);
conn.Open();
string ConMode = ddlConMode.SelectedValue;
string sqlConMode = "";
string CarrCode = Session["CarrierCode"].ToString();
if (ConMode == "1")
{
sqlConMode = "select 运营商名称,1 from 运营商 where 运营商代码 =" + CarrCode + "";
}
if (ConMode == "2")
{
sqlConMode = "select 区域名称,2 from 区域 where 运营商代码 =" + CarrCode + "";
}
if (ConMode == "3")
{
sqlConMode = "select 线路名称,3 from 线路 join 区域 on 区域.区域代码 = 线路.区域代码 where 区域.运营商代码 =" + CarrCode + "";
}
if (ConMode == "4")
{
sqlConMode = "select 点位名称,4 from 机器配置 where 运营商代码 =" + CarrCode + "";
}
SqlDataAdapter sdaConMode = new SqlDataAdapter(sqlConMode, conn);
DataSet dsConMode = new DataSet();
sdaConMode.Fill(dsConMode);
ddlConArea.Items.Clear();
for (int i = 0; i < dsConMode.Tables[0].Rows.Count; i++)
{
ddlConArea.Items.Add(new ListItem(dsConMode.Tables[0].Rows[i][0].ToString(), dsConMode.Tables[0].Rows[i][1].ToString()));
}
conn.Close();
}
解决方案 »
- 关于页面跳转返回的问题
- 不显示删除回复显示所有回复显示星级回复显示得分回复 vs2010配置管理器新建了一个配置却只能用在一个工程
- GridView.SortExpression获取不到值??
- 怎么样用C#或者是asp.net读取PDF文件到lable控件上
- 看看程序错在哪里
- 最后10分问一个弱问题:如何使用DREAMWEAR对ASP.NET项目中的.ASPX页面与.axcx用户控件进行美化?
- 各位高手请教一个问题.实在解决不了!
- ★ (有偿请教)十万火急,最后一个实现环节,请高中的高手相助!!!
- 发布好的网站可以改变连接数据库吗
- 请教有关VS Griview控件有关问题
- 我的vs2010中没有web窗体怎么办
- 求助,jquery mobile内嵌iframe中apsx网页验证失效
1. 抛开控件,只关心具体的数值,用数值是否一致来说话,不要谈控件。
2. 用 vs 进行断点调试会不会呢?如果会就在提问时先贴出你的具体代码和变量的调试来说明。