protected void get_list_of_public_holidays()
        {
            DataTable dt = Guard_deployment.return_list_of_public_holidays("return_list_of_public_holidays");

            if (dt.Rows.Count > 0)
            {
                this.gdv_public_holidays.DataSource = dt;
                this.gdv_public_holidays.Columns["record_guid"].Visible            = false;
                this.gdv_public_holidays.Columns["deployment_period_id"].Visible   = false;
                this.gdv_public_holidays.Columns["public_holiday_name"].HeaderText = "Public Holiday Name";
                this.gdv_public_holidays.Columns["public_holiday_date"].HeaderText = "Public Holiday Date";
                this.gdv_public_holidays.RowsDefaultCellStyle.BackColor            = Color.LightGray;
                this.gdv_public_holidays.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
                this.gdv_public_holidays.ColumnHeadersDefaultCellStyle.ForeColor   = Color.White;
                this.gdv_public_holidays.ColumnHeadersDefaultCellStyle.BackColor   = Color.Black;
                this.gdv_public_holidays.RowHeadersDefaultCellStyle.BackColor      = Color.Black;
                this.gdv_public_holidays.DefaultCellStyle.SelectionBackColor       = Color.Cyan;
                this.gdv_public_holidays.DefaultCellStyle.SelectionForeColor       = Color.Black;
                foreach (DataGridViewColumn c in this.gdv_public_holidays.Columns)
                {
                    c.DefaultCellStyle.Font = new System.Drawing.Font("Arial", 11f, GraphicsUnit.Pixel);
                }
                this.gdv_public_holidays.ColumnHeadersDefaultCellStyle.BackColor = Color.CadetBlue;
                this.gdv_public_holidays.EnableHeadersVisualStyles = false;
            }
        }
        protected void get_list_of_public_holidays()
        {
            DataTable dt = Guard_deployment.return_list_of_public_holidays("return_list_of_public_holidays");

            if (dt.Rows.Count > 0)
            {
                gdv_public_holidays.DataSource = dt;

                gdv_public_holidays.Columns["record_guid"].Visible          = false;
                gdv_public_holidays.Columns["deployment_period_id"].Visible = false;

                gdv_public_holidays.Columns["public_holiday_name"].HeaderText = "Public Holiday Name";
                gdv_public_holidays.Columns["public_holiday_date"].HeaderText = "Public Holiday Date";

                gdv_public_holidays.RowsDefaultCellStyle.BackColor            = Color.LightGray;
                gdv_public_holidays.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;

                // Set the row and column header styles.
                gdv_public_holidays.ColumnHeadersDefaultCellStyle.ForeColor = Color.White;
                gdv_public_holidays.ColumnHeadersDefaultCellStyle.BackColor = Color.Black;
                gdv_public_holidays.RowHeadersDefaultCellStyle.BackColor    = Color.Black;

                // Set the selection background color for all the cells.
                gdv_public_holidays.DefaultCellStyle.SelectionBackColor = Color.Cyan;
                gdv_public_holidays.DefaultCellStyle.SelectionForeColor = Color.Black;

                foreach (DataGridViewColumn c in gdv_public_holidays.Columns)
                {
                    c.DefaultCellStyle.Font = new Font("Arial", 11F, GraphicsUnit.Pixel);
                }

                //set the background color of the header row
                gdv_public_holidays.ColumnHeadersDefaultCellStyle.BackColor = Color.CadetBlue;
                gdv_public_holidays.EnableHeadersVisualStyles = false;
            }
        }