I have made a VB application (Beta 2) and have put in a DataGridView linked to an Access database. The DataGridView displays the database perfectly.
However I would like to add data to the database. I put a button on the form with the following code. Something very simple to start.
In the DataGridView form it updates perfectly however it does not save the data to the actual Access database.
In the old versions of VB I could use the .update command and it would work. Now .update is invalid.
What am I doing wrong
------------------------------------------
Here is my code for the button
Dim drv As Data.DataRowView = Data1.AddNew
drv.BeginEdit()
drv("BusinessType") = "ABCDE"
drv.EndEdit()
EndEdit not working
Hot Topic
- Need help in Deploying the application
- VB.NET: How to make MDI act like SDI
- Picture Box and Track Bar Transparency
- Asset Tracking Database
- how can i change the printer port 's setting?
- Why is FileLogTraceListener under Microsoft.VisualBasic namespace?
- I wan't a sample code
- Issue with output to a file using My.Computer.FileSystem.WriteAllText
- How to get Stings of 8 bit Chars from Comm Port
- Random Numbers
Visual Basic
- How do I solve TargetInvocationException problem with WebClient in Visual Basic 2005?
- Cant' get click event to occur in TabControl TabPage
- Controls created on one thread cannot be parented to a control on a different thread
- VB 2005 Express beta: Replace loop not working
- How to refresh a bindingsource
- Strange Deployment Problem.
- ListView flickering
- Visual Studio 2005 project in 2003
- New to VB6
- Midi Input in VB.NET
EndEdit not working
John Landreth
As you have discovered, EndEdit() does not cause the DataGridView to stop edit mode. Instead, you should call Validate on the container. So if the DataGridView is placed directly on your form then the following code should work:
Dim drv As Data.DataRowView = Data1.AddNew
drv.BeginEdit()
drv("BusinessType") = "ABCDE"
Me.Validate()
drv.EndEdit()
I hope this helps.
Jay Hickerson
Visual Basic Team