Updating Microsoft Access Table with DataTable in C#

Question

0.00/5 (No votes)

See more:

I am connecting to a Microsoft Access database and using the OleDbDataAdapter to fill a DataTable with all the rows within the Access Table. I am binding this DataTable to a DataGridView control and allowing the user to update the values within this DataGridView control. When they hit save I want to update the Access Table so that it matches all the values within the DataTable. I can't quite figure out how to do this.

This probably isn't very difficult but I am having such a hard time!

Posted 27-Oct-13 8:59am

MrGlass3

Add a Solution

Comments

ridoy 27-Oct-13 16:18pm

have a look at it:http://stackoverflow.com/questions/7141725/help-with-updating-access-database-using-updatedatatable

MrGlass3 27-Oct-13 16:42pm

I guess my problem is with the SQL query. I want to update the Access Table to have the exact data that is within the the DataTable. All the examples I see use "UPDATE [TableName] SET..." I don't know how to configure the SET since I want everything to update.

Richard.Berry100 27-Oct-13 18:04pm

There is a DataAdapter.Update(DataTable) method. So you would need to supply an 'updated' Datatable as a argument - derived from your datagridview

MrGlass3 27-Oct-13 18:18pm

To use that though I need to supply an UpdateCommand and I don't know what the CommandText should be. UPDATE [TableName] SET _______???

Richard.Berry100 28-Oct-13 0:50am

From what I remember you supply a SELECT command.

see: http://stackoverflow.com/questions/8171647/c-sharp-using-dataadapter-to-update-sql-table-from-a-datatable-sql-table-no

BulletVictim 28-Oct-13 2:02am

Ok in order for you to do the update you will need to leave at least one unique field that can not be updated, Also since you want to update from a dataGridView take a look at something like dataGridView1.SelectedRows[0].Cells[0].Value.Tostring()
Otherwise show some of the code you have done so far.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)