ASP.. Net c# -使用数据表

我希望这有意义。我熟悉使用datareader，但是我认为在这个实例中使用DataTable是有意义的。我有一个包含"问题"的数据库表，我想实现一个能够在网站上浏览问题的工具。

因此，简化来说，有一个标签用于输出问题(lblQuestion)，一个后退按钮和一个前进按钮用于转到上一个/下一个问题。

下面的代码/在会话对象中保存数据表是最有效的方法吗?

protected void Page_Load(object sender, EventArgs e)
{
    if (!(Page.IsPostBack))
    {
        getQuestions();
        int questionCounter = 1;
        ViewState["questionCounter"] = questionCounter;
        lblCounter.Text = questionCounter.ToString();
    }
}
protected void getQuestions()
{
    string connStr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
    MySqlConnection conn = new MySqlConnection(connStr);
    MySqlDataReader reader;
    string cmdText = "SELECT * FROM questions WHERE approved='Y' AND module_id=1";
    MySqlCommand cmd = new MySqlCommand(cmdText, conn);
    try
    {
        conn.Open();
        reader = cmd.ExecuteReader();
        DataTable dt1 = new DataTable();
        dt1.Load(reader);
        reader.Close();
        Session["dt1"] = dt1;
        lblQuestion.Text = dt1.Rows[0]["question"].ToString();
    }
    catch
    {
        lblError.Text = "Database connection error - failed to get questions.";
    }
    finally
    {
        conn.Close();
    }
}
protected void btnNext_Click(object sender, EventArgs e)
{
    int questionCounter = Convert.ToInt32(ViewState["questionCounter"]);
    DataTable dt1 = (DataTable)Session["dt1"];
    if (questionCounter < dt1.Rows.Count)
    {
        questionCounter++;
        lblQuestion.Text = dt1.Rows[questionCounter-1]["question"].ToString();
        ViewState["questionCounter"] = questionCounter;
        lblCounter.Text = questionCounter.ToString();
    }
    else
    {
        lblQuestion.Text = "the end of questions.";
    }
}
protected void btnBack_Click(object sender, EventArgs e)
{
    int questionCounter = Convert.ToInt32(ViewState["questionCounter"]);
    DataTable dt1 = (DataTable)Session["dt1"];
    if (questionCounter > 1)
    {
        questionCounter--;
        lblQuestion.Text = dt1.Rows[questionCounter-1]["question"].ToString();
        ViewState["questionCounter"] = questionCounter;
        lblCounter.Text = questionCounter.ToString();
    }
    else
    {
        lblQuestion.Text = "the beginning of questions.";
    }
}