Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
314 Points
73 Posts
Mar 14, 2012 07:58 AM|LINK
SqlConnection sqlcon = new SqlConnection("Data Source=ServerName\\SQLEXPRESS; Initial Catalog=DataBaseName; Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { if(!IsPostback) { BindDropDown1(); BindDropDown2(); } } void BindDropDown1() { sqlcon.Open(); SqlCommand cmd = new SqlCommand("select columnname from tablename"); SqlDataReader dr = cmd.ExecuteReader(); While(dr.read()) { drowdownlist1.datasource=dr; dropdownlist1.dataTextField="columnname"; dropdownlist1.dataValueField="columnnameId"; dropdownlist1.DataBind(); sqlcon.close(); } } void BindDropDown2() { sqlcon.Open(); SqlCommand cmd = new SqlCommand("select columnname from tablename"); SqlDataReader dr = cmd.ExecuteReader(); While(dr.read()) { drowdownlist1.datasource=dr; dropdownlist1.dataTextField="columnname"; dropdownlist1.dataValueField="columnnameId"; dropdownlist1.DataBind(); sqlcon.close(); } }
AsadShahs
Member
314 Points
73 Posts
Re: Help with first time Dropdownlist from database.
Mar 14, 2012 07:58 AM|LINK
SqlConnection sqlcon = new SqlConnection("Data Source=ServerName\\SQLEXPRESS; Initial Catalog=DataBaseName; Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { if(!IsPostback) { BindDropDown1(); BindDropDown2(); } } void BindDropDown1() { sqlcon.Open(); SqlCommand cmd = new SqlCommand("select columnname from tablename"); SqlDataReader dr = cmd.ExecuteReader(); While(dr.read()) { drowdownlist1.datasource=dr; dropdownlist1.dataTextField="columnname"; dropdownlist1.dataValueField="columnnameId"; dropdownlist1.DataBind(); sqlcon.close(); } } void BindDropDown2() { sqlcon.Open(); SqlCommand cmd = new SqlCommand("select columnname from tablename"); SqlDataReader dr = cmd.ExecuteReader(); While(dr.read()) { drowdownlist1.datasource=dr; dropdownlist1.dataTextField="columnname"; dropdownlist1.dataValueField="columnnameId"; dropdownlist1.DataBind(); sqlcon.close(); } }