protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Page.User.Identity.IsAuthenticated)
{
DataSet ds = dbws.selectQuestions();
// gvChoices.DataSource = ds;
// gvChoices.DataBind();
DataSet dsSubjects = dbws.selectAllSubjects();
SubjectDropDownList.DataSource = dsSubjects;
SubjectDropDownList.DataTextField = "SubjectName";
SubjectDropDownList.DataValueField = "SubjectID";
SubjectDropDownList.DataBind();
DataSet dsQuestions = dbws.selectAllQuestions();
allQuestionsDropDownList.DataSource = dsQuestions;
allQuestionsDropDownList.DataTextField = "QuestionText";
allQuestionsDropDownList.DataValueField = "QuestionID";
allQuestionsDropDownList.DataBind();
}
else
{
Response.Redirect("LoginPage.aspx");
}
}
}
public void PopulateSubjects()
{
string uid = Session["uid"].ToString();
cmd = new SqlCommand("select subject from subjects join teaches on subjects.subid=teaches.subid where uid=@uid", con);
cmd.Parameters.AddWithValue("@uid", uid);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
SubjectDropDownList.DataSource = ds;
SubjectDropDownList.DataValueField = "subject";
SubjectDropDownList.DataBind();
}