Gridview Row Editing and Dataset

Question

0.00/5 (No votes)

See more:

Hi...
I am using Gridview1 with fields Code,Name and Amount and checkbox field. I am binding Gridview1 with database...Now i am passing selected checkbox rows of gridview to another Gridview2.This works fine.
But now i want to edit the Amount field in gridview but i don't want to update Database...just waana pass selected rows with edited values to Gridview2, and then save all rows of Gridview 2 to database.
how to edit values in Gridview1 without editing database....and then pass to Gridview2.

Plzz help me...

Posted 26-Jun-10 22:28pm

akkanshagupta

Add a Solution

3 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)

Sandeep Mewara · Answer 1 · 2010-06-26T22:44:00

"how to edit values in Gridview1 without editing database"...
Database update will only happen when you trigger an update. It won't update automatically. Don't put that trigger, simple!

Have two gridviews. Make a change in first one and pass on the changes to second one. Once you are done with second gridview, fire an update statement in database with the values of gridview two as desired.

Adrabi Abderrahim · Answer 2 · 2010-06-27T00:56:00

maybe you can use a local datatable for manipulating locally your data in GridView1 without any change in database :

0) retrieve data from database
1) store datatable locally in memory in Cache or ViewState (I think if you use Session can create problem with large data, also you can forget it)
2) don't bind autocratically your GridView1 to database, use local datatable.
3) make change as you like.
4) pass it to GV2
5) update you DB.

akkanshagupta · Answer 3 · 2010-06-27T03:48:00

Solution 3

Can you please send me the Code.I am kindly new at this. I am not able to change the Gridview cell values on Checkbox selected event.

Posted 27-Jun-10 3:48am

akkanshagupta

Gridview Row Editing and Dataset

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0