Windows Form Combobox Bind Problem with valuemember

[KalariaNitya]

Hello all,

i m stuck in how to bind combobox with valuemember

i have four fields in database like..in table agent_master
id =a00001
firstname = nitya
middlename = v
lastname = kalaria

now i want all record from agent_master

in combobox want to bind record like i.e. nitya v kalaria and it's valummber is it's id a00001

can anybody help me how to do that?

thanking u in advanced...

Cheers..

[shweta123]

Hi,

Please refer this Article

[KalariaNitya]

Hey Shweta,

thanks for ur kind help..

i solved my problem.. below is the partial pasted code

For i = 0 To arrfullname.Count - 1
cmbPolicyHolderName.Items.Add(i)
Next


once again thanks..

[sharifee]

Do it Like this.

DataAccess da = new DataAccess();
DataTable dt = da.SelectRecord("SELECT Day.* FROM [Day];");
comboBox1.DataSource = dt;
comboBox1.DisplayMember = "Day_ID";
comboBox1.ValueMember = "Day_Name";