UPDATE INSERT DELETE data from multiple tables using Datagridview

boomboombugsh

Member
Joined
Dec 30, 2011
Messages
5
Programming Experience
Beginner
Hi :)
I have 2 tables in MySQL database. These table were joined through a query and handled by a dataset. Im displaying these data through setting the dataset as the datasource of my datagridview. But when it comes to Update, Insert and Delete statements, I got an error because the sqlcommandbuilder does not generate statements in multiple tables.
I want is, when I press the update button..all the changes made in the datagridview will be updated in the database. Can i make it without creating a datasource in design mode or through smart tag? If I have to manually create an UpdateCommand for adapters..Can I have a code snippet for that?
Im a student yet and totally new to vb.net
Thanks :)
 
Back
Top