How to set the Data in combo box when Already Saved Data

Question

how to bind the data in combobox when Already contained data in database

Amit Gupta · Answer

Hey If I understood your question are you asking to rebind the data after being saved? You can use two way binding or if you are using SqlDataAdapter to fill the combobox then just you need to fill the dataTable again to reflect changes.

Murli Jadhav · Answer

Plz Share Your Code With Us we will check and then give you a proper answer

Amit Gupta · Answer

Can you share your code with expected output so that I can understand what you required.

suresh kumar · Answer

Sir I am Already Save the Data in Combo box After that how to show the Already Saved Data in Combo box .

Murli Jadhav · Answer

public DataTable GetTable(String sql) { DataTable dt = new DataTable(); try { SqlDataAdapter da = new SqlDataAdapter(sql con); da.Fill(dt); return dt; } catch { return dt; } } //For Fill Combobox With Database Values public void FillCombo(ComboBox cb string sql string DisplayField string ValueField) { DataTable dt = new DataTable(); dt = GetDataTable(sql); cb.DisplayMember = DisplayField; cb.ValueMember = ValueField; cb.DataSource = dt; } Use: fillcombo(Combobox2select * from empNameName);