1
Reply

Passing Parameters to Stored Procedure

oc A

oc A

Feb 15 2008 1:28 AM
2.3k

Parameters are passed to Stored Procedure from VB.NET Application like

Dim param As SqlParameter
param = New SqlParameter("@name",DbType.String)
param.Direction = ParameterDirection.Input
param.Value = "ABC"
comand.Parameters.Add(param)

But is there any way to specify parameters without specifying the
parameter name and type like

Dim param As SqlParameter
param = New SqlParameter
param.Direction = ParameterDirection.Input
param.Value = "ABC"
comand.Parameters.Add(param)


But when i try like this i am getting an error saying that "Parameter1 is not a parameter in the procedure"...

I cannot make any changes in the Stored Procedure
Can anybody tell me how to solve this .
Thanx in advance


Answers (1)