private void BuildLabSelectors(DataTable labs) { // get a distinct list of lab types sorting ascending var distinctLabs = (from row in labs.AsEnumerable() let lab = row["VarName"].ToString() where row["VarValue"].ToString().Length > 0 where row["VarDate"].ToString().Length > 0 orderby lab ascending select lab).Distinct(); LabCheckList.DataSource = distinctLabs; LabCheckList.DataBind(); // set default lab value ListItem i = LabCheckList.Items.FindByText(defaultLabValue); if (i != null) { i.Selected = true; } LabCheckList2.DataSource = distinctLabs; LabCheckList2.DataBind(); LabCheckList2.Items.Insert(0, new ListItem(String.Empty, String.Empty)); // if (LabCheckList.SelectedValue.Length > 0) LabCheckList2.Items.Remove(LabCheckList.SelectedValue); }
/// <summary> /// Fills the lab test checkboxes with with distinct lab values /// </summary> /// <param name="ds"></param> protected void FillLabTestCheckBox(DataSet ds) { var labTestList = (from lab in ds.Tables[0].AsEnumerable() let labTest = lab["VarName"].ToString() select labTest).Distinct(); LabCheckList.DataSource = labTestList; LabCheckList.DataBind(); }