how to bind data from database using ado.net with dropdownlist using asp.net3.5

Question

Can anyone tell me how to bind data from database using ado.net with dropdownlist using asp.net3.5 and also on selection of an item from that ddl a new dropdownlist will be created .how?

Marimuthu Arigovindasamy · Answer

aspx page: asp : Panel ID ="pnl" runat ="server" Visible ="false"> asp : DropDownList ID ="ddlSecond" runat ="server"> asp : ListItem Text ="AAA" Value ="1"> asp : ListItem > asp : ListItem Text ="BBB" Value ="2"> asp : ListItem > asp : DropDownList > asp : Panel > asp : DropDownList ID ="ddlName" runat ="server" AutoPostBack ="true" OnSelectedIndexChanged ="ddlName_SelectedIndexChanged"> asp : DropDownList > aspx.cs Page_Load event SqlConnection con = new SqlConnection (); con.ConnectionString = ConfigurationManager .ConnectionStrings[0].ConnectionString; SqlCommand cmdallltransactions = new SqlCommand ( "SELECT ID, Name FROM Employee" , con); con.Open(); SqlDataAdapter sqlAdapter = new SqlDataAdapter (cmdallltransactions); DataTable dtRecord = new DataTable (); sqlAdapter.Fill(dtRecord); con.Close(); ddlName.DataSource = dtRecord; ddlName.DataTextField = "Name" ; ddlName.DataValueField = "ID" ; ddlName.DataBind(); protected void ddlName_SelectedIndexChanged( object sender, EventArgs e) { pnl.Visible = true ; }

shweta gupta · Answer

Dear Muthu, Thanks for ur immediate reply. I know this code but if I use asp.net 3.5 ajax with drop down list.Will this code work. Thanks & Regards, Shweta

how to bind data from database using ado.net with dropdownlist using asp.net3.5

Answers (2)