oc A

oc A

  • NA
  • 30
  • 0

Passing Parameters to Stored Procedure

Feb 15 2008 1:28 AM

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)