我用dropdownlist控件做了数据绑定,但却显示不出结果来
我用一个dropdownlist 控件做选择,另一个相应做出显示,但却显示不出效果来。各位高手帮忙找找原因。
public void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
{
string strvalue="";
for (int inti=0; inti< DropDownList1.Items.Count-1;inti++)
{
if(DropDownList1.Items[inti].Selected)
{
strvalue=DropDownList1.Items[inti].Value;}
}
int intvalue=int.Parse(strvalue);
string connectstring= "user id=sa;password=;initial catalog=vinegar;data source=thumb;Connect Timeout=30 ";
SqlConnection sqlConnection1=new SqlConnection(connectstring);
sqlConnection1.Open();
SqlDataAdapter sqlCommand1= new SqlDataAdapter("checkoption",sqlConnection1);
sqlCommand1.SelectCommand.CommandType=CommandType.StoredProcedure;
sqlCommand1.SelectCommand.Parameters.Add("@value", intvalue);
DataSet dataSet1=new DataSet();
sqlCommand1.Fill(dataSet1,"NocheckList");
sqlConnection1.Close();
DropDownList2.DataSource=dataSet1.Tables["NocheckList"].DefaultView ;
DropDownList2.DataBind();
}
附存储过程:
CREATE procedure dbo.checkoption
@value int
AS
if @value=0(
select AccesoryID from NoCheckList )
if @value=1(
select AccesoryName from NoCheckList)
if @value=2(
select Batch from NoCheckList)
if @value=3(
select vendor from NoCheckList)
if @value=4(
select ArrivalDate from NoCheckList)
if @value=5(
select TimeLimits from NoCheckList)
GO