Filling a combobox

Kira Polyakova

Hello!

I'm just started learning c#, ado.net, and i need your help :)

I want to filter datagridview using combobox, but i don't know how to fill my combobox from database. I know that i must use DataSource, DisplayMember and ValueMember. I know, that i must create DataTable, and i must use DataAdapter.... but i don't know, how to use them.

Help me, please)))

I would be grateful!!

4 Replies

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

Kira Polyakova13y ago
Thank you!!
Kira Polyakova13y ago
Thank you!!
Riyaz Akhtar13y ago
check this link for details

http://www.c-sharpcorner.com/UploadFile/718fc8/databinding-with-combobox-in-ado-net/
Iftikar Hussain13y ago
Hi,
Please try like this

You would put this code in your Form_Load

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();

}

Regards,
Iftikar