Public DataTable ConvertDataReadertodataTable (SqlDataReader DataRead)
{
DataTable DataTable = New DataTable ();
DataTable Schematable = DataReader.getschematable ();
// Dynamic Add Column
Try
{
Foreach (DataRow Myrow In schement.rows)
{
Datacolumn mydatacolumn = new datacolumn ();
MyDataColumn.DataType = myrow.gettype ();
MyDatacolumn.columnname = myrow [0] .tostring ();
DataTable.columns.add (myDatacolumn);
}
//adding data
While (DataReader.Read ())
{
DataRow mydatarow = dataable.newrow ();
For (int i = 0; i
{
MyDataRow [i] = datareader [i] .tostring ();
}
DataTable.Rows.Add (MyDATAROW);
mydatarow = null;
}
Schematable = NULL;
Return DataTable;
}
Catch (Exception EX)
{
//Rror.log (ex. TString ());
Return DataTable;
}
}
