how to write code for next button in online examination and also for previous button

Question

1.00/5 (1 vote)

See more:

i have written the code but it is not working properly
when i click on next button it is showing me next record program works properly but whan I log out and log in directly shows me last record not from start..please reply

Question table colums are question_id,teacher_id,teacher_question,teacher_answer

//code is

namespace project_master
{
    public partial class acnj : System.Web.UI.Page
    {
              
        SqlCommand cmd = new SqlCommand();
        public static int i = 0;
          DataTable dt = new DataTable();
        DataRow drr;
        SqlConnection con = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=swatidb;Integrated Security=True;Pooling=False");
         public void Page_Load(object sender, EventArgs e)
        {
            con.Open();
            string s1 = "select student_id from Student where user_name='" + Session["sid"] + "'";
            SqlCommand cmd = new SqlCommand(s1, con);
            SqlDataReader dr;
            dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                Label4_stu_id.Text =dr[0].ToString();//for displaying student_id
                dr.Close();
            }
            SqlDataAdapter da = new SqlDataAdapter("select * from Question where question_id&amp;gt;=1 and question_id&amp;lt;=3", con);
            da.Fill(dt);
            drr = dt.Rows[i];
 
            Label2_tea_que.Text = "Write question below in Textbox  click next to get questoion";
           // i++;
        }
         public void next_Click(object sender, System.EventArgs e)
         {
             if (i == (dt.Rows.Count - 1))
             {
                 Response.Write("Last record !");
             }
             else
             {
                 i++;
             }

             Label3_que_id.Text = Convert.ToString(drr[0]);//this label for displaying question_id
             Label2_tea_que.Text = Convert.ToString(drr[2]); //this label for displaying Teacher question
          }
       }   
    }

Posted 19-Mar-14 18:43pm

swati gapat

Updated 22-Mar-14 7:47am

v5

Add a Solution

Comments

Richard MacCutchan 20-Mar-14 6:11am

it is not working properly

And what exactly does that mean?

swati gapat 22-Mar-14 7:42am

sir now i have updated question please reply...

Sergey Alexandrovich Kryukov 20-Mar-14 10:30am

"Code for button" is already written. What is your problem?
—SA

swati gapat 22-Mar-14 7:44am

when i click on next button it is showing me next record, program works properly but whan I log out and log in directly shows me last record not from start give me reply i also tried with declaring i variable as non-static

ZurdoDev 20-Mar-14 11:01am

When it loads, load the first question. What's the issue?

swati gapat 22-Mar-14 7:41am

when i click on next button it is showing me next record, program works properly but whan I log out and log in directly shows me last record not from start

ZurdoDev 22-Mar-14 8:47am

If the code is actually the way you have it posted it will always load question id 2.

swati gapat 22-Mar-14 10:02am

Label2.Text = Convert.ToString(dr[2]);// for displaying question_id
means the position of column in table please tell me solution....

ZurdoDev 22-Mar-14 11:12am

You're page_load has this, select * from Question where question_id>=1 and question_id<=3" which means you will always load question 2.

BillWoodruff 21-Mar-14 13:03pm

Perhaps it is related to the fact that you use a static integer variable "i" ? Try changing that to a public, non-static, variable. That's a guess !

swati gapat 22-Mar-14 7:40am

sir i have tried using non-static but not working because it shows me only first record not other. i have tried for public and variable please sir give me solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

kbrandwijk · Accepted Answer · 2014-03-22T09:03:00

Basically, there are two approaches to this problem, you can store the current question (currently the i variable as a session variable, e.g.

C#

Session["CurrentQuestion"]

, and when the user logs out, make sure to clean and abandon the session like this:

C#

Session.Clear();
Session.Abandon();

Otherwise, you can use the IsPostback property to reset the current question:

C#

public void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        i = 0;
    }

    ...
}

This will only reset the current question on the first visit to the page, not after navigating to the next or previous question