public void Close()
{
this.Reset();
this._selectStatement = null;
this._command = null;
this._evaluator = null;
}
public ExcelResultSet(ISQLStatement sqlStatement, ExcelCommand command)
{
if (sqlStatement.Type != StatementType.Select)
{
throw new NotSupportedException(sqlStatement.ToString());
}
SelectStatement selectStatement = (SelectStatement)sqlStatement;
if (!command.Connection.HasTable(selectStatement.Table.Name))
{
throw new ExcelException("Cannot find table " + selectStatement.Table.Name);
}
this.Reset();
this._selectStatement = selectStatement;
this._command = command;
this._evaluator = new ExcelEvalVisitor(new ExcelEvalContext(this));
}
public ExcelDataAdapter(string selectCommandText, string selectConnectionString)
{
ExcelConnection connection = new ExcelConnection(selectConnectionString);
this._selectCommand = new ExcelCommand(selectCommandText, connection);
}
public ExcelDataAdapter(string selectCommandText, ExcelConnection selectConnection)
{
this._selectCommand = new ExcelCommand(selectCommandText, selectConnection);
}
public ExcelDataAdapter(ExcelCommand selectCommand)
{
this._selectCommand = selectCommand;
}
