how to acess data grid values using cursor and stored procedures

Question

0.00/5 (No votes)

See more:

hi friends please help me.

in my project i created one webpage territory details, i use one data grid and multiple of countries names and codes added to the grid. i have to send total grid values(like a table)to database after that i insert the data in a table,so i don't have any idea please give your valuable suggestions
thanks in advance

Posted 13-Sep-11 2:24am

madhuri from hyd

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)

Rafeeque B Muhammad · Answer 1 · 2011-09-13T03:02:00

if you have done the grid using the DataSet it's an easy task..

Create a typed dataset (you can have all the db interaction using the autogenerated code, or else you have to write your own dynamic sql/stored procedure and attach it.

if suppose you have a Save button in the page in the click event you can iterate through the grid and fill it in the dataset and then update in the db.

//typed dataset
TerritoryDataSet ds = new TerritoryDataSe();

foreach(GridViewRow grdRow in grid.Rows)
{
TerritoryDataSet.TerritoryRow terrRow= ds.Torritory.NewTerritoryRow();
terrRow.Column1 row.Cells[0];
..............
ds.Territory.AddTerritoryRow(terrRow);
}

//
update the dataset.

I think this helps...
or please explain where you are struggling?

Rafeeque B Muhammad · Answer 2 · 2011-09-14T00:11:00

Solution 2

ok you can have the parameter as LOB datatype or varchar (if it has small length) and sent to procedures..

ODP.NET has oracleParamter and type you can do it.

in oracle precedure you have to parse the XML. I would suggest to use strongly typed parser. I will try to post few codes after few hours if required...

Posted 14-Sep-11 0:11am

Rafeeque B Muhammad

Comments

madhuri from hyd 15-Sep-11 9:32am

OK
Please send me examples