Using Data from datagridview control to execute stored procedure

Question

5.00/5 (1 vote)

See more:

In the program i am creating, all the stored procedure's parameters are in a datagridview control (for one specific stored procedure). Columns are: Parameter Name, Parameter Type and Length of Type. There is one more column named "Enter Value". In this column the user enters data appropriate to the parameter and clicks the Run Procedure button. Once the button is clicked the program must use the "Enter Value" column's value to execute the stored procedure.

Using the data entered into the "Enter Value" column, the program executes the stored procedure.

I'm not sure how to retrieve the information from the datagridview control.

please help.

Posted 3-Jun-12 10:09am

D3m0n1CMoNkEy

Add a Solution

Comments

taha bahraminezhad Jooneghani 3-Jun-12 17:20pm

did you use a table with primary key for store procedure?

D3m0n1CMoNkEy 4-Jun-12 9:12am

unknown...When the program starts the database name is unknown, procedures is unknown and parameters is unknown. the user selects the database name in the program, from there the stored procedures for that database will show, and then the parameters for the stored procedure the user has selected

1 solution

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)

John Orendt · Accepted Answer · 2012-06-03T10:49:00

Solution 1

So you know how to fill a

C#

DataGridView mDgv;

// Fill mDgv
.
.

// 
int i=3;
// get a value from mDgv, column "MyFill", row 3
int MyFill=mDgv.Rows[i].Cells["MyFill"].Value;

Of course you can loop to get many rows and you can get whatever columns you have.

Posted 3-Jun-12 10:49am

John Orendt