C # how to bind the drop-down box

liutian123

C # how to bind the drop-down box

yoshiki317

dropprovince.DataSource = myajax.Getprovince ();
        dropprovince.DataTextField = "province_name";
        dropprovince.DataValueField = "province_id";
        dropprovince.DataBind ();

堕之旋律

Using the DropDownList control
DropDownList.DataSource = DataSet.Tables ["YourTaleName"];
        DropDownList.DataTextField = "name";
        DropDownList.DataValueField = "id";
        DropDownList.DataBind ();
Same as ls principle

苹果小刀

All said upstairs!

kalian2000

Combobox does not count drop-down box, this is in WinForm ...

for example:

SqlConnection con = new SqlConnection ("server = .; database = student; uid = sa; pwd = 0421");
SqlDataAdapter sda = new SqlDataAdapter ("select * from studentDetails", con);
DataSet ds = new DataSet ();
sda.Fill (ds, "student");
this.ComboBox1.DataSource = ds.Tables ["student"];
this.ComboBox1.DisplayMember = "sname";


// If it is a WebForm, you can use the DropDownList said by some upstairs ..

xiezhe001

Although binding can improve development efficiency, but it is not scalable, it is best to write it yourself, and you don't know what happened inside the binding

57162356

Agree upstairs

与血有关

this.combobox.datasource = dataset1.tables ["tablename"];
this.combobox.displaymember = dataset1.tables ["tablename"]. columns ["name"]. tostring ();
this.combobox.tag = dataset1.tables ["tablename"]. columns ["flag"];
Data binding is similar

660158

Haha

冷雨雪

ComboBox1.DataSource = myDataSet; // Dataset
ComboBox1.DisplayMember = "person.userId"; // Table name plus field name
ComboBox1.ValueMember = "person.username";

this.ComboBox1.DataSource = myDataTable; // Data Table
this.ComboBox1.DisplayMember = "Name"; // Field name
this.ComboBox1.ValueMember = "userId"; // field name