public object GetParameter(string parameterName)
        {
            ExcelParameterCollection parameters = this._command.Parameters;

            if (parameters.Contains(parameterName))
            {
                return(parameters[parameterName]);
            }
            if (parameterName.StartsWith("@") && parameters.Contains(parameterName.Substring(1)))
            {
                return(parameters[parameterName.Substring(1)]);
            }
            throw new ExcelException(string.Format("Cannot get parameter {0}.", parameterName));
        }
Example #2
0
 public ExcelCommand(string cmdText, ExcelConnection connection)
 {
     this._cmdText    = cmdText;
     this._connection = connection;
     this._parameters = new ExcelParameterCollection();
 }