private void getDistincts(string colName, bool fmtAsShortdate) { filterFldName = colName; //Fill cboFilter DataView Dv = dtbl.DefaultView; DataTable dtDistinct = Dv.ToTable(true, filterFldName); loading = true; cboFilter.Items.Clear(); cboFilter.Items.Add(nofilter); cboFilter.SelectedIndex = 0; for (int i = 0; i < dtDistinct.Rows.Count; i++) { if (fmtAsShortdate == true) { cboFilter.Items.Add(CCFBGlobal.ValidDate(dtDistinct.Rows[i][0]).ToShortDateString()); } else { cboFilter.Items.Add(dtDistinct.Rows[i][0].ToString()); } } cboFilter.Visible = (cboFilter.Items.Count > 1); loading = false; }
private void fillFilterCombo() { cboFilter.Visible = true; DataView Dv = dtbl.DefaultView; DataTable dtDistinct = Dv.ToTable(true, filterFldName); loading = true; cboFilter.Items.Clear(); cboFilter.Items.Add(nofilter); cboFilter.SelectedIndex = 0; for (int i = 0; i < dtDistinct.Rows.Count; i++) { if (isShortDate == true) { cboFilter.Items.Add(CCFBGlobal.ValidDate(dtDistinct.Rows[i][0]).ToShortDateString()); } else { cboFilter.Items.Add(dtDistinct.Rows[i][0].ToString()); } } loading = false; }