Bind data to a combo box from a table in the DB

Question

Dear Friends How do you bind data to a combo box ? I want to load data field like Customer Code in a combo box and when you are running the apllication It should be appeared in a dropped down list. So hw do you do this? Help me......

Manish Dwivedi · Answer

Hi That DataBind() method used in web application. I thought u want to bind the drop down list in the web application. but u want to bind the combo box in the window application. I am sending you the working code for that. private void Form1_Load( object sender EventArgs e) { ListCustomerCode(); } public DataSet ActiveCust() // Create the data set { SqlConnection scon = new SqlConnection ( server=.;database=Northwind;UID=sa;pwd=; ); scon.Open(); DataSet LCust = new DataSet (); string query = SELECT NameCity FROM tblCity ; SqlCommand cmd = new SqlCommand (query scon); SqlDataAdapter adpt = new SqlDataAdapter (cmd); adpt.Fill(LCust LostCustomer ); scon.Close(); return LCust; } private void ListCustomerCode() { DataSet Lcust = new DataSet (); Lcust = ActiveCust(); if (! object .Equals(Lcust null )) { comboBox1.DataSource = Lcust.Tables[0]; comboBox1.DisplayMember = Name ; } } Happy Coding!!

Dinusha Gamage · Answer

Thanks Dear I have applied the coding you sent. Can you plz check this since there are some probs. public LostCustInfo ActiveCust() // Create the data set { SqlConnection scon = new SqlConnection (con.SetConnection()); scon.Open(); LostCustInfo LCust = new LostCustInfo (); string query = SELECT cust_codecust_name FROM CM_LOSTCUST WHERE active = 'Y' ; SqlCommand cmd = new SqlCommand (query scon); SqlDataAdapter adpt = new SqlDataAdapter (cmd); adpt.Fill(LCust LostCustomer ); scon.Close(); return LCust; } private void ListCustomerCode() { LostCustInfo Lcust = new LostCustInfo (); Lcust = Lcust.ActiveCust(); if (! object .Equals(Lcust null )) { cboCustCode.DataSource = Lcust; cboCustCode.DataBindings; // Here there is no method like this ???????? } }

Dinusha Gamage · Answer

Thanks for your help I need more clarification on this I'll put that into forum. Hope you can guide me.

Manish Dwivedi · Answer

Hi For binding the dropdownlist. write the method which returns all the customerid as u want. then provide this datasource to the dropdownlist in the page load or where u want. I am posting you the sample code for this. dataSet = new DataSet (); dataSet = Write the method which returnd the data. if (! object .Equals(dataSet null )) { dropdownSample.DataSource = dataSet; dropdownSample.DataBind(); } Happy Coding!!