protected void Practice_Todo() { string userId = Session["userId"].ToString(); string sql = "select * from PracticeInfo inner join SCInfo on PracticeInfo.courseId = SCInfo.CourseId inner join CourseInfo on CourseInfo.courseId = SCInfo.CourseId inner join VideoInfo on VideoInfo.VideoId = PracticeInfo.videoId where PracticeInfo.practiceId not in (select practiceId from AnswerResult where stuId = '" + userId + "') and SCInfo.StuId = '" + userId + "'"; TodoList.DataSource = DataOperate.GetDataset(sql, "PracticeInfo"); TodoList.DataKeyNames = new string[] { "practiceId" }; TodoList.DataBind(); }