Method | Description | |
---|---|---|
Dispose ( ) : void |
Close the OleDb connection
|
|
ExecuteCommnand ( String strCmd ) : int |
Execute SQL command, such as: update and insert
|
|
GenDataTable ( String tableName ) : |
Generate a DataTable data from xls data source, by a specified table name
|
|
RetrieveAllTables ( ) : List |
Get all available table names from .xls data source
|
|
XlsDBConnector ( String strXlsFile ) : System |
Class constructor, to retrieve data from .xls data source
|
Method | Description | |
---|---|---|
CheckSameColName ( String baseName, String compName ) : bool |
Check if two columns names are the same
|
|
ValidateFile ( String strFile ) : bool |
This method will validate and update attributes the specified file. The file should exist and it should have writable attribute. If it's readonly, this method will try to set the attribute to writable.
|
public ExecuteCommnand ( String strCmd ) : int | ||
strCmd | String | command to be executed |
return | int |
public GenDataTable ( String tableName ) : |
||
tableName | String | Table name to be retrieved |
return |
public XlsDBConnector ( String strXlsFile ) : System | ||
strXlsFile | String | The .xls file to be connected. /// This file should exist and it can be writable. |
return | System |