linking dropdownlist with sql server database

kritika Rana

13y1.5kVisual Basic .NET

Hi

Guide me in linking the dropdownlist to the sql server table

Thanks

Kritika

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka13y ago
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 Hussain13y ago
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 Srivastava13y ago
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-", ""));