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:

try something like this

VB Code:

Dim ConnString As String
 
ConnString = "Driver={SQL Server};Server=serverName;User ID=username;PWD=password;Database=dbName"
 
sqlHelper.ExecuteReader(ConnString, "sp_ProcName", New Object() {@CustomerID, 1, @OrderID, 1028})

Or have a parameter array so you can write one generic method that is not dependent on the number of parameters like:

VB Code:

Dim prmDetails() As SqlClient.SqlParameter
 
prmDetails = SqlHelperParameterCache.GetSpParameterSet(ConnectionStringHere, StoredProcNameHere)
 
'Set parameters where your ordered params are in arrParameters
            For intParamCounter As Integer = 0 To arrParameters.Count() - 1
                prmDetails(intParamCounter).Value = arrParameters.Item(intParamCounter)
            Next
 
'Return the DataReader
            Return SqlHelper.ExecuteReader(ConnectionStringHere, CommandType.StoredProcedure, StoredProcNameHere, prmDetails)

nath

damm i've done this all the time:

Code:

---

myParam = myCommand.CreateParameter
myParam.ParameterName = "@issuerConfirmation"
myParam.Size = 1
myParam.SqlDbType = SqlDbType.Char
myParam.Value = myString(12)
myCommand.Parameters.Add(myParam)

---

not good when you have to pass 30 parameters!

I'll try this easier way!

dim arrparameters as collection()

Is that correct?

visual basic code:--------------------------------------------------------------------------------
Dim prmDetails() As SqlClient.SqlParameter

prmDetails = SqlHelperParameterCache.GetSpParameterSet(ConnectionStringHere, StoredProcNameHere)

'Set parameters where your ordered params are in arrParameters
For intParamCounter As Integer = 0 To arrParameters.Count() - 1
prmDetails(intParamCounter).Value = arrParameters.Item(intParamCounter)
Next

'Return the DataReader
Return SqlHelper.ExecuteReader(ConnectionStringHere, CommandType.StoredProcedure, StoredProcNameHere, prmDetails)
--------------------------------------------------------------------------------

thanks