public void fetchStudents()
{
string qry = "Select * from Student";
SqlCommand cmd = new SqlCommand();
cmd.Connection = SMS.connect;
cmd.CommandText = qry;
SMS.connect.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
RegisteredStudentData student = new RegisteredStudentData();
student.Student_ID1 = (string)reader["Student_ID"];
student.Name1 = (string)reader["Name"];
student.St_Father_Name1 = (string)reader["St_Father_Name"];
student.Class_ID1 = (string)reader["Class_ID"];
//student.Reg_ID1 = (string)reader["Reg_ID"];
studentsList.Add(student);
}
SMS.connect.Close();
}
public void fetchStudentInfo()
{
string qry = "Select DISTINCT * from Student where Student_ID = '" + cnic + "'";
SqlCommand cmd = new SqlCommand();
cmd.Connection = SMS.connect;
cmd.CommandText = qry;
SMS.connect.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
RegisteredStudentData student = new RegisteredStudentData();
student.Name1 = (string)reader["Name"];
lblStudentName.Text = student.Name1;
student.Class_ID1 = (string)reader["Class_ID"];
lblEnrolledIn.Text = student.Class_ID1;
lblStudentEmail.Text = cnic;
}
SMS.connect.Close();
}
private void cbSelectedStudent_SelectedIndexChanged(object sender, EventArgs e)
{
int index = cbSelectedStudent.SelectedIndex;
RegisteredStudentData student = students.ElementAt(index);
string courseId = student.Class_ID1;
fetchCourses_(courseId);
}
public void fetchStudentInfo()
{
string qry = "Select DISTINCT * from Teacher_ ";
SqlCommand cmd = new SqlCommand();
cmd.Connection = SMS.connect;
cmd.CommandText = qry;
SMS.connect.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
RegisteredStudentData student = new RegisteredStudentData();
student.Name1 = (string)reader["Name"];
student.Class_ID1 = (string)reader["Class_ID"];
students.Add(student);
}
SMS.connect.Close();
}
