Solved

VB post update in dataset

Posted on 2012-03-22
4
182 Views
Last Modified: 2012-04-07
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
0
Comment
Question by:rawilken
  • 2
  • 2
4 Comments
 

Author Comment

by:rawilken
ID: 37752757
btw I am using .NET 4
0
 
LVL 8

Accepted Solution

by:
gpizzuto earned 500 total points
ID: 37752810
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
 

Author Comment

by:rawilken
ID: 37752923
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
 
LVL 8

Expert Comment

by:gpizzuto
ID: 37753054
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now