Best way to call a stored procedure

[mike]

H

There are two ways to execute a stored procedure using ADO.NE
- call "exec sp_myproc val1,val2" statement over ADO SqlCommand myCommand = new SqlCommand(SQLQuery, mySqlConnection)
- use Command/Parameters objects to initialize and call the stored procedure

Which is a efficient way and wh

Appreciate your respons

Thank
Mik

 

[Andreas Håkansson]

Mike,

Using a SqlCommand and using parameters is the prefered way and it is the
most secure way since it help you protect your database from SQL Injection,
but enableing you to add type support and being able to control parameter
lenght etc.

//Andreas

Hi

There are two ways to execute a stored procedure using ADO.NET
- call "exec sp_myproc val1,val2" statement over ADO SqlCommand myCommand

= new SqlCommand(SQLQuery, mySqlConnection);