Last post May 26, 2016 06:52 AM by Mikesdotnetting
May 26, 2016 05:58 AM|jayakumarvinayagam|LINK
I have a stored procedure with five parameters in my back-end(sql server), in C# code, I know the stored procedure name but don't know how many argument need to pass, and what type of data have to pass. there is any way to pass respective arguments and value.
It looks like accrue SP detail while dynamic.
I really appreciate your valuable comment.
May 26, 2016 06:52 AM|Mikesdotnetting|LINK
The SqlClient provider works by matching parameter values based on name. So you need to be able to add the SqlParameter objects to the command using the name of each one that's required. You also need to pass in the correct data type - or a value that can
be converted to the correct data type.