public static IDataType[] GetDataTypes(OleDbDataReader reader)
{
List<IDataType> types = new List<IDataType>();
for (int i = 0; i < reader.FieldCount; i++)
{
if (reader.GetFieldType(i) == typeof(string))
{
types.Add(new VarChar(reader.GetName(i), 1000));
}
else
{
types.Add(new Number(reader.GetName(i)));
}
}
return types.ToArray();
}
public void StoreColumnTypes(OleDbDataReader Reader)
{
ColumnDataTypes = new DataType[Reader.FieldCount];
for (int i = 0; i < ColumnDataTypes.Length; i++)
{
Type T = Reader.GetFieldType(i);
if (T == Type.GetType("System.String"))
{
ColumnDataTypes[i] = DataType.TypeString;
}
else if (T == Type.GetType("System.DateTime"))
{
ColumnDataTypes[i] = DataType.TypeDate;
}
else
{
ColumnDataTypes[i] = DataType.TypeInt;
}
}
}
// Display the result set recursively expanding chapterDepth deep
public void DisplayReader(OleDbDataReader myDataReader, ref uint count, uint alignment, int chapterDepth)
{
try
{
// compute alignment
StringBuilder indent = new StringBuilder((int) alignment);
indent.Append(' ', (int) alignment);
while (myDataReader.Read())
{
// add alignment
StringBuilder row = new StringBuilder(indent.ToString());
// for all columns
for (int i = 0; i < myDataReader.FieldCount; i++)
{
// null columns
if (myDataReader.IsDBNull(i))
{
row.Append("NULL;");
}
else
{
//vector columns
object[] myArray = myDataReader.GetValue(i) as object[];
if (myArray != null)
{
DisplayValue(myArray, row);
}
else
{
//check for chapter columns from "group on" queries
if (myDataReader.GetFieldType(i).ToString() != "System.Data.IDataReader")
{
//regular columns are displayed here
row.Append(myDataReader.GetValue(i));
}
else
{
//for a chapter column type just display the colum name
row.Append(myDataReader.GetName(i));
}
}
row.Append(';');
}
}
if (chapterDepth >= 0)
{
this.ScrubberGUIInst.DebugPrint(row.ToString());
count++;
}
// for each chapter column
for (int i = 0; i < myDataReader.FieldCount; i++)
{
if (myDataReader.GetFieldType(i).ToString() == "System.Data.IDataReader")
{
OleDbDataReader Reader = myDataReader.GetValue(i) as OleDbDataReader;
DisplayReader(Reader, ref count, alignment + 8, chapterDepth - 1);
}
}
}
}
finally
{
myDataReader.Close();
myDataReader.Dispose();
}
}
// Display the result set recursively expanding chapterDepth deep
static void DisplayReader(OleDbDataReader myDataReader, ref uint count, uint alignment, int chapterDepth)
{
try
{
// compute alignment
StringBuilder indent = new StringBuilder((int)alignment);
indent.Append(' ', (int)alignment);
while (myDataReader.Read())
{
// add alignment
StringBuilder row = new StringBuilder(indent.ToString());
// for all columns
for (int i = 0; i < myDataReader.FieldCount; i++)
{
// null columns
if (myDataReader.IsDBNull(i))
{
row.Append("NULL\t");
}
else
{
//vector columns
object[] myArray = myDataReader.GetValue(i) as object[];
if (myArray != null)
{
DisplayValue(myArray, row);
}
else
{
//check for chapter columns from "group on" queries
if (myDataReader.GetFieldType(i).ToString() != "System.Data.IDataReader")
{
//regular columns are displayed here
//If (OptPath == false) and colName is System.ItemPathDisplay
//We want to skip Display of this Column
if (!(OptPath == false && myDataReader.GetName(i) == "System.ItemPathDisplay"))
row.Append(myDataReader.GetValue(i));
}
else
{
//for a chapter column type just display the colum name
row.Append(myDataReader.GetName(i));
}
}
row.Append('\t');
}
}
if (chapterDepth >= 0)
{
Console.WriteLine(row.ToString());
count++;
}
// for each chapter column
for (int i = 0; i < myDataReader.FieldCount; i++)
{
if (myDataReader.GetFieldType(i).ToString() == "System.Data.IDataReader")
{
OleDbDataReader Reader = myDataReader.GetValue(i) as OleDbDataReader;
DisplayReader(Reader, ref count, alignment + 8, chapterDepth - 1);
}
}
}
}
finally
{
myDataReader.Close();
myDataReader.Dispose();
}
}
private int GetValue(OleDbDataReader oData)
{
int intValue;
string strFieldType;
strFieldType = Convert.ToString(oData.GetFieldType(0));
switch (strFieldType)
{
case "System.Int16":
intValue = Convert.ToInt32(oData.GetInt16(0));
break;
case "System.Int32":
intValue = oData.GetInt32(0);
break;
case "System.Double":
intValue = Convert.ToInt32(oData.GetDouble(0));
break;
default:
intValue = oData.GetInt32(0);
break;
}
return intValue;
}
