Пример #1
0
        protected void BindInfo()
        {
            string teachName = Session["userName"].ToString();
            string sql       = "select * from PracticeInfo inner join VideoInfo on PracticeInfo.videoId = VideoInfo.VideoId inner join CourseInfo on CourseInfo.courseId = VideoInfo.CourseId where CourseInfo.teacher = " + "'" + teachName + "'";

            WorkList.DataSource   = DataOperate.GetDataset(sql, "PracticeInfo");
            WorkList.DataKeyNames = new string[] { "practiceId" };
            WorkList.DataBind();
        }