how to update multiple oracle database tables from a webform using grid view

Question

4.00/5 (1 vote)

See more:

, +

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 15-Feb-14 3:41am

Member 10476713

Add a Solution

2 solutions

Add a Solution

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

praveen_07 · Answer 1 · 2014-02-15T04:01:00

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

Krunal Rohit · Answer 2 · 2014-02-15T04:49:00

Solution 2

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

Posted 15-Feb-14 4:49am

Krunal Rohit

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.

how to update multiple oracle database tables from a webform using grid view

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to update multiple oracle database tables from a webform using grid view

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us