Only post to database on button click event but still edit data in Grid

Question

0.00/5 (No votes)

See more:

On a form with a DataGrid I want to allow users to edit data but not actually post to the database until they press the save button and if they press the cancel button I want for all changes made in the Grid to the data to be undone. How can I do this?

Donnelly

Posted 16-Sep-10 8:23am

Donnelly James

Add a Solution

2 solutions

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)

#realJSOP · Accepted Answer · 2010-09-16T08:55:00

Solution 1

Easy - don't write the bound dataset back to the database until the user clicks the "Save" button. If the user clicks cancel, either dispose the dataset (or reload it from the database).

Posted 16-Sep-10 8:55am

#realJSOP

Sandeep Mewara · Accepted Answer · 2010-09-16T08:56:00

On a form with a DataGrid I want to allow users to edit data but not actually post to the database until they press the save button
Well, actually you don't need to do anything for this. It's the other way round - you need to write certain code for saving it while filling. If you need a trigger then sit and relax. Let users fill in the data and hit 'save' button.

press the cancel button I want for all changes made in the Grid to the data to be undone
On Cancel press, rebind the grid with the old existing data. That will refresh back to old state.