Calling SP from .net
-
Calling by the other way: Is it possible to call a stored procedure WITH PARAM from .net WITHOUT using "AddParams" ? I mean we should be able to call(exec) the SP just like we do in the query analyser. I'd construct the string like "sp_testproc '111','RR',23'". and execute it as nonQuery. Is there any way? please help.
*
-
Calling by the other way: Is it possible to call a stored procedure WITH PARAM from .net WITHOUT using "AddParams" ? I mean we should be able to call(exec) the SP just like we do in the query analyser. I'd construct the string like "sp_testproc '111','RR',23'". and execute it as nonQuery. Is there any way? please help.
*
Astricks wrote:
'd construct the string like "sp_testproc '111','RR',23'". and execute it as nonQuery. Is there any way? please help.
You could use an SqlCommand object and pass the SQL command string as "exec sp_testproc '111','RR',23'".
Michael CP Blog [^] Development Blog [^]
-
Astricks wrote:
'd construct the string like "sp_testproc '111','RR',23'". and execute it as nonQuery. Is there any way? please help.
You could use an SqlCommand object and pass the SQL command string as "exec sp_testproc '111','RR',23'".
Michael CP Blog [^] Development Blog [^]
-
Calling by the other way: Is it possible to call a stored procedure WITH PARAM from .net WITHOUT using "AddParams" ? I mean we should be able to call(exec) the SP just like we do in the query analyser. I'd construct the string like "sp_testproc '111','RR',23'". and execute it as nonQuery. Is there any way? please help.
*
You could also stop cross posting.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before. -
have a google for SQL Injection first. Russ
-
have a google for SQL Injection first. Russ
Russell Jones wrote:
have a google for SQL Injection first.
Thanks for adding that. I really should have included that in my original reply.
Michael CP Blog [^] Development Blog [^]