Jun
24

Stored Procedure Syntax error with C# and the SQLCommand object

AndyDevelopmentComment (1)

What is wrong with the following statement?

private SQLCommand _cmd = new SQLCommand();

public void ExecuteStoredProcedure(string procedureName SQLParameter[] parms)
{
  _cmd.Connection = _dbConn;
  _cmd.CommandType = CommandType.StoredProcedure;
  _cmd.CommandText = procedureName;
  _cmd.Parameters.AddRange(parms);
  _cmd.ExecuteScalar();
}

Read more…