Question

asp.net dropdownlist 问题

前台代码<asp:DropDownList ID="DropDownList1" runat="server" >
<asp:ListItem Selected="True">2008</asp:ListItem><asp:ListItem >2009</asp:ListItem><asp:ListItem>2010</asp:ListItem>

</asp:DropDownList>
后台string mysql = "select * from chuqin where staffid='"+this.txtID.Text + "',year='"+this .DropDownList1.SelectedValue.ToString ()+
"',month='"+this .DropDownList2.SelectedValue.ToString () +"'"; SqlDataAdapter MyAdapter = new SqlDataAdapter(mysql ,cn );
DataSet MySet = new DataSet(); MyAdapter.Fill(MySet, "chuqin");
this.GridView1.DataSource = MySet;
this.GridView1.DataBind();

请问有什么错误

Answer 1

string mysql = "select * from chuqin where staffid='"+this.txtID.Text + "'and year='"+this .DropDownList1.SelectedValue.ToString ()+
"'and month='"+this .DropDownList2.SelectedValue.ToString () +"'";

Answer 2

string s=DropDownList1.SelectedItem.Text;//这是获取选中的文本值
string s=DropDownList1.SelectedValue//获取DropDownList中你设定的Value值

你这里面前台只设置了item的text的值 所以后台应该用DropDownList1.SelectedItem.Text来获取选中的值