OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "EmployeeSalesByEmployee"; OleDbParameter param = new OleDbParameter("", 5); cmd.Parameters.Add(param); ** execute the stored procedure **>I have a stored procedure in a VFP DBC that accepts a integer parameter. In .NET I can call this stored procedure if I hard code the parameter value in the CommandText property. But if I try to use the Command.Parameters collection to pass the parameter it fails.
>OleDbCommand cmd = new OleDbCommand(); >cmd.CommandType = CommandType.StoredProcedure; >cmd.CommandText = "EmployeeSalesByEmployee(5)"; >** execute the stored procedure ** >>
>OleDbCommand cmd = new OleDbCommand(); >cmd.CommandType = CommandType.StoredProcedure; >cmd.CommandText = "EmployeeSalesByEmployee(?)"; >OleDbParameter param = new OleDbParameter("", 5); >cmd.Parameters.Add(param); >** execute the stored procedure ** >>