display result

Question

hello all

i have little problem i am designing a online exam system using asp and c# with sql server backend approximately i have completed my all project but in last when user select a user it store in a table name as "uans" but not in correct format
i am giving the code please help me in this and suggest me how to calculate marks and display the result.

pls help me as soon as possible

at page load

protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            cn.Open();

            SqlDataAdapter da = new SqlDataAdapter("select * from ques", cn);

            DataSet ds = new DataSet();

            da.Fill(ds, "ques");

            ViewState["i"] = 0;

            ques.Text = ds.Tables[0].Rows[0]["ques"].ToString();

            ans1.Text = ds.Tables[0].Rows[1]["ans1"].ToString();

            ans2.Text = ds.Tables[0].Rows[2]["ans2"].ToString();

            ans3.Text = ds.Tables[0].Rows[3]["ans3"].ToString();

            ans4.Text = ds.Tables[0].Rows[4]["ans4"].ToString();

        }

at next question button click event result will display after last question

protected void Button1_Click(object sender, EventArgs e)

    {

        cn.Open();

        

        

       int i = Convert.ToInt32(ViewState["i"])+1;

            SqlDataAdapter da = new SqlDataAdapter("select * from ques", cn);

            da.Fill(ds, "ques");

            ViewState["i"] = (int)ViewState["i"]+1;

            if (ds != null && (int)ViewState["i"] < ds.Tables[0].Rows.Count)

            {

                

                ques.Text = ds.Tables[0].Rows[i]["ques"].ToString();

                ans1.Text = ds.Tables[0].Rows[i]["ans1"].ToString();

                ans2.Text = ds.Tables[0].Rows[i]["ans2"].ToString();

                ans3.Text = ds.Tables[0].Rows[i]["ans3"].ToString();

                ans4.Text = ds.Tables[0].Rows[i]["ans4"].ToString();

               

                

            }

            else

            {

                Response.Redirect("result.aspx");

                

            }

                SqlCommand cmd1 = new SqlCommand("insert uans values(@ans)", cn);

                if (ans1.Checked)

                {

                    cmd1.Parameters.Add("@ans", ans1.Text);

                    cmd1.ExecuteNonQuery();

                    if (ans2.Checked)

                    {

                        //SqlCommand cmd2 = new SqlCommand("insert uans values(@ans)", cn);

                        cmd1.Parameters.Add("@ans", ans2.Text);

                        cmd1.ExecuteNonQuery();

                        if (ans3.Checked)

                        {

                            // SqlCommand cmd3 = new SqlCommand("insert uans values(@ans)", cn);

                            cmd1.Parameters.Add("@ans", ans3.Text);

                            cmd1.ExecuteNonQuery();

                        }

                    }

                }

                else

                {

                    // SqlCommand cmd4 = new SqlCommand("insert uans values(@ans)", cn);

                    cmd1.Parameters.Add("@ans", ans4.Text);

                    cmd1.ExecuteNonQuery();

                }

            

database  is   

create database admins

use admins

create table ques

(

quesno int identity(1,1),

ques char(100),

ans1 char(50),

ans2 char(50),

ans3 char(50),

ans4 char(50),

rans char(50)

)

insert ques values('what is mouse','input device','output device','hard disk','printer','input device')

insert ques values('what is keybord','input device','output device','hard disk','printer','input device')

insert ques values('what is speaker','input device','output device','hard disk','printer','output device')

insert ques values('what is cpu','input device','processing unit','hard disk','printer','processing unit')

insert ques values('what is ram','input device',' temporay storage','hard disk','printer','temporay storage')

insert ques values('what is dam','input/p device',' dtemporay storage','dhard disk','dprinter','dtemporay storage')

insert ques values('what is qram','qinput device',' qtemporay storage','qhard disk','qprinter','qtemporay storage')

create table uans

(

ans char(30)

)