c#下拉列表联动
那位大哥能给个c#中下拉列表联动的例子?
------解决方案--------------------联动什么啊?
------解决方案--------------------你可以用AJAX实现。
------解决方案--------------------可以用AJAX实现
------解决方案--------------------从数据库里读出数据放到下拉列表里:
public void drop1()
{
if (!IsPostBack)
{
//连接数据库
//向下拉列表1增添数据
SqlCommand cmd = new SqlCommand("SELECT DISTINCT yqkfdw FROM jcjlb where sp='审批人'", conn);
SqlDataReader mydr = cmd.ExecuteReader();
while (mydr.Read())
{
ListItem lt = new ListItem();
lt.Text = mydr[0].ToString().Trim();
lt.Value = mydr[0].ToString().Trim();
this.DropDownList3.Items.Add(lt);
}
mydr.Close();
string yqkf = DropDownList3.SelectedValue;
conn.Close();
//执行drop2,向下拉列表2中填数据
this.drop2();
}
}
public void drop2()
{
//连接数据库,如果第一个下拉列表的值为“全部”:
if (DropDownList3.Text == "全部")
{
DropDownList4.Items.Clear();
ListItem lt4 = new ListItem();
lt4.Text = "全部";
this.DropDownList4.Items.Add(lt4);
SqlCommand cmd1 = new SqlCommand("SELECT DISTINCT sgdw FROM jcjlb where sp='审批人'", conn1);
SqlDataReader dr1 = cmd1.ExecuteReader();
while (dr1.Read())
{
ListItem lt1 = new ListItem();
lt1.Text = dr1[0].ToString();
lt1.Value = dr1[0].ToString();
this.DropDownList4.Items.Add(lt1);
}
dr1.Close();
conn1.Close();
}
else
{
DropDownList4.Items.Clear();
string sg = DropDownList3.Text.Trim();
SqlCommand cmd2 = new SqlCommand("SELECT DISTINCT sgdw FROM jcjlb where yqkfdw='" + sg + "'and sp='审批人'", conn1);
SqlDataReader dr2 = cmd2.ExecuteReader();
while (dr2.Read())
{
ListItem lt2 = new ListItem();
lt2.Text = dr2[0].ToString().Trim();
lt2.Value = dr2[0].ToString().Trim();
this.DropDownList4.Items.Add(lt2);
}
ListItem lt3 = new ListItem();
lt3.Text = "全部";
this.DropDownList4.Items.Add(lt3);
dr2.Close();
conn1.Close();
}
}
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
{
this.drop2();
}
drop1放到page_load里面,dropdownlist3是第一个下拉菜单。。。这是我从网上搜来自己改了一点无关紧要的东西,用的还可以,要是着急的话可以先这么用着,还有N多无刷新的也可以找找