请教DropDownList问题
//将合乎条件的Name和RecID值添加到DropDownList中
SqlConnection conn = new SqlConnection();
conn.ConnectionString = link.ConnectionString;
conn.Open();
string sql="";
sql="SELECT ProductCategories.Name, ProductCategories.RecID ";
sql=sql + "FROM ProductCategories LEFT OUTER JOIN ";
sql=sql + "Products ON ProductCategories.RecID =products.Category ";
sql=sql + "WHERE (Products.Category IS NULL)";
SqlDataAdapter adp = new SqlDataAdapter(sql,conn);
DataSet ds = new DataSet();
adp.Fill(ds);
//add ("none","0") into subcategorydrop
object[] rowVals = new object[2];
rowVals[0] = "None";
rowVals[1] = "0";
ds.Tables[0].Rows.Add (rowVals);
SubcategoryDrop.DataSource = ds;
SubcategoryDrop.DataBind();
SubcategoryDrop.SelectedIndex =SubcategoryDrop.Items.Count-1;
conn.Close() ;
//添加成功
//问题是:
//问题是:
string MyIsChildOF = SubcategoryDrop.SelectedItem.Value;
要取到这个Name对应的RecID值
无论选择哪一个items;
总是取到值为0;
如果将
//SubcategoryDrop.SelectedIndex =SubcategoryDrop.Items.Count-1;
屏蔽掉,
取到的值总是为1;
将
//object[] rowVals = new object[2];
//rowVals[0] = "None";
//rowVals[1] = "0";
//ds.Tables[0].Rows.Add (rowVals);
屏蔽掉也没用。
为何
为何
哎