DropDownList的问题

Question

两个DropDownListDataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter("select * from CategoryBigInfo",con);
adapter.Fill(ds,"CategoryBigName");
this.DropDownListf.DataSource = ds.Tables["CategoryBigName"].DefaultView;
this.DropDownListf.DataTextField = "CategoryBigName";
this.DropDownListf.DataValueField = "CategoryBigName";
this.DropDownListf.SelectedIndex = 0;
this.DropDownListf.DataBind();DataSet dsz = new DataSet();
SqlDataAdapter adapterz = new SqlDataAdapter("select * from CategorySmallInfo",con);
adapterz.Fill(dsz,"CategorySmallInfo");
this.DropDownListz.DataSource = dsz.Tables["CategorySmallInfo"].DefaultView;
this.DropDownListz.DataTextField = "CategorySmallInfo";
this.DropDownListz.DataValueField = "CategorySmallInfo";
this.DropDownListz.SelectedIndex = 0;
this.DropDownListz.DataBind();con.Close();这样绑只有第一个绑上了，第二个是空的 怎么回事？

Answer 1

select * from CategorySmallInfo 
上面的语句在sql server 中能查询出数据吗？》