Execute SQL stored using ado.net

Question

I am using ado.net to access sql server I have costum Stored Procedure I am executing it using ado.net :

SqlCommand command = new SqlCommand("Custom",con);

and i am sending the parameters like this :

 command.Parameters.Add(new SqlParameter("@Parm1",SqlDbType.Int,0,"Parm1"));

            command.Parameters.Add(new SqlParameter("@Parm2",SqlDbType.Int,0,"Parm2"))

it dose not work and it did not give me an error as well it is the first time to work without DAL generator

Andrey Stukalin · Accepted Answer · 2011-08-07 09:15:37Z

1

Please, use this pattern:

SqlCommand command = new SqlCommand("nameOfMyStoredProcedure", mySqlConnectionObject);  
command.CommandType = CommandType.StoredProcedure;  
command.Parameters.Add("@ID", SqlDbType.Int);  
command.Parameters["@ID"].Value = customerID;

answered Aug 7, 2011 at 9:15

Andrey Stukalin

6,0042 gold badges36 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jesus Ramos Over a year ago

Last 2 lines can be combined to command.Paramters.Add("@ID", SqlDbType.Int).Value = customerID;

Jesus Ramos Over a year ago

Personally I like to create the SqlParameters as separate objects and then add them after the command string (at the top of the method) it becomes much easier to read the code if you see the command string and parameters before you dive into the code that just sets up sql statements

Eslam Soliman · Accepted Answer · 2011-08-10 11:22:06Z

1

to make it work add this line before set the params :

command.CommandType = CommandType.StoredProcedure;

and set the params using :

 command.Parameters[0].Value=4;

 command.Parameters[1].Value=2;

:)

edited Aug 10, 2011 at 11:22

answered Aug 7, 2011 at 9:08

Eslam Soliman

1,2965 gold badges17 silver badges43 bronze badges

2 Comments

Eslam Soliman Over a year ago

My fault :( I have debug the code a lot but i did not search enough I thought that there is something wrong but not something missing :(

Eslam Soliman Over a year ago

@ your service but search enough before asking and it happens with me a lot :)

Collectives™ on Stack Overflow

Execute SQL stored using ado.net

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related