public static IDbRowReader CreateRowReader()
{
IDbRowReader rowReader = null;
rowReader = new DbRowReader();
return(rowReader);
}
public static IDbRowReader CreateRowReader(DbDataReader reader)
{
IDbRowReader rowReader = null;
try
{
rowReader = new DbRowReader();
rowReader.ImportDataFromDataReader(reader);
}
catch (Exception e) { throw; }
return(rowReader);
}
public IDbRowReader ImportDataFromDataReader(DbDataReader reader)
{
DbRowReader dbReader = null;
try
{
if (reader == null)
{
throw new ArgumentNullException(nameof(reader));
}
if (reader.IsClosed)
{
throw new Exception("DbDataReader is already closed.");
}
dbReader = new DbRowReader();
if (reader.HasRows)
{
IDbRow row;
//IDbCell cell;
int count;
while (reader.Read())
{
row = dbReader.NewRow();
count = reader.FieldCount;
for (int counter = 0; counter < count; counter++)
{
//cell = row.CreateCell(reader.GetName(counter), reader.GetFieldType(counter), reader[counter]);
//row.AddCell(cell);
row.AddCell(reader.GetName(counter), reader.GetFieldType(counter), reader[counter]);
}
}
}
}
catch (Exception e) { throw; }
return(dbReader);
}
