Update database via Tableadapter

[VB4Life]

Hi all I am new to DataGridViews, wanting to update the database after a cell is edited in the DGV, how is this accomplished? I am using a tableAdapter and a strong typed dataset? VB.Net2008 Express/SqlServerExpress2008.

 

[RiverGuy]

I'm not sure exactly. There are probably tutorials on MSDN.Microsoft.com. TableAdapters are wizard-created objects in VB.Net to help you with your database access. I've never used them other than in testing. I prefer to use DataSets, Commands and DataAdapters. If you want to write your own code instead of using the wizard, your DataAdapter will need an .InsertCommand, .UpdateCommand and .DeleteCommand.

Here's an article which explains it in greater detail.

http://msdn.microsoft.com/en-us/library/ms971491.aspx

 

[VB4Life]

That is probably the way to go, that I can do, thanks!

 

[VB4Life]

Actually if you call the TableAdapter.Update in the dvg_CellEndEdit Event it will update the row info to the database. I had some editing to do in the Update statement it is working now. I just wanted it to do this automatically instead of having a button, you just in case they forget and they will. LOL