private void update_btn_Click(object sender, EventArgs e)
        {
            // SqlConnection c = new SqlConnection(@"Data Source=desktop-olv0avb\sqlexpress;Initial Catalog=police_management_system;Integrated Security=True;Pooling=False");
            string         query = " update employee_table set police_id=" + text_id.Text + " , Name = '" + text_Name.Text + "' , Rank='" + text_rank.Text + "' , Address='" + text_address.Text + "' , [D.O.B]='" + text_dob.Text + "' , Grade=" + textBox1.Text + " , CNIC='" + text_cnic.Text + "' , date_of_employment='" + text_doe.Text + "' , date_of_retirement='" + textBox2.Text + "' , Gender='" + comboBox1.Text + "' where police_id=" + text_id.Text + " ";
            SqlDataAdapter sda   = new SqlDataAdapter(query, sqlConnection);
            DataTable      d     = new DataTable();

            sda.Fill(d);
            datashow display = new datashow(d);

            this.Hide();
            display.Show();
        }
        private void insert_btn_Click(object sender, EventArgs e)
        {
            // SqlConnection c = new SqlConnection(@"Data Source=desktop-olv0avb\sqlexpress;Initial Catalog=police_management_system;Integrated Security=True;Pooling=False");
            string         query = "insert into employee_table values(" + text_id.Text + ",'" + text_Name.Text + "','" + text_rank.Text + "','" + text_address.Text + "','" + text_dob.Text + "'," + textBox1.Text + ",'" + text_cnic.Text + "','" + text_doe.Text + "','" + textBox2.Text + "','" + comboBox1.Text + "') ";
            SqlDataAdapter sda   = new SqlDataAdapter(query, sqlConnection);
            DataTable      d     = new DataTable();

            sda.Fill(d);
            datashow display = new datashow(d);

            this.Hide();
            display.Show();
        }
        private void del_btn_Click(object sender, EventArgs e)
        {
            // SqlConnection c = new SqlConnection(@"Data Source=desktop-olv0avb\sqlexpress;Initial Catalog=police_management_system;Integrated Security=True;Pooling=False");
            string         query = " delete from employee_table where police_id=" + text_id.Text + " ";
            SqlDataAdapter sda   = new SqlDataAdapter(query, sqlConnection);
            DataTable      d     = new DataTable();

            sda.Fill(d);
            datashow display = new datashow(d);

            this.Hide();
            display.Show();
        }
        private void search_btn_Click(object sender, EventArgs e)
        {
            // SqlConnection c = new SqlConnection(@"Data Source=desktop-olv0avb\sqlexpress;Initial Catalog=police_management_system;Integrated Security=True;Pooling=False");
            string         query = "select * from employee_table where police_id=" + text_id.Text + " ";
            SqlDataAdapter sda   = new SqlDataAdapter(query, sqlConnection);
            DataTable      d     = new DataTable();

            sda.Fill(d);
            if (d.Rows.Count == 0)
            {
                MessageBox.Show("WARNING! YOU MIGHT INPUTTED WRONG ID PLEASE TRY AGAIN THANKS 😁");
            }
            else
            {
                datashow display = new datashow(d);
                this.Hide();
                display.Show();
            }
        }