private void studentListView_DoubleClick(object sender, EventArgs e)
{
ListViewItem selectedItem = studentListView.SelectedItems[0];
StudentWithDepartment astudent = selectedItem.Tag as StudentWithDepartment;
if (astudent != null)
{
nameTextBox.Text = astudent.StudentName;
regNoTextBox.Text = astudent.RegNo;
phoneNoTextBox.Text = astudent.PhoneNo;
emailTextBox.Text = astudent.Email;
departmentComboBox.SelectedValue = astudent.DepartmentId;
hiddentIdLevel.Text = astudent.StudentId.ToString();
saveButton.Text = @"Update";
removeButton.Enabled = true;
}
}
public List <StudentWithDepartment> GetStudentWithDepartment()
{
connection.Open();
command = new SqlCommand("SELECT * FROM StudentWithDept", connection);
SqlDataReader myReader = command.ExecuteReader();
List <StudentWithDepartment> studentsList = new List <StudentWithDepartment>();
while (myReader.Read())
{
StudentWithDepartment studentWithDept = new StudentWithDepartment();
studentWithDept.StudentId = Convert.ToInt32(myReader["Student_Id"]);
studentWithDept.StudentName = myReader["StudentName"].ToString();
studentWithDept.RegNo = myReader["RegNo"].ToString();
studentWithDept.PhoneNo = myReader["PhoneNo"].ToString();
studentWithDept.Email = myReader["Email"].ToString();
studentWithDept.DepartmentId = Convert.ToInt32(myReader["DeptId"]);
studentWithDept.DepartCode = myReader["Code"].ToString();
studentWithDept.DepartmentName = myReader["DeptName"].ToString();
studentsList.Add(studentWithDept);
}
myReader.Close();
connection.Close();
return(studentsList);
}
