I have set up an application that is a simple frontend for a local db in the app. The db is called projectdb. I have a form on which there is a DataGridView called DataGridView1. It is linked to "user" table of the db. There is a button, button2, that i have added. I want to save the contents of the DataGridView to the db when the button is pressed. Plz help me.

Hi Doomslagen,

When click save button, you can use dataAdapt to update the database.

The following links are for your reference:

Updating Data Sources with DataAdapters:
http://msdn.microsoft.com/en-us/library/33y2221y(VS.80).aspx

Modifying Data in ADO.NET:
http://msdn.microsoft.com/en-us/library/ms254950(VS.80).aspx

You can use SqlCommandBuilder class to automatically generate single-table commands that are used to reconcile changes made to a DataSet with the associated SQL Server database.

SQLCommandBuilder: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommandbuilder.aspx

How to use Microsoft Visual Basic .NET to connect to a Microsoft Access database and to retrieve data?

If you have further questions, please feel free to tell me.

Best regards,
Ling Wang

---

Please remember to click “Mark as Answer�on the post that helps you, and to click “Unmark as Answer�if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

That is great. But now I have upgraded to visual studio 10, and there is no such thing as a tableadaptor. What do I do?

This feature was not removed, so your project should work fine in VS 2010.

Are you getting some type of error when you try to upgrade your project to VS 2010?

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!