Avatar of cporch
cporch

asked on 

Updating Datatable from DataGridView in Windows

I'm using a TableAdapter as a source for a DataGridView in a windows form.
I've let the TableAdapter generate standard update, delete, and insert commands.
I've been able to properly use the TableAdapter's delete and insert commands by passing current row information to the method, but have trouble when it comes to updating.
I don't understand how to update the datatable used as the source for the GridView with changes that I've made in the Gridview.  Any help would be appreciated.
Windows NetworkingVisual Basic.NET

Avatar of undefined
Last Comment
cporch
Avatar of Jorge Paulino
Jorge Paulino
Flag of Portugal image

Have you tried to update using something like:

Dim cb As New SqlCommandBuilder(da)
da.Update(ds, "myTable")

' where da = Dataset and ds = Datasource

Can you show us your code ?

ASKER CERTIFIED SOLUTION
Avatar of cporch
cporch

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Visual Basic.NET
Visual Basic.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to Visual Basic pre-2002, it is not the same technology,

96K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo