how to bind database table columns to the dropdownlist

Question

how to bind database table columns to the dropdown list..??

Venkat Kumar · Answer

protected void Page_Load(object sender EventArgs e) { SqlConnection con = new SqlConnection (); con.connectionString=Your Connection String; con.Open(); SqlCommand com=new SqlCommand (select id name from employeecon); // table name SqlDataAdapter da=new SqlDataAdapter(com); DataSet ds =new DataSet (); da.Fill(ds); DropDownList1.DataTextField = ds.Tables[0].Columns[  name ].ToString(); DropDownList1.DataValueField=ds.Tables[0].Columns[  id ].ToString(); DropDownList1.DataSource=ds.Tables[0]; DropDownList1.DataBind(); }

Nanhe Siddique · Answer

read this link http://www.c-sharpcorner.com/UploadFile/0c1bb2/fill-Asp-Net-dropdown-list-from-database-table-using-Asp-Net/ it may help you