Exemple #1
0
        private void btn_ChoiceSelect_Click(object sender, EventArgs e)
        {
            if (dgv_imgPath.Columns.Count > 0)
            {
                dgv_imgPath.Columns.Clear();
            }
            if (dgv_imgPath.Rows.Count > 0)
            {
                dgv_imgPath.Rows.Clear();
            }

            DateTime stTime = new DateTime(dtp_StartDate.Value.Year, dtp_StartDate.Value.Month, dtp_StartDate.Value.Day
                                           , Convert.ToInt32(nud_Start_Hour.Value), Convert.ToInt32(nud_Start_Minutes.Value), 0);

            DateTime edTime = new DateTime(dtp_EndDate.Value.Year, dtp_EndDate.Value.Month, dtp_EndDate.Value.Day
                                           , Convert.ToInt32(nud_End_Hour.Value), Convert.ToInt32(nud_End_Minutes.Value), 0);

            dgv_imgPath.DataSource = dbControl.GET_ChoiceIMGPATH(stTime, edTime);
            dgv_imgPath.Update();

            int last_index = dgv_imgPath.ColumnCount;

            for (int i = 0; i < last_index; i++)
            {
                if (i == (last_index - 1))
                {
                    dgv_imgPath.Columns[i].AutoSizeMode = (DataGridViewAutoSizeColumnMode)DataGridViewAutoSizeColumnsMode.DisplayedCells;
                }
                else
                {
                    dgv_imgPath.Columns[i].AutoSizeMode = (DataGridViewAutoSizeColumnMode)DataGridViewAutoSizeColumnsMode.AllCells;
                }
            }

            foreach (DataGridViewColumn dgvc in dgv_imgPath.Columns)
            {
                dgvc.SortMode = DataGridViewColumnSortMode.NotSortable;
            }

            dgv_imgPath.RowTemplate.Height = 50;

            for (int i = 0; i < dgv_imgPath.Rows.Count; i++)
            {
                if (dgv_imgPath.Rows[i].Cells[0].Value.ToString().ToLower().Equals("ng"))
                {
                    dgv_imgPath.Rows[i].Cells[0].Style.ForeColor = Color.Red;
                }
            }
        }