SqlDataReader to DataTable
SqlDataReader DB_reader = Comm_String.ExecuteReader();
DataTable DT = new DataTable();
DataRow relation;
while (await DB_reader.ReadAsync())
{
relation = DT.NewRow();
if (i == 1)
{
for (int k = 0; k < DB_reader.FieldCount; k++)
{
DT.Columns.Add(new DataColumn(DB_reader.GetName(k), DB_reader.GetFieldType(k)));
}
}
object[] values = new object[DB_reader.VisibleFieldCount];
DB_reader.GetValues(values);
relation.ItemArray = values;
DT.Rows.Add(relation);
i++;
} // while End