How to bind DropDownList with SQL Server database

Question

Hi all, How to bind DropDownList with SQL Server database ?

Satyapriya Nayak · Answer

Hi rohatash , Try this SqlConnection con = new SqlConnection(strConnString); if (!IsPostBack) { con.Open(); str = "select columnname from tablename"; com = new SqlCommand(str, con); SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { DropDownList1.Items.Add(reader["columnname"].ToString()); } reader.Close(); con.Close(); } Thanks If this post helps you mark it as answer

Mayur Dighe · Answer

Hey Rohatash Kumar , You can do it, by simply setting some properties of DropDownList Control. If you going to code it for binding then set put below snippet in your code: DropDownList1. DataSource = //data from DataSet, DataReader etc... DropDownList1. DataTextField = "FieldName" ; DropDownList1. DataValueField = "FieldName "; // this requires to display data properly in web applications DropDownList1. DataBind() ; If you want to go through wizard then just click the triangle symbol pop-up when you select the DropDownList Control. And simply follow the instructions displayed step - by - step.

How to bind DropDownList with SQL Server database

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)