OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "EmployeeSalesByEmployee(5)"; ** execute the stored procedure **Here's the non-working code:
OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "EmployeeSalesByEmployee(?)"; OleDbParameter param = new OleDbParameter("", 5); cmd.Parameters.Add(param); ** execute the stored procedure **This code fails with an OleDbException with a message of "Syntax Error".