DataSourceImporter Class |
[Missing <summary> documentation for "T:Demo3D.Utilities.DataSourceImporter"]
Namespace: Demo3D.Utilities
public class DataSourceImporter : IDataSourceImporter
The DataSourceImporter type exposes the following members.
| Name | Description | |
|---|---|---|
| DataSourceImporter | Initializes a new instance of the DataSourceImporter class | |
| DataSourceImporter(String) | Initializes a new instance of the DataSourceImporter class |
| Name | Description | |
|---|---|---|
| ConnectionString | ||
| CurrentRow | ||
| HasHeader | ||
| IgnoreErrorRows | ||
| InvariantStringColumns | ||
| OnError | ||
| PathIsTextFile | ||
| PathIsTextOrFolder | ||
| PathName | ||
| TableName |
| Name | Description | |
|---|---|---|
| FindColumn(ListString, Int32, IEnumerableString) | ||
| FindColumn(ListString, Int32, IListString) | ||
| FindColumn(ListString, Int32, String) | ||
| FindNames | ||
| FindTableNames | ||
| Get | ||
| GetColumnNames | ||
| GetColumnNames(String) | ||
| GetConnectionStringFromFile(String) | ||
| GetConnectionStringFromFile(String, Boolean) | ||
| GetDataRows | ||
| GetDataRows(String, Boolean) | ||
| GetDataTable | ||
| GetDataTable(String) | ||
| GetTableNames | ||
| GetTableNames(String, Boolean) | ||
| ReadDataTable |
Read a spreadsheet file straight into a datatable:
http://windowsclient.net/blogs/faqs/archive/2006/05/30/how-do-i-load-a-csv-file-into-a-datatable.aspx
Connection strings:
http://www.connectionstrings.com/
Where sourceString is an Excel file the table name is first checked against any defined names in the workbook and
if there is no defined name then the worksheet matching the tableName is used. Finally the first worksheet is used if
there is no other match.
| |
| ReadDataTableFromTextFile |
Read table data from a file (.txt,.csv,.xls,.xlsx,etc.).
| |
| ToString | (Overrides ObjectToString.) |
| Name | Description | |
|---|---|---|
| ImportableFiles | ||
| TypeGuessRows |
The number of rows to examine when importing an excel spreadsheet in order to determine the column type.
|