コード例 #1
0
ファイル: MyCenter.aspx.cs プロジェクト: nineyat/Edu_Online
        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();
        }