how to fill drop down list in asp.net from database.

Question

Anonymous User · Answer

Use theand DropDownListand control to create a single selection drop-down list control. You can control the appearance of theand DropDownListand control by setting theand BorderColor,and BorderStyle, andand BorderWidthand properties.To specify the items that appear in theand DropDownListand control, place aand ListItemand element for each entry between the opening and closing tags of theand DropDownListand control. It is server side control in asp.net.string constr = ConfigurationManager.ConnectionStrings["forumConnectionString"].ToString(); // connection string            SqlConnection con = new SqlConnection(constr);con.Open();            SqlCommand com = new SqlCommand("select *from Employee", con); // table name             SqlDataAdapter da = new SqlDataAdapter(com);            DataSet ds = new DataSet();            da.Fill(ds);  // fill dataset DropDownList1.DataTextField = ds.Tables[0].Columns["Emp_Name"].ToString(); // text field name of table dispalyed in dropdown            DropDownList1.DataValueField = ds.Tables[0].Columns["Emp_ID"].ToString();             // to retrive specific  textfield name             DropDownList1.DataSource = ds.Tables[0];      //assigning datasource to the dropdownlist            DropDownList1.DataBind();  //binding dropdownlist

forum

how to fill drop down list in asp.net from database.

Anonymous User

Can you answer this question?

1 Answers

Liked By