modified datagridview data update to the database

Question

0.00/5 (No votes)

See more:

.NET3.5

, +

hi I am new in .net so please help me i stucked,I have a datagridview and i made some changes to it after that whenever i clicked on the update button the datagridview data should be updated in the database so that next when i want to get the values from the database the modified data will come.

Thanks.

Posted 28-Mar-12 2:40am

Prafulla Sahu

Add a Solution

1 solution

Add a Solution

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)

ProEnggSoft · Answer 1 · 2012-03-28T03:05:00

For this purpose the following procedure can be adopted.
In ADO.NET we can work in disconnected model. i.e. The data from the database is read into the DataSet in the program, required modification are done to the data in the DataSet and then the data is written back to the database.

Create a DataSet. Typed DataSet is easy to create using the AddNewDataSource wizard. A tutorial is given here
http://www.mini.pw.edu.pl/~mossakow/materials/presentations/adonet.3.5/typed_datasets/index.html[^]

Then the data is read to be read into the dataset, using TabeAdapters of the corresponding DataTables.
The DataTable are bound to the DataGridView, to show and modify the data.
Then the modified data is to be saved to the database.

A general purpose class to read and save the data is given in this Code Project article.
General purpose class to fill DataTable(s) from DataBase and to save DataTable(s) to DataBase using reflection[^]]

I think this may be helpful to you.