void testReply() { DataTable dtTest = con.GetDataTable("select t.userID,t.testID,ur.userReplyID,ur.questionID,ur.trueReplyID,tr.trueReplyName from test t inner join userReply ur on t.testID = ur.testID inner join trueReply tr on ur.trueReplyID = tr.trueReplyID where t.testID =" + testID + " "); dataTrueReply.DataSource = dtTest; dataTrueReply.DataBind(); }
protected void lesson() { DataTable lesson = con.GetDataTable("select * from lesson order by lessonName"); drpLesson.DataSource = lesson; drpLesson.DataTextField = "lessonName"; drpLesson.DataValueField = "lessonID"; drpLesson.DataBind(); }
void test() { DataTable dtTest = con.GetDataTable("select t.testID,u.userID,u.userName from test t inner join [user] u on t.userID=u.userID where u.userID=" + Session["userID"]); dataTest.DataSource = dtTest; dataTest.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["userID"] == null) { Response.Redirect("~/Account/Login.aspx"); } DataTable dtstudentInfo = con.GetDataTable("select u.userID,ui.Name,ui.Surname,ui.Phone from userGroup ug inner join [user] u on ug.userGroupID=u.userGroupID inner join userInfo ui on u.userID=ui.userID where ug.userGroupID=3"); dtStudent.DataSource = dtstudentInfo; dtStudent.DataBind(); }