我现在要用两个dropdownlist来做,怎么实现联动呢?

绑定到一起:
string sqlstr = "select typename as 'aaa' from type union select productname as 'aaa' from list";
SqlConnection myconn = new ...........
SqlDataAdapter da = new SqlDataAdapter(sqlstr,myconn);
DataSet ds = new DataSet();
da.Fill(ds);

this.DropDownList1.DataSource = ds;
this.DropDownList1.DataTextField = "aaa";
this.DropDownList1.DataValueField = "aaa";
this.DropDownList1.DataBind();

分开做.你就在第一个的DropDownList的SelectedIndexChanged 事件里面写上相应的代码就行了.

这个功能实现了,能实现联动了,但我的product表中还有一个pro_id呢,

当我插入数据的时候pro_id为空值,

怎么使它也能动态的插入到product表中呢?

this.DropDownList1.DataTextField = "typename ";
this.DropDownList1.DataValueField = "pro_id";

这样绑定,如果你要 pro_id 就取DropDownList1的SelectItem.Value

非常感谢版主,一切OK了~~~

太羡慕你的水平了~~~

以后会多多请教的~~~

结贴