public void LoadDataTable(DataTable dataTable, DbDataReader dbReader)
{
Int32 origRowLen = 0;
Object[] origRowData = null;
Int32 rowLen = 0;
Object[] rowData = null;
Int32 maxRowCount = DBQuerierConfig.Instance.GetMaxFetchRowCount();
origRowLen = dataTable.Columns.Count - m_ColumnConverters.Length;
origRowData = new Object[origRowLen];
rowLen = dataTable.Columns.Count;
rowData = new Object[rowLen];
while (dataTable.Rows.Count < maxRowCount && dbReader.Read())
{
DataRow newRow = dataTable.NewRow();
dbReader.GetValues(origRowData);
Array.Copy(origRowData, rowData, origRowData.Length);
for (Int32 i = 0; i < m_ColumnConverters.Length; ++i)
{
IDataColumnConverter colConverter = m_ColumnConverters[i];
Object colVal = rowData[colConverter.ColumnIndex];
rowData[origRowLen + i] = colConverter.Convert(colVal);
}
newRow.ItemArray = rowData;
dataTable.Rows.Add(newRow);
}
dataTable.AcceptChanges();
}
public DataTable BuildDataTable(DbDataReader dbReader)
{
DataTable dataTable = new DataTable();
IDictionary <String, Int32> colNameSet = new SortedDictionary <String, Int32>(StringComparer.Ordinal);
List <IDataColumnConverter> colConverterList = new List <IDataColumnConverter>();
for (Int32 i = 0; i < dbReader.FieldCount; ++i)
{
dataTable.Columns.Add(dbReader.GetName(i), dbReader.GetFieldType(i));
Debug.WriteLine(String.Format("Query Column: {0}({1})", dbReader.GetName(i), dbReader.GetFieldType(i).Name));
colNameSet[dbReader.GetName(i)] = i;
}
foreach (ExtraColumnDef eachExtraCol in m_ExtraColDefs)
{
if (colNameSet.ContainsKey(eachExtraCol.SourceColumn))
{
IDataColumnConverter colConverter = CreateColumnConverter(eachExtraCol);
colConverter.ColumnIndex = colNameSet[eachExtraCol.SourceColumn];
colConverterList.Add(colConverter);
dataTable.Columns.Add(eachExtraCol.ColumnName, typeof(String));
}
}
m_DataTable = dataTable;
m_ColumnConverters = colConverterList.ToArray();
return(dataTable);
}
public DataTable AddExtraColumn(DataTable dataTable)
{
DataTable newDataTbl = new DataTable();
IDictionary <String, Int32> colNameSet =
dataTable.Columns.Cast <DataColumn>().ToDictionary(c => c.ColumnName, c => c.Ordinal, StringComparer.Ordinal);
List <IDataColumnConverter> colConverterList = new List <IDataColumnConverter>();
newDataTbl.Columns.AddRange(
dataTable.Columns.Cast <DataColumn>().Select(c => new DataColumn(c.ColumnName, c.DataType)).ToArray());
foreach (ExtraColumnDef eachExtraCol in m_ExtraColDefs)
{
if (colNameSet.ContainsKey(eachExtraCol.SourceColumn))
{
IDataColumnConverter colConverter = CreateColumnConverter(eachExtraCol);
colConverter.ColumnIndex = colNameSet[eachExtraCol.SourceColumn];
colConverterList.Add(colConverter);
newDataTbl.Columns.Add(eachExtraCol.ColumnName, typeof(String));
}
}
Int32 origRowLen = dataTable.Columns.Count;
Int32 rowLen = newDataTbl.Columns.Count;
Object[] rowData = new Object[rowLen];
foreach (DataRow r in dataTable.Rows)
{
DataRow newRow = newDataTbl.NewRow();
Array.Copy(r.ItemArray, rowData, r.ItemArray.Length);
for (Int32 i = 0; i < colConverterList.Count; ++i)
{
IDataColumnConverter colConverter = colConverterList[i];
rowData[origRowLen + i] = colConverter.Convert(rowData[colConverter.ColumnIndex]);
}
newRow.ItemArray = rowData;
newDataTbl.Rows.Add(newRow);
}
newDataTbl.AcceptChanges();
return(newDataTbl);
}
