Private Sub mnuSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveChangesToolStripMenuItem.Click

        '---save any changes from the grid editing bit
        Try
            '---you must move to a different record to make the DS accept changes then it updates just fine
            Me.BindingContext(dataSet.Tables("customers")).Position = 0

            Dim cmd As New SqlCommandBuilder(dataAdapter) 'the commandbuilder creates Inert/Update/Delete commands for us!
            dataAdapter.TableMappings.Clear()             'must do this or it tries to add my table twice
            dataAdapter.TableMappings.Add("Table", "customers") 'tell the DA we are adding a Table called customers
            dataAdapter.Update(dataSet, "customers")               'make it so
            dgCustomers.DataSource = dataSet
            dgCustomers.DataMember = "customers"   'DataMember = The Table where the data is

            MsgBox("Your data has been updated.", MsgBoxStyle.Information, MSG_TITLE)
        Catch ex As Exception
            MsgBox("I could not read the database..." & Err.Description, MsgBoxStyle.Critical, MSG_TITLE)

        Finally
            Conn.Close()
        End Try
        GetMyData()


    End Sub