public List <ViewCourseFromStudentDepartmentName> GetAllCourseFromStudentDepartmentNames(int studentId) { List <ViewCourseFromStudentDepartmentName> viewCourseFromStudentDepartment = new List <ViewCourseFromStudentDepartmentName>(); Query = "SELECT * FROM ViewCourseFromStudentDepartmentMenu where StudentId='" + studentId + "'"; Command.CommandText = Query; Connection.Open(); Reader = Command.ExecuteReader(); while (Reader.Read()) { ViewCourseFromStudentDepartmentName aViewStudentDepartmentName = new ViewCourseFromStudentDepartmentName(); aViewStudentDepartmentName.CourseId = Convert.ToInt32(Reader["CourseId"]); aViewStudentDepartmentName.CourseName = Reader["CourseName"].ToString(); aViewStudentDepartmentName.DepartmentId = Convert.ToInt32(Reader["DepartmentId"]); aViewStudentDepartmentName.StudentId = Convert.ToInt32(Reader["StudentId"]); aViewStudentDepartmentName.StudentDepartmentId = Convert.ToInt32(Reader["StudentDepartmentId"]); viewCourseFromStudentDepartment.Add(aViewStudentDepartmentName); } Reader.Close(); Connection.Close(); return(viewCourseFromStudentDepartment); }
public List <ViewCourseFromStudentDepartmentName> GetAllCourseFromStudentDepartmentNames(int studentId) { SqlConnection connection = new SqlConnection(connectionString); List <ViewCourseFromStudentDepartmentName> viewCourseFromStudentDepartment = new List <ViewCourseFromStudentDepartmentName>(); string Query = "SELECT * FROM ViewCourseFromStudentDepartmentName where StudentId='" + studentId + "'"; SqlCommand Command = new SqlCommand(Query, connection); connection.Open(); SqlDataReader Reader = Command.ExecuteReader(); while (Reader.Read()) { ViewCourseFromStudentDepartmentName aViewStudentDepartmentName = new ViewCourseFromStudentDepartmentName(); aViewStudentDepartmentName.CourseId = Convert.ToInt32(Reader["CourseId"]); aViewStudentDepartmentName.CourseName = Reader["CourseName"].ToString(); aViewStudentDepartmentName.DepartmentId = Convert.ToInt32(Reader["DepartmentId"]); aViewStudentDepartmentName.StudentId = Convert.ToInt32(Reader["StudentId"]); viewCourseFromStudentDepartment.Add(aViewStudentDepartmentName); } Reader.Close(); connection.Close(); return(viewCourseFromStudentDepartment); }