VB post update in dataset

I have a windows form that has a datagridview on it. I have added a button under the datagridview that when clicked is supposed to post the changes made in the dataset back to the database. The database is an MS Access mdb. The code I have is not working...

Private Sub btnSaveTime_Click(sender As System.Object, e As System.EventArgs) Handles btnSaveTime.Click
        Try
            Me.dgvTime.Update()
            Me.TblTimeBindingSource.EndEdit()
            Me.TableAdapterManager.UpdateAll(Me._Times__DataSet1)
            MessageBox.Show("Data saved!")
        Catch ex As Exception
            MessageBox.Show("Update failed!")
        End Try
    End Sub
rawilkenAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rawilkenAuthor Commented:
btw I am using .NET 4
0
gpizzutoCommented:
First of all, you don't need to call Me.dgvTime.Update() because it does not update data, but REDRAWS the grid.

1) You can't use a query with more than ONE table (or you must call a Stored Procedure).
2) Your datatable MUST have a PRIMARY KEY
3) You cannot update READONLY fields

If you already checked these, please let us know more details about your tables and your query.

Hope this helps
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rawilkenAuthor Commented:
The dataset is comprised of one table, tblTime, that has a primary key. I have one record in the table and that one record is to be updated by the user through the vb Windows form. The record has three fields/columns, ID and TmStart and TmEnd. The primary key is ID and it is AutoNumber.
I have another datagrid view that is similar except the input is a date in the yyy-mm-dd format and the table the dataset uses is tblDates.
I use this input from the user, combining the Start entries into one field and use that to filter data in other datagridviews through queries in the database. So far I have not been able to get the filter to work. It seems that the changes made in the time and dates datagridviews are not being saved properly.
0
gpizzutoCommented:
Have you set up properly the column format of the Date field ?
You need to use MM (month) and not mm (minutes) format: yyyy-MM-dd
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.