Click here to Skip to main content
15,867,686 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
i have a webform with three grid views and the are fetched from three oracle table .i have to enable edit update and delete functions in grid and i have to store the changes to grid in a temporary datatable. once the userclicks submit the changes should be updated in database. please help me how to achieve this with some example please.
Posted

To simply your problem I would suggest you to break down your requirement into various phases.

1. First and the foremost thing look out for CRUD Operations in Gridview
2. thn look for connecting to oracle database tables
3. later upate the fields accordingly


http://www.dotnetfunda.com/articles/show/1619/how-to-perform-edit-update-and-delete-operation-in-gridview[^]

Regards,
Praveen Nelge
 
Share this answer
 
v2
Solution 1 is correct and addition to that,
You really don't have to save the updated data in some datatable, because ASP .NET provides temporary persistence storage until the page is post back. So take a look at that link and given below as well. You surely get the idea how to deal with your problem.
See this[^].

Good Luck. :)

-KR
 
Share this answer
 
Comments
Member 10476713 15-Feb-14 23:32pm    
hi guys, thanks for your reply the solution you have suggested will immediately update the database. My requirement is to update all the grid view changes in one shot. The web form contains details of a single user under more than one grid view so we need to have everything under one submit button.

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900