Create a Parameterized Stored Procedure Microsoft Corporation Constructs a command object for executing a stored procedure with parameters. adoSprocWParams
System.Data.dll System.XML.dll System.Data System.Data.SqlClient procedureName String Replace with the stored procedure name. CustOrderHist columnName String Replace with the parameter name. @customerID value String Replace with the new value. "ALFKI" conn System.Data.SqlClient.SqlConnection Replace with a connection object. conn firstParameter SqlParameter Replace with name of the parameter. customerIDParam sprocCmd SqlCommand Replace with the commad object. cmd