写起来烦,不过你可以这样做: 先从DropDownList 取得你的ID值,然后用"Select mk_name From yourTable where ID ='"+ID+"'",这样不就可以了吗? 在这里,关键的是能不能通过DropDownList 取得你的值,你可以这样来取SelectCmd="Select mk_name From yourTable"; OleDbCommand MyCommand = new OleDbCommand(SelectCmd, MyConnection); MyConnection.Open(); OleDbDataReader Dr = MyCommand.ExecuteReader(); while(Dr.Read()) { ListItem DDLmkid =new ListItem(Dr["mk_id"].ToString(),Dr["mk_id"].ToString()); DDLmkid.Items.Add (DDLbigclassnamefirst); } MyConnection.Close() } 取得以后就可以用带条件SQL语句来解决了:如:"Select mk_name From yourTable where ID ='"+DDLmk_id.SelectedValue+"'";
mkid.DataSource=数据源;(DataTabel,ArrayList...)
mkid.DataTextField="mk_id";
mkid.DataValueField="mk_Name";
mkid.AutoPostBack=true;mkid的SelectedIndexChanged事件中
Label1.Text=mkid.SelectedValue;
先从DropDownList 取得你的ID值,然后用"Select mk_name From yourTable where ID ='"+ID+"'",这样不就可以了吗?
在这里,关键的是能不能通过DropDownList 取得你的值,你可以这样来取SelectCmd="Select mk_name From yourTable";
OleDbCommand MyCommand = new OleDbCommand(SelectCmd, MyConnection);
MyConnection.Open();
OleDbDataReader Dr = MyCommand.ExecuteReader();
while(Dr.Read())
{
ListItem DDLmkid =new ListItem(Dr["mk_id"].ToString(),Dr["mk_id"].ToString());
DDLmkid.Items.Add (DDLbigclassnamefirst);
}
MyConnection.Close()
}
取得以后就可以用带条件SQL语句来解决了:如:"Select mk_name From yourTable where ID ='"+DDLmk_id.SelectedValue+"'";