Popup Form Refresh combobox on parent form

Expand Post »

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:

VB.NET Syntax (Toggle Plain Text)
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
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.

VB.NET Syntax (Toggle Plain Text)
        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()
        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

cpopham

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

65 posts
since Mar 2005

Permalink

May 31st, 2008

Re: Popup Form Refresh combobox on parent form

i have used something as easy as in the click event where you add your data on the second form just add

vb.net Syntax (Toggle Plain Text)

frmOther.refresh

ProfessorPC

Reputation Points: 31

Solved Threads: 29

Posting Whiz in Training

Offline

270 posts
since Dec 2007

Permalink

May 31st, 2008

Re: Popup Form Refresh combobox on parent form

I tried that and also on the Public sub that is in the parent form I put it there as well, but it is still not working...

cpopham

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

65 posts
since Mar 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Chart?

Next Thread in VB.NET Forum Timeline: Factorial of N

DaniWeb Message

Cancel Changes

User Name
Password