该怎么做给点思路

[一起得瑟]

[zhuawang]

这贴太有才了。神仙也不知道怎么回答

[huangwenquan123]

图片先传到csdn空间里，在引用图片的地址。

[一起得瑟]

就是怎么实现那些下拉框的联动搜索

[threenewbee]

在第一个下拉的 changed 事件里面加载第二个

[tomysea]

OMG，图片挂了...

做联动想体验好的话，首先Ajax

[huangwenquan123]

http://zzk.cnblogs.com/so.aspx?w=asp.net+%E8%81%94%E5%8A%A8&t=

[hykhym]

怎么什么也看不到啊

[renyiqiu]

用AJAX比较好

[a281274533]

AJAX，设置@where参数。

[我TM真的是猪]

好像这个问题经常问的，你先在站内搜索一下吧。

[zcxverygood123456]

AJAX,可以防刷新

[子夜__]

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 
{
  protected void Page_Load(object sender, EventArgs e)
  {
  if (!this.IsPostBack)
  {
  //绑定省
  SqlConnection con = new SqlConnection("server=.;database=dropDownTest;integrated security=true;");
  con.Open();
  SqlCommand cmd = new SqlCommand("select * from provience", con);
  SqlDataReader sdr = cmd.ExecuteReader();
  this.ddlprovince.DataSource = sdr;
  this.ddlprovince.DataTextField = "proName";
  this.ddlprovince.DataValueField = "proID";
  this.ddlprovince.DataBind();
  sdr.Close();
  //绑定市
  SqlCommand cmdcity = new SqlCommand("select * from city where proID=" + this.ddlprovince.SelectedValue, con);
  SqlDataReader sdr1 = cmdcity.ExecuteReader();
  this.ddlcity.DataSource = sdr1;
  this.ddlcity.DataTextField = "cityName";
  this.ddlcity.DataValueField = "cityID";
  this.ddlcity.DataBind();
  sdr1.Close();
  con.Close();
  }


   

  }
  protected void ddlprovince_SelectedIndexChanged(object sender, EventArgs e)
  {
  string proID = this.ddlprovince.SelectedValue;
  SqlConnection con = new SqlConnection("server=.;database=dropDownTest;integrated security=true;");
  con.Open();
  SqlCommand cmd = new SqlCommand("select*from city where proID=" + proID, con);
  SqlDataReader sdr= cmd.ExecuteReader();
  this.ddlcity.DataSource = sdr;
  this.ddlcity.DataTextField = "cityName";
  this.ddlcity.DataValueField = "cityID";
  this.ddlcity.DataBind();
  sdr.Close();
  con.Close();

  }
}

ddlprovince 为省 dropdownlist ID

ddlcity 为市 dropdownlist ID

proName proID为表provience中的字段 也就是省的

cityName cityID为市city表中的字段 是市的


ddlprovince_SelectedIndexChanged为省的dropdownlist 选中事件 触发绑定

数据库 Demo 完整

[phoebuswei]

http://www.cnblogs.com/music000/archive/2006/11/16/562948.html

[happytonice]

1.通过changed事件实现
2.通过ajax实现

[senyi168]