DropDownList绑定数据

   1、循环添加

   protected void Add_State()

    {

        string strSearch = "select * from dealresult";

        SqlConnection sqlConn = new SqlConnection();

        sqlConn.ConnectionString="Server=localhost;user id=sa;password=sa;Database=deal"

        sqlConn.Open();

        SqlCommand sqlCmd = new SqlCommand(strSearch, sqlConn);

        SqlDataReader sqlDr = sqlCmd.ExecuteReader();

        drop_state.Items.Add(new ListItem("请选择", "请选择"));

        while (sqlDr.Read())

        {

            drop_state.Items.Add(new ListItem(sqlDr["result"].ToString(), sqlDr["resultid"].ToString()));

        }

        sqlDr.Close();

        sqlConn.Close();

}

2、直接绑定

protected void Add_State()

    {

        string strSearch = "select * from dealresult";

        SqlConnection sqlConn = new SqlConnection();

        sqlConn.ConnectionString="Server=localhost;user id=sa;password=sa;Database=deal"

        sqlConn.Open();

        SqlCommand sqlCmd = new SqlCommand(strSearch, sqlConn);

        SqlDataAdapter da = new SqlDataAdapter();

        da.SelectCommand = sqlCmd;

        DataSet ds = new DataSet();

        da.Fill(ds);

        drop_state.DataSource = ds;

        drop_state.DataTextField = "result";

        drop_state.DataValueField = "resultid";

        drop_state.DataBind();

}