By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,225 Members | 2,172 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,225 IT Pros & Developers. It's quick & easy.

Stored Procedure Parameters

P: n/a
What are they for?
Why do we have to match them inside our C# or VB code?
Are they so the end user can input a value to query on?
When do we have to use them in C# and the SQL Server Stored Procedure
Nov 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
rk
You are right - they are there for passing parameters to the stored
procedure. You need to pass it from your client code if you want to
execute the stored procedure (and if the stored procedure needs
parameter(s) ). Calling them, passing the parameters and getting the
result back from it is very straightforward thru ADO.NET etc. and is
well documented in msdn library (library.msdn.com).

Nov 17 '05 #2

P: n/a
You could always let this ado.net code generator for sql server
write the code for you:

http://www.eggheadcafe.com/articles/..._generator.asp

--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net

"caseyoconnor2" <ca***********@cox.net> wrote in message
news:rRGie.9141$Ri4.6341@okepread07...
What are they for?
Why do we have to match them inside our C# or VB code?
Are they so the end user can input a value to query on?
When do we have to use them in C# and the SQL Server Stored Procedure

Nov 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.