Example #1
0
        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;
        }
Example #2
0
        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;
        }