|
-
Dec 17th, 2003, 05:10 PM
#1
Thread Starter
Hyperactive Member
How to pass 2 parameters to a sql server stored proc in ado.net
I am using data access application block and there is a method called as "executereader" and it expects parameters in array.
the syntax for this method is
sqlhelper.executeReader(connectionstring as string, spname as string, paramarray Parametervalues() as object)
The stored proc I am passing has 2 parameters.
first paramter is :
parameter name is customerID
and parameter value is '1'
second paramter is:
parameter name is orderid
and paramter value is '1028'
can someone give some lead as how to build these 2 paramters?
thanks
nath
executeReader(connectionstring as string, spname as string, paramarray Parametervalues() as object) first paramter is : second paramter is:
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|