我把从数据库里查询出来的数据绑定到dropdownlist。相关代码如下：
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
getall();
DropDownList1.Items.Insert(0, new ListItem("不限", "-1"));
}

private void getall()
{
SqlConnection conn=new SqlConnection("server=localhost; database=WKM001; uid=sa; pwd=");

SqlDataAdapter da=new SqlDataAdapter("select distinct department from company" , conn);
DataSet ds=new DataSet();
da.Fill(ds);
this.DropDownList1.DataSource=ds;
this.DropDownList1.DataBind();
da.Dispose();
虽然dropdownlist绑定了数据但是显示的根本就不是数据库的数据

[此贴子已经被作者于2006-11-9 11:43:27编辑过]

在private void getall()
{
SqlConnection conn=new SqlConnection("server=localhost; database=WKM001; uid=sa; pwd=");

SqlDataAdapter da=new SqlDataAdapter("select distinct department from company" , conn);
DataSet ds=new DataSet();
da.Fill(ds);
this.DropDownList1.DataSource=ds.Table[0];
this.DropDownList1.DataTextFiled = "显示的字段" ;
this.DropDownList1.DataValueFiled = "字段值";
this.DropDownList1.DataBind();
da.Dispose();
}