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)); }
public ExcelCommand(string cmdText, ExcelConnection connection) { this._cmdText = cmdText; this._connection = connection; this._parameters = new ExcelParameterCollection(); }