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