90分求dropdownlist的选择值的问题~~~~~~~~~~
private void Page_Load(object sender, System.EventArgs e)
{
con.open();
sql="select shoot,shootid from [shoot] order by ID desc";
cmd=new SqlCommand(sql,con.link);
read=cmd.ExecuteReader();
if(read.HasRows)
{
//shootselect.Items.Clear();
while(read.Read())
{
ListItem item = new ListItem(read.GetValue(0).ToString(),read.GetValue(1).ToString());
shootselect.Items.Add(item);
}
}
else
{
Response.Write("<div align=center><font color=green>■您还未增加摄影器材,请先增加!</font></div><br>");
ListItem item = new ListItem("警告:请先增加摄影器材!","0");
shootselect.Items.Add(item);
}
read.Close();
con.link.Close();
}
private void addmodel_Click(object sender, System.EventArgs e)
{
//增加型号
if(model.Text!=null&&model.Text!="")
{
//先找有没有重复的ID,再进行数据添加!!!
con.open2();
sql="select modelid from [model] where shootid="+shootselect.SelectedItem.Value+" AND modelid="+modelid.SelectedItem.Value;
cmd2=new SqlCommand(sql,con.link2);
read2=cmd2.ExecuteReader();
if(!read2.Read())
{
con.open();
sql="insert into [model](shootid,model,modelid) values("+con.rep(shootselect.SelectedItem.Value)+","+con.rep(model.Text)+","+con.rep(modelid.SelectedItem.Value)+")";
cmd=new SqlCommand(sql,con.link);
cmd.ExecuteNonQuery();
con.link.Close();
newsmsg="■已成功增加<font color=blue>["+shootselect.SelectedItem.ToString()+"]</font>的型号["+model.Text+"]!</font>请返回查看!</font><br>";
Session["newmsg"]=newsmsg;
Session["url"]=url;
Response.Redirect("added.aspx");
}
else
{
Page.RegisterStartupScript("","<script>alert('"+"注意:ID重复!请勿重复,重新选其它ID,谢谢合作!"+"');</script>");
}
read2.Close();
con.link2.Close();
}
}
请问一下,无论我选择哪一个选项,按按钮触发addmodel_Click事件后,怎么它都取最前一个选项的值呀???
这个问题已经捆饶了我5个小时了,请大侠救命,好头痛呀