linking dropdownlist with sql server database

Question

Hi Guide me in linking the dropdownlist to the sql server table Thanks Kritika

Sanjeeb Lenka · Answer

hi for asp.net refer to this link http://www.aspdotnet-suresh.com/2012/10/showbind-data-to-aspnet-dropdownlist.html http://www.webcodeexpert.com/2013/02/how-to-fill-dropdownlist-from-sql.html for Windows form refer to this link http://dotnetsridhar.blogspot.in/2012/04/binding-combobox-in-windows.html http://imagirlit.blogspot.in/2013/02/load-data-into-combobox-in-c-from-sql.html

Iftikar Hussain · Answer

Hi Try like this private void Form1_Load(object sender EventArgs e) { SqlConnection conn = new SqlConnection(@Data Source=TOM-PC\sqlexpress;Initial Catalog=Northwind;User ID=sa;Password=xyz) ; conn.Open(); SqlCommand sc = new SqlCommand(select customeridcontactname from customers conn); SqlDataReader reader; reader = sc.ExecuteReader(); DataTable dt = new DataTable(); dt.Columns.Add(customerid typeof(string)); dt.Columns.Add(contactname typeof(string)); dt.Load(reader); comboBox1.ValueMember = customerid; comboBox1.DisplayMember = contactname; comboBox1.DataSource = dt; conn.Close(); } private void comboBox1_SelectedIndexChanged(object sender EventArgs e) { string ID = comboBox1.SelectedValue.ToString(); } Regards Iftikar

Abhineet Srivastava · Answer

Hi Kritika Use Like this- 1-First get Value in Datatable from Database- objsco = new clsSponsoringComp(); objsco.strMa_id = Session[maid].ToString(); DataTable dtsco = objsco.SelectSponsoringcompany(); 2-Bind Dropdown like this- ddlcompany.DataSource = dtsco; ddlcompany.DataTextField = name; ddlcompany.DataValueField = sco_id; ddlcompany.DataBind(); ddlcompany.Items.Insert(0 new ListItem(-Select Company- ));