almost 10 years ago
Hello all,
In asp.net we use DropDownList control which has multiple select items(options) from which we can select one. We can either set the values of DropDownList list items by hard coding it or we can also bind the the select items and select value from the DataBase.
To bind the Value from the DataBase we have the following block of code:
In ASPX we have:
And in C# we have :
- protected void binddept()
- {
- DataTable dataTable = new DataTable();
- dataTable = // Your DataAccess code goes here which will return a DataTable;
- if (dataTable .Rows.Count > 0)
- {
- myDropDownList.DataSource = dataTable ;
- myDropDownList.DataTextField = "countryName"; // This will be the column name present in DataTable and it will set the Text Field of the DropDownList control
- myDropDownList.DataValueField = "countryId"; // This will be the column name present in DataTable and it will set the Value Field of the DropDownList control
- myDropDownList.DataBind();
- myDropDownList.Items.Insert(0, "--Select--");
- }
- }
protected void binddept() { DataTable dataTable = new DataTable(); dataTable = // Your DataAccess code goes here which will return a DataTable; if (dataTable .Rows.Count > 0) { myDropDownList.DataSource = dataTable ; myDropDownList.DataTextField = "countryName"; // This will be the column name present in DataTable and it will set the Text Field of the DropDownList control myDropDownList.DataValueField = "countryId"; // This will be the column name present in DataTable and it will set the Value Field of the DropDownList control myDropDownList.DataBind(); myDropDownList.Items.Insert(0, "--Select--"); } }
0 Comment(s)