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 customerid,contactname 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-", ""));