private void StudentDashbord_Load(object sender, EventArgs e)
        {
            OnlineExam ent     = new OnlineExam();
            var        student = ent.Select_Student(id).First();

            IDValue.Text      = student.Student_ID.ToString();
            NameValue.Text    = student.Student_Name;
            addressValue.Text = student.Home_City;

            var deptName = (from d in ent.Departments
                            where d.DeptId == student.Department_ID
                            select d).First();

            dept.Text = deptName.DeptName;
        }
 private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
 {
     if (dataGridView1.CurrentCell.ColumnIndex > 0)
     {
         this.dataGridView1.CurrentCell.Selected = false;
     }
     else
     {
         var id = dataGridView1.SelectedCells[0].Value;
         Select_Student_Result std = ent.Select_Student((int)id).First();
         var fname = std.Student_Name.Split(' ')[0];
         var lname = std.Student_Name.Remove(0, fname.Length);
         //MessageBox.Show(fname);
         comboBox1.Text = std.Student_ID.ToString();
         textBox1.Text  = lname;
         textBox2.Text  = fname;
         textBox3.Text  = std.Home_City;
         textBox4.Text  = std.Birth_Date.ToString();
     }
 }