private void AddDataTableColumns(DataTable dataTable, XapDataReader dr)
{
for (int x = 0; x <= dr.FieldCount - 1; x++)
{
DataColumn column = new DataColumn(dr.GetName(x), dr.GetFieldType(x));
dataTable.Columns.Add(column);
}
}
private void AddDataRow(DataTable dataTable, XapDataReader dr)
{
object obj = null;
Type t = null;
DataRow dataRow = dataTable.NewRow();
for (int i = 0; i <= dr.FieldCount - 1; i++)
{
obj = dr.GetValue(i);
t = dr.GetFieldType(i);
if (obj == null || string.IsNullOrEmpty(obj.ToString()))
{
dataRow[i] = t.GetDefaultValue();
}
else
{
dataRow[i] = dr.GetValue(i);
}
}
dataTable.Rows.Add(dataRow);
}
