DropdownList绑定的两种方法

DropdownList绑定的两种方法

1.绑定整个dataTable，然后绑定显示值和数据值。

SqlConnection conn = UtilitySqlClass. Opera teDataBase.ReturnConn();
string strSQL = "select * from CompanyType";
SqlDataAdapter ada = new SqlDataAdapter(strSQL, conn);
DataSet ds = new DataSet();
ada.Fill(ds, "CompanyType");
DropDownList1.DataSource = ds.Tables["CompanyType"].DefaultView;
DropDownList1.DataValueField = ds.Tables["CompanyType"].Columns[1].ColumnName;
DropDownList1.DataTextField = ds.Tables["CompanyType"].Columns[1].ColumnName;
DropDownList1.DataBind();
ds.Dispose();

2.循环datarow，循环绑定。

  con.Open();
        SqlCommand cmd = new SqlCommand(strSql,con);
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {      
            DropDownList1.Items.Add(new ListItem(dr["status"].ToString(), dr["status_Id"].ToString()));
        }