public void fetchCourses(string courseId)
{
string qry = "Select * from Course where Course_ID ='" + courseId + "'";
SqlCommand cmd = new SqlCommand();
cmd.Connection = SMS.connect;
cmd.CommandText = qry;
if (SMS.connect != null && SMS.connect.State == ConnectionState.Closed)
{
SMS.connect.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CourseData course = new CourseData();
course.Course_ID1 = (string)reader["Course_ID"];
course.Name1 = (string)reader["Name"];
// course.Class_ID1 = (string)reader["Class_ID"];
courses.Add(course);
}
SMS.connect.Close();
}
public void loadCourses()
{
for (int i = 0; i < courses.Count; i++)
{
CourseData item = courses.ElementAt(i);
cbCourses.Items.Add(item.Course_ID1 + " " + item.Name1);
}
}
public void fetchCourses()
{
string qry = "Select * from Course where Course_ID IN(Select Course_ID from CourseClass where Class_ID = (SELECT Distinct Class_ID 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())
{
CourseData course = new CourseData();
course.Course_ID1 = (string)reader["Course_ID"];
course.Name1 = (string)reader["Name"];
// course.Class_ID1 = (string)reader["Class_ID"];
courses.Add(course);
}
SMS.connect.Close();
}
public void fetchCourses()
{
string qry = "Select * from Course";
SqlCommand cmd = new SqlCommand();
cmd.Connection = SMS.connect;
cmd.CommandText = qry;
SMS.connect.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CourseData course = new CourseData();
course.Course_ID1 = (string)reader["Course_ID"];
course.Name1 = (string)reader["Name"];
// course.Class_ID1 = (string)reader["Class_ID"];
courses.Add(course);
}
SMS.connect.Close();
}