quiz demo

Arunkumar Emm

15y19.2k.NET

Hi ,

Am currently working on online examination web project.. i have a table like this..

sno question answer1 answer2 answer3 answer4 correctanswer

1 sql structured simple short none structured

i just want to bind these 4 answers to my radiobuttonlist which is present inside the gridview.. am not able to do that so please help me ....

here is what i've tried ,

Aspx code :



                                                    Height="16px" Width="800px"
                            Font-Size="X-Small">


                                                    RepeatDirection="Horizontal" >





                                                Width="187px">





C# code :

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {

            myConnection.Open();
            cmd = new SqlCommand("select option1 , option2 , option3 , option4 from online where pn_BranchID = '" + employee.BranchId + "' and pn_questID='" + txt_qsetno.Text + "' ", myConnection);
            rea1 = cmd.ExecuteReader();
            if (rea1.Read())
            {

                RadioButtonList rbl_responses = (RadioButtonList)e.Row.Cells[1].FindControl("RadioButtonList6");


                if (e.Row.RowType == DataControlRowType.DataRow)
                {
                    rbl_responses.Items.Add(new ListItem(Convert.ToString(rea1["option1"])));
                    rbl_responses.Items.Add(new ListItem(Convert.ToString(rea1["option2"])));
                    rbl_responses.Items.Add(new ListItem(Convert.ToString(rea1["option3"])));
                    rbl_responses.Items.Add(new ListItem(Convert.ToString(rea1["option4"])));
                }

            rea1.Close();

            myConnection.Close();
        }

But its not working.. i dont know how to bind the 4 answers fields to the radiobuttonlist..

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Arunkumar Emm15y ago
R u talking about onrowdatabound?.. but i've written the coding in the "onrowdatabound" event only.. Anyway , send me the code i'll go through it. Thanks alt..
0
Arunkumar Emm15y ago

I'm glad tat u found the solution. i gotta finish this thing before 25/1/2011. Sending via mail wud be better. my id is [email protected]. Need to use OnRowBounding event huh.. Never thought of it..
0
George Onofrei15y ago
okay, got the thing working. It has a couple of bugs, but you need it right away. Do you want me to copy paste here or send you the project via mail or somehow?

edit: I finally understood what you were trying to do. I think I'll combine the 2 methods. When is your deadline?

edit 2: thought about it some more and indeed I'll combine the 2 methods. Now that \i understand what you wanted, indeed you need to use the OnRowBounding event
0
Arunkumar Emm15y ago
Ok thanks alt.. i'll be waitin..
0
George Onofrei15y ago
no problem. I'll send you that sample some day today. Also will keep in mind your logic in case some idea comes
0
Arunkumar Emm15y ago

Mmm. Think of a way. Pls Make it asap. Its also ok for me to follow ur logic (List) but send me an example so that i can start workin on it. For instance , lets take our scenario as an example and send me the code so that it wud be better for me to understand.. Sorry if i bug u much..
0
George Onofrei15y ago
I'd go for the List. of course you can call your class instead of T what ever else.
the if probably gave you the first results and the while gave you the last results in your example.

I'll think of a way, but I would go for the List logic as it seems to me to be a better way of binding and works every time whatever you use. I mean, if you want to bind some things in a checkbox list, I'd go for the same logic and not do ondatabind. It makes the code a bit cleaner I'd say. Please send me a feedback on how you're doing. Cheers!!! If it's not working, I'll send you an example.
0
Arunkumar Emm15y ago
I'm not gettin it right.. u r ryt , all the questions are getting the same answer even if i replace "if" with "while". Now the outcome becomes something lik this..

sno    questions
1        sql means?
   @ structured @ simple     @ short    @none @dbms   @cdbms   @rdbms @none

2. sql is an example 4?
@ structured @ simple     @ short    @none @dbms   @cdbms   @rdbms @none

So what do i do?.. Is there anyway to get my logic work? or i should revert back to ur logic i.e, making a List and then bind it..

0
Arunkumar Emm15y ago
Awh , thanks alt for ur solution. i'll try that n let u know..
0
George Onofrei15y ago
yes, i understand. The problem is in the code. Because the reader doesn't read all your values. Instead of if, you must put while to iterate through all you options. Now the question is, how to bind them, as if you iterate through all of them, I don't think it's going to work. But one step at a time

why while instead of if? the reader when is used with .Read() reads only one of the extracted values, so you need a while to iterate until there are nu more values.

now for the binding stuff. I think a better aproach is to make a List in which to store each of your questions and give the T the following:

public class T
{
     public string Answer1 {get; set;}
     public string Answer2 {get; set;}
     ...............
     public string RightAnswer {get; set;}
}

and then bind them

What I don't know is if your approach is the best way. I mean, every time I worked with gridviews, datagrids, listview etc, I'd do something like:

public partial class : Page
{
     public void Page_Load(object sender, EventArgs e)
     {
     List list = new List;
     list=GetList();
     GridView1.DataSource = list;
     GridView1.DataBind();
     }

     public List GetList()
     {
     List list = new List;
     //add all questions, answers and right answer
     }
}

and in the aspx page:



                        <%# Eval("Answer1") %>


                    .....................................................//each Answer




this is a solution which I think will work. Let's get back to your idea and what can be done. Well, I don't know, because if you replace the if with the while and do the adding, I guess all questions will get the same answer.

Before you try my idea, do a save as you don't want to lose data. And please give a feedback. Also, if any questions rise, please post. Good luck!!!
0
Arunkumar Emm15y ago
First of all , thanks for interest..
Yes , i'm reading all the questions and bind them into a gridview in a single page. in the gridview , there is no problem with the questions.it displays in the correct order. but my problem is with the answers. the same answer is repeating for all the questions. I'm populating the radiobuttonlist which contains the answer from the gridview_rowdatabound event. lets say i have a database like the following,

sno    question    answer1     answer2      answer3      answer4    correctanswer
1        sql means? structured       simple          short        none           structured
2        sql is an example 4?   dbms                 cdbms            rdbms          none           rdbms

The grid view that i'm getting will look like ,
sno        questions
1          sql means?
@ structured    @ simple @ short @none

2. sql is an example 4?
   @ structured    @ simple @ short @none

see , the options are same for question 1 and 2. Hope u understood what i'm trying to say..

0
George Onofrei15y ago
Can you detail a bit?

Are you reading all the questions and then bind them in gridview or are you accessing them based on a sort of a "Next" button. I mean, are you reading all the values, or just one and then the next after an event?
0
Arunkumar Emm15y ago
No. Not working..

The same answers are repeating for all the questions.. I think there is something to do with sno in the query.. but i dont know how to do it.

cmd = new SqlCommand("select option1 , option2 , option3 , option4 from online where pn_BranchID = '" + employee.BranchId + "' and pn_questID='" + txt_qsetno.Text + "' and sno=??? ", myConnection);
0
George Onofrei15y ago
try this:

rbl_responses.Items.Add(new ListItem(rea1.GetString(rea1.GetOrdinal("option1"))));
0