I have a parent form that has a combobox. Whn the form loads I get the data from the db and bind to the combobox. that works fine and here is the code I use in form load to cause this to happen:
conn.Open()
cmd.Connection = conn
da = New SqlCeDataAdapter(cmd1, conn)
cmd.CommandText = "SELECT * FROM AccountType ORDER BY AcctType"
da2 = New SqlCeDataAdapter(cmd)
da2.Fill(dtAcctType)
cmd.CommandText = chkSQL
daCk = New SqlCeDataAdapter(chkSQL, conn)
daCk.Fill(dtChk)
cboType.DataSource = dtAcctType
cboType.DisplayMember = "AcctType"
cboType.ValueMember = "AcctTypeID"
cboType.SelectedIndex = 0
Now if there is not an Account Type, I have a button that will pull up a small form to allow the addition of an account type. The popup form adds the data back to the database just fine, but I am now trying to get the combobox to refresh its data. So I call a public Sub that is located in the parent form to from the popup form to accomplish this task and I have walked the code and the sub is called and appears to work correctly, but the new data never appears in the combobox. Here is my public sub that i call to try and refresh the combobox on the parent form.
Dim dtType As New DataTable
Dim daType As SqlCeDataAdapter
Try
conn = New SqlCeConnection("Data Source=C:\Program Files\HomeComplete\Data\HomeComplete.sdf")
Catch
End Try
Dim cmd As New SqlServerCe.SqlCeCommand
cmd.Connection = conn
cmd.CommandText = "SELECT * FROM AccountType ORDER BY AcctType"
daType = New SqlCeDataAdapter(cmd)
daType.Fill(dtType)
cboType.Items.Clear()
cboType.DataSource = dtType
cboType.DisplayMember = "AcctType"
cboType.ValueMember = "AcctTypeID"
cboType.SelectedIndex = 0
cboType.Refresh()
conn.Close()
But when I go back to the parent form, the combobox is not updated with the new account. How can i get the combobox to refresh from the database with the new data?
Thank You, Chester