Parameters are passed to Stored Procedure from VB.NET Application likeDim param As SqlParameterparam = New SqlParameter("@name",DbType.String)param.Direction = ParameterDirection.Inputparam.Value = "ABC"comand.Parameters.Add(param)But is there any way to specify parameters without specifying theparameter name and type likeDim param As SqlParameterparam = New SqlParameterparam.Direction = ParameterDirection.Inputparam.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