mitesh114
asked on
passing through more than one parameter to a stored procedure.
how do you accept multiple stored procedure parameters at the same time? I have the following code:
SqlParameter myParm1 = myCmd.Parameters.Add("@Par ameter1", System.Data.SqlDbType.VarC har, 20);
myParm1.Value = "string";
I want to be able to pass more than one value through to the stored procedure
SqlParameter myParm1 = myCmd.Parameters.Add("@Par
myParm1.Value = "string";
I want to be able to pass more than one value through to the stored procedure
ASKER
i'm not using that version. I'm using the previous one.
myCmd.Parameters.Add("@Par ameter1", "string");
Andrew
Andrew
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
2005 has this form:
myCmd.Parameters.AddWithVa
Bob