How can I create a global function that will run my store procedure

Question

1.00/5 (2 votes)

See more:

Hi Everyone...
I am going to create a global function in c# that will execute my Stored Procedure. When ever i will call to this function it will execute my procedure.

Bellow i have created a function it will give me correct results but this function will show me only that procedure result which parameters will match to it. i want this function to be global.

What I have tried:

My Function is bellow

C#

public static void exec_proc(string proc,string param)
   {
       SqlCommand cmd = new SqlCommand(proc,DBConnection());
       cmd.CommandType = CommandType.StoredProcedure;
       cmd.Parameters.Add("@DESCRIPTION", SqlDbType.VarChar,30).Value = param;
       cmd.ExecuteNonQuery();
   }

i have call this function in my asp.net page as follows it works for me
db.exec_proc("dbo.CREATE_CATAGORY", txt_Cat_Name.Text);

Posted 19-Dec-16 22:19pm

Muhammd Aamir

Updated 26-Dec-16 0:42am

Add a Solution

Comments

F-ES Sitecore 20-Dec-16 4:25am

Your question doesn't make much sense. If you want to call a different procedure that doesn't need parameters then simply update your code to do that? It's unclear exactly what it is you are asking.

Muhammd Aamir 20-Dec-16 4:34am

Ok Thankx F-ES just like above the function will accept 2 param let suppose i have to call this function where i have 3 params what i will have to do ???

F-ES Sitecore 20-Dec-16 4:44am

public static void exec_proc(string proc,string param, string param2)
{
SqlCommand cmd = new SqlCommand(proc,DBConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@DESCRIPTION", SqlDbType.VarChar,30).Value = param;
cmd.Parameters.Add("@MyOtherParam", SqlDbType.VarChar,30).Value = param2;
cmd.ExecuteNonQuery();
}

Muhammd Aamir 20-Dec-16 4:57am

F-ES Sitecore Thankx For sharing your knowledge with me but the problem still same... Kindly show me a function that will do the same without creating new function

F-ES Sitecore 20-Dec-16 5:00am

public static void exec_proc(string proc,string param, string param2 = null)
{
if (string.IsNullOrWhiteSpace(param2))
{
// param2 was not supplied
}
else
{
// param2 was supplied
}
}

Muhammd Aamir 20-Dec-16 4:45am

How can i update the code you mean i need a separate function that will execute the procedure with no paramerter

F-ES Sitecore 20-Dec-16 4:55am

You can either have a separate function or use the same function and decide what to do inside that function based on the arguments you pass in.

Muhammd Aamir 20-Dec-16 5:09am

Ok Thankx I will try

ZurdoDev 20-Dec-16 6:56am

One way would be to pass in a list of CommandParameters. I recommend against this. Just write a function for each sp.

Muhammd Aamir 20-Dec-16 23:58pm

RyanDev absolutely right... i have done it with array list and it works very in a very efficient way

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)

Anamul Hoque · Answer 1 · 2016-12-26T00:42:00

if number of parameter is fixed then you can use following way for dynamically call

public static void exec_proc(string proc,string param,string parametetName, DbType parameterType,int pamaterSize)
{
SqlCommand cmd = new SqlCommand(proc,DBConnection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(parametetName, parameterType,pamaterSize).Value = param;
cmd.ExecuteNonQuery();
}