I have written a program that binds controls on a form to fields of a table in a Microsoft Access database.One of the controls on the form is a combo box that is binding to table called Type_T which contains one column called Type.
i need to update the combo box whith the new values when i update the table Type_T. the addition of the table going fine and i see the record updated, but the combo box remain without changes.
I have tried this code :
Me.ComboBox2.DataSource = Nothing Me.ComboBox2.DataSource = Me.DataBaseDataSet.Type_T 'Me.ComboBox2.DataSource = Me.TypeTBindingSource Me.ComboBox2.DisplayMember = "Type" Me.ComboBox2.ValueMember = "Type"
but nothing happened.
I have tried this also:
Dim bd As Binding bd = New Binding("Text", ds, "Type_T.Type") Me.ComboBox2.DataBindings.Add(bd)
there were no changes in the combo box.
in addition, this was my last attempt to update it which is to call ReFillCombo()
Private Sub ReFillCombo() Me.ComboBox2.Items.Clear() ' Clear the items of the combobox Dim constr As String = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = C:\Documents and Settings\HST\My Documents\Visual Studio 2005\Projects\Invoice\Invoice\DataBase.mdb" Dim conn As New OleDb.OleDbConnection(constr) Dim da As New OleDb.OleDbDataAdapter("SELECT * FROM Type_T", conn) Dim dt As New DataTable da.Fill(dt) Me.ComboBox1.DataSource = dt Me.ComboBox1.DisplayMember = "Type" Me.ComboBox1.ValueMember = "Type" End Sub
and it gives me this error: Items collection can not be modified when the datasource property is set.
every time i have to close the application and re run it again to see the updat in the combo box.
please help me !!