public static DataTable ConvertOleDbReaderToDataTable(DbDataReader reader) { int fieldCount = reader.FieldCount; DataTable schemaTable = reader.GetSchemaTable(); DataTable dataTable = DBConn.BuildAndInitDataTable(schemaTable); if (dataTable == null) { return(null); } while (reader.Read()) { DataRow dataRow = dataTable.NewRow(); for (int i = 0; i < fieldCount; i++) { dataRow[i] = reader[i]; } dataTable.Rows.Add(dataRow); } return(dataTable); }