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