private void reloadB_Click(object sender, EventArgs e)
 {
     il.image_load(mobileNoL.Text, studentPB);
 }
        private void studentDGV_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            int row    = e.RowIndex;
            int column = 0;

            if (row > -1)
            {
                string sid = studentDGV[column, row].Value.ToString();
                try
                {
                    con.Open();

                    MySqlCommand cmd = new MySqlCommand("SELECT s.hall_std_id, s.session, s.class_roll, s.registration_no, s.name, s.f_name, s.m_name, s.address, s.sex, s.religion,s.degree, s.mobile, s.phone, s.email, s.blood_group, s.alloted_room, h.hall_name, d.dept_name,f.faculty_name ,q.qouta_name, u.name AS Added_By,s.status FROM student_info as s,dept_info as d,faculty_info as f,hall_info as h,qouta as q ,user as u where s.dept_id = d.dept_id and s.faculty_id = f.faculty_id and s.hall_id = h.hall_id and s.qouta_id = q.qouta_id and s.added_by = u.user_id and s.hall_std_id =" + sid, con);

                    MySqlDataReader reader = cmd.ExecuteReader();

                    if (reader.Read())
                    {
                        studentIdL.Text           = reader.GetString("hall_std_id").ToString();
                        sessionCB.SelectedItem    = reader.GetString("session").ToString();
                        classRollTB.Text          = reader.GetString("class_roll").ToString();
                        registrationTB.Text       = reader.GetString("registration_no").ToString();
                        studentNameTB.Text        = reader.GetString("name").ToString();
                        fatherNameTB.Text         = reader.GetString("f_name").ToString();
                        motherNameTB.Text         = reader.GetString("m_name").ToString();
                        addressTB.Text            = reader.GetString("address").ToString();
                        sexCB.SelectedItem        = reader.GetString("sex").ToString();
                        religionTB.Text           = reader.GetString("religion").ToString();
                        degreeCB.SelectedItem     = reader.GetString("degree").ToString();
                        mobileTB.Text             = reader.GetString("mobile").ToString();
                        phoneTB.Text              = reader.GetString("phone").ToString();
                        emailTB.Text              = reader.GetString("email").ToString();
                        bloodGroupCB.SelectedItem = reader.GetString("blood_group").ToString();
                        roomTB.Text = reader.GetString("alloted_room").ToString();

                        hallNameCB.SelectedItem    = reader.GetString("hall_name").ToString();
                        deptNameCB.SelectedItem    = reader.GetString("dept_name").ToString();
                        facultyNameCB.SelectedItem = reader.GetString("faculty_name").ToString();
                        qoutaCB.SelectedItem       = reader.GetString("qouta_name").ToString();
                        addedByL.Text = reader.GetString("Added_By").ToString();
                        int status = reader.GetInt32("status");
                        if (status == 0)
                        {
                            currentStudentRB.Checked = true;
                        }
                        else
                        {
                            oldStudentRB.Checked = true;
                        }


                        il.image_load(reader.GetString("mobile"), studentPB);
                    }
                    reader.Close();


                    con.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error occured. Message - " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    con.Close();
                }
            }
        }