Solved

VB post update in dataset

Posted on 2012-03-22
4
183 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

820 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