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(); }