private DataTable GetColumnsSchema()
{
DataTable dt = new DataTable();
dt.Columns.Add("TABLE_CATALOG", typeof(string));
dt.Columns.Add("TABLE_SCHEMA", typeof(string));
dt.Columns.Add("TABLE_NAME", typeof(string));
dt.Columns.Add("COLUMN_NAME", typeof(string));
dt.Columns.Add("DATA_TYPE", typeof(string));
dt.Columns.Add("IS_NULLABLE", typeof(string));
dt.Columns.Add("DataType", typeof(string));
dt.Columns.Add("ProviderDbType", typeof(ExcelDbType));
List <ColumnInfo> columns = this.GetColumns();
foreach (ColumnInfo column in columns)
{
dt.Rows.Add(
string.Empty,
"Excel",
column.TableAlias,
column.ColumnName,
column.DataType,
"YES",
DataTypeUtil.GetDotNetType(column.DataType).FullName,
column.DataType)
;
}
return(dt);
}
private DataTable GetDataTypesSchema()
{
DataTable dt = new DataTable();
dt.Columns.Add("TypeName", typeof(string));
dt.Columns.Add("ProviderDbType", typeof(int));
dt.Columns.Add("DataType", typeof(string));
foreach (ExcelDbType dbType in Enum.GetValues(typeof(ExcelDbType)))
{
dt.Rows.Add(DataTypeUtil.GetTypeName(dbType), (int)dbType, DataTypeUtil.GetDotNetType(dbType).FullName);
}
return(dt);
}
public override Type GetFieldType(int ordinal)
{
ColumnInfo column = this._resultSet.GetColumn(ordinal);
return(DataTypeUtil.GetDotNetType(column.DataType));
}