private void RunReport() { DataTable report = GetReport(); string[] columns = report.Columns.Cast <DataColumn>().Select(c => c.ColumnName).ToArray(); // build header HeaderRptr.DataSource = columns; HeaderRptr.DataBind(); // build results ResultsGrid.DataSource = report; ResultsGrid.DataBind(); }
private void BuildInventory(DataView inventoryView) { selectedColumns = GetSpecimenColumns(); // build header HeaderRptr.DataSource = selectedColumns; HeaderRptr.DataBind(); // build data string sortColumn = SortColumn.Value; string sortDirection = SortDirection.Value; if (!string.IsNullOrEmpty(sortColumn)) { // special case if (sortColumn == "PtProtocolStudyId" && inventoryView.Count > 0) { inventoryView = PatientProtocolController.SortPatientsByStudyId(inventoryView.ToTable(), sortDirection); } else { inventoryView.Sort = sortColumn + " " + sortDirection; } } // do not show NULL statuses inventoryView.RowFilter = Specimen.SpecimenStatus + " IS NOT NULL"; bool hideBankedSpeicmens = BankedSpecimensPreference.Checked && BankedSpecimensPreference.Visible; if (hideBankedSpeicmens) { inventoryView.RowFilter += " AND SpecimenSubType NOT IN ('Serum', 'Plasma', 'PAXGen')"; } SpecimenInventoryRows.DataSource = inventoryView; SpecimenInventoryRows.DataBind(); RecordCount.Text = inventoryView.Count + " Record(s)"; }