ASP.NET

11-Aug-09 10:25

I want to create a quiz from my database as follows:
1 Diabetes is a disease that effects:
Babies
Children
Teenagers
Adults
Men
Women
All of the above

2 Increasing the amount of glucose (sugar) in blood effects:
Nothing
Heart
Nerves
Blood Vessels
2,3,4

3 Diabetes complications may include:
Stroke
Heart disease
Hypertension
Nerve problems
Gum infection
Kidney disease
Blindness
Amputation
All of the above
==================

Here is my code for the repeater control:
asp code:
<tr>
<td colspan="6" align="left" bgcolor="#eeeeee">
<asp:Repeater ID="rptrExample" runat="server">
<HeaderTemplate>
<%# DataBinder.Eval(Container, "DataItem.QID") %>
<%# DataBinder.Eval(Container, "DataItem.Question") %>
 
</HeaderTemplate>

<ItemTemplate>
<%# DataBinder.Eval(Container, "DataItem.Answer") %>
 
</ItemTemplate>
</asp:Repeater>
<asp:Label ID="lblStatus" runat="server"></asp:Label>
</td>
</tr>

aspx.cs code:
try
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
String stmt = "select Q.QID as QID, Q.Question as Question, A.Answer as Answer from Curriculum_Questions Q INNER JOIN Curriculum_Answers A on Q.QID = A.QID where ChapterID = 2";
cmd.CommandText = stmt;
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
rptrExample.DataSource = cmd.ExecuteReader();
rptrExample.DataBind();
con.Close();
con.Dispose();
}
catch (Exception ex)
{
lblStatus.Text = ex.Message;
}
}

But I am not getting the desired result. Instead it is just showing all the answer choices only. No QID, Question. Please help me to understand why?
Is it possible to show answer choices as radio buttons in using repeater control?

Thank You.

Abhijit Jana11-Aug-09 10:36

Abhijit Jana

11-Aug-09 10:36

deep76 wrote:
Is it possible to show answer choices as radio buttons in using repeater control?

ASP.NET Tip: Using RadioButton Controls in a Repeater[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

deep7611-Aug-09 10:47

11-Aug-09 10:47

Thanks, but can somebody answer the first part of my problem, only then I will be able to use the radio button tip.

Why is my HeaderTemplate not showing up? Confused | :confused:

<HeaderTemplate>
<%# DataBinder.Eval(Container, "DataItem.QID") %>
<%# DataBinder.Eval(Container, "DataItem.Question") %>
 
</HeaderTemplate>

Thank you.

Venkatesh Mookkan11-Aug-09 15:57

11-Aug-09 15:57

deep76 wrote:
Why is my HeaderTemplate not showing up?

Place a Label/Literal control inside the HeaderTemplate and bind the Header to it. May be it would work.

Castle Rider

What if I freeze??? Don't forget to breath...

My: Website | Yahoo Group | Blog Spot

deep7612-Aug-09 5:12

12-Aug-09 5:12

I did place a literal inside HeaderTemplate, it appears once but the DataItem does not. Also I was expecting to see literal 'Question:' at the begenning of each new set of answers. Here is how I get my result:
Question:
Babies
Children
Teenagers
Adults
Men
Women
All of the above
Nothing
Heart
Nerves
Blood Vessels
2,3,4
Stroke
Heart disease
Hypertension
Nerve problems
Gum infection
Kidney disease
Blindness
Amputation
All of the above

Here's is how I want to see:
Question:1 Diabetes is a disease that effects:
Babies
Children
Teenagers
Adults
Men
Women
All of the above

Question:2 Increasing the amount of glucose (sugar) in blood effects:
Nothing
Heart
Nerves
Blood Vessels
2,3,4

.........

Once I get that, I will then plan on adding either radio buttons to each answer, or use a dropdown list for the user to select correct answer.

Here's my current code for repeater control:
<tr>
<td colspan="6" align="left" bgcolor="#eeeeee">
<asp:Repeater ID="repeater1" runat="server">
<headertemplate>
Question: 
<%# DataBinder.Eval(Container, "DataItem.QID")%>
<%# DataBinder.Eval(Container, "DataItem.Question")%>
 
</headertemplate>
<ItemTemplate>
<%# DataBinder.Eval(Container, "DataItem.Answer") %>
 
</ItemTemplate>
</asp:Repeater>
<asp:Label ID="lblStatus" runat="server"></asp:Label>
</td>
</tr>

Venkatesh Mookkan12-Aug-09 5:23

12-Aug-09 5:23

deep76 wrote:
Question:1 Diabetes is a disease that effects:
Babies
Children
Teenagers
Adults
Men
Women
All of the above

Question:2 Increasing the amount of glucose (sugar) in blood effects:
Nothing
Heart
Nerves
Blood Vessels
2,3,4

I don't think one repeater would solve this. You can solve this using Nested Repeater like,

[Repeater1 ItemTemplate]

Question 1

[Repeater2 ItemTemplate]
Shows the choices of question 1
[/Repeater2 ItemTemplate]

[/Repeater1 ItemTemplate]

Bind all the questions to the master repeater and on the ItemDataBound/DataBound event of the master repeater, load the answer of each item in the child repeater. I have tried this using DataGrid and GridView. But this should be possible in Repeater too. Lemme know if you have any questions.

Please mark it as "Good Answer" if it is useful to you.

Castle Rider

What if I freeze??? Don't forget to breath...

My: Website | Yahoo Group | Blog Spot

deep7612-Aug-09 5:26

12-Aug-09 5:26

Quote"
Bind all the questions to the master repeater and on the ItemDataBound/DataBound event of the master repeater, load the answer of each item in the child repeater. I have tried this using DataGrid and GridView. But this should be possible in Repeater too. Lemme know if you have any questions.
"Unquote
Can you please point to some sample code to do that. I checked several examples of repeater control on the net, none of them show how to do that.

Thank you very much for your help.

Venkatesh Mookkan12-Aug-09 5:31

12-Aug-09 5:31

Hey Deep76,

I gave the solution from my personal experience. But I do found a classic example for you. Thanks you CodeProject.

Check this out A quick guide to using nested repeaters in ASP.NET[^]

Please mark it as "Good Answer" if it is helpful.

Castle Rider

What if I freeze??? Don't forget to breath...

My: Website | Yahoo Group | Blog Spot

deep7612-Aug-09 6:41

12-Aug-09 6:41

Thank You. That was helpful, but I am not there yet.
I modified my code to use nested repeater with database.
Now I get the following error where I create the relation between the questions and answers tables:

"System.ArgumentException: This constraint cannot be enabled as not all values have corresponding parent values.
Line 81: ds.Relations.Add("myrelation",
Line 82: ds.Tables["questions"].Columns["QID"],
Line 83: ds.Tables["answers"].Columns["QID"]);"

Here is my nested repeater code:
asp file:

<asp:repeater id="parentRepeater" runat="server">
<itemtemplate>
<%# DataBinder.Eval(Container.DataItem,"QID") %>: 
<%# DataBinder.Eval(Container.DataItem,"Question") %> 


<asp:repeater id="childRepeater" datasource='<%# ((DataRowView)Container.DataItem)
.Row.GetChildRows("myrelation") %>' runat="server">

<itemtemplate>
<%# DataBinder.Eval(Container.DataItem, "[\"Answer\"]")%> 
</itemtemplate>
</asp:repeater>


</itemtemplate>
</asp:repeater>

=========================================
axpx.cs file:

protected void CreateQuiz()
{
//Create the connection and DataAdapter for the questions table.
SqlConnection cnn = new SqlConnection(connectionString);
SqlDataAdapter cmd1 = new SqlDataAdapter("select QID, Question from Curriculum_Questions where ChapterID='2'",cnn);

//Create and fill the DataSet.
DataSet ds = new DataSet();
cmd1.Fill(ds,"questions");

//Create a second DataAdapter for the answers table.
SqlDataAdapter cmd2 = new SqlDataAdapter("select QID, Answer from Curriculum_Answers",cnn);
cmd2.Fill(ds,"answers");

//Create the relation bewtween the questions and answers tables.
ds.Relations.Add("myrelation",
ds.Tables["questions"].Columns["QID"],
ds.Tables["answers"].Columns["QID"]);

//Bind the questions table to the parent Repeater control, and call DataBind.
parentRepeater.DataSource = ds.Tables["questions"];
Page.DataBind();

//Close the connection.
cnn.Close();
}

Any clues?

Thanks.

Venkatesh Mookkan12-Aug-09 6:49

12-Aug-09 6:49

deep76 wrote:
"System.ArgumentException: This constraint cannot be enabled as not all values have corresponding parent values.
Line 81: ds.Relations.Add("myrelation",
Line 82: ds.Tables["questions"].Columns["QID"],
Line 83: ds.Tables["answers"].Columns["QID"]);"

This is because, you do not have a proper data in database/DataSet.

What are you trying to do?
You are literally setting up the Foreign Key relation in a DataSet.

How the data should?

Questions
QID Question
1 How are you?
2 Where are you?
3 Is my answer helpful?

Proper data
Answers
AID QID Answer
1 1 Fine
2 1 I am OK.

Invalid data
Answer
AID QID Answer
1 100 Fine
2 100 I am OK.

Make sure whatever QID you use, should available in Questions table.

I am feeling tried. I am going to bed. Will check the forum morning.

"Good luck"

Castle Rider

What if I freeze??? Don't forget to breath...

My: Website | Yahoo Group | Blog Spot

deep7612-Aug-09 6:54

12-Aug-09 6:54

My data seems to be fine.
Questions:
QID, Question
1 Diabetes is a disease that effects:
2 Increasing the amount of glucose (sugar) in blood effects:
3 Diabetes complications may include:

Answers:
QID, Answer
1 Babies
1 Children
1 Teenagers
1 Adults
1 Men
1 Women
1 All of the above
2 Nothing
2 Heart
2 Nerves
2 Blood Vessels
2 2,3,4
3 Stroke
3 Heart disease
3 Hypertension
3 Nerve problems
3 Gum infection
3 Kidney disease
3 Blindness
3 Amputation
3 All of the above

Sorry, I don't mean to keep you awake.
Thanks.

deep7612-Aug-09 7:03

12-Aug-09 7:03

THANK YOU SO MUCH! Big Grin | :-D

I found the error. I did not include chapter id constraint in my answers query, so it was fetching all the answers and therefore QIDs did not match. Now it works fine. Now I have to work on adding radio buttons / drop down list to the answers.

Venkatesh Mookkan12-Aug-09 7:10

12-Aug-09 7:10

Good to hear. I believe, you would not come with RadioButton issue while using it in Repeater.

Use RadioButton's GroupName property in that case. Give a group name from each set of answers.

"Good Luck"

Castle Rider

What if I freeze??? Don't forget to breath...

My: Website | Yahoo Group | Blog Spot

Venkatesh Mookkan12-Aug-09 7:07

12-Aug-09 7:07

Your code:

ds.Relations.Add("myrelation",
ds.Tables["questions"].Columns["QID"],
ds.Tables["answers"].Columns["QID"]);

Change to:

ds.Relations.Add("myrelation",
ds.Tables["questions"].Columns["QID"],
ds.Tables["answers"].Columns["QID"], false);

Castle Rider

What if I freeze??? Don't forget to breath...

My: Website | Yahoo Group | Blog Spot

deep7612-Aug-09 9:20

ASP.NET Configuration Problem

12-Aug-09 9:20

Abhijit Jana wrote:
eep76 wrote:
ASP.NET Tip: Using RadioButton Controls in a Repeater[^]

I tried the code from this link given by Abhijit Jana, but the code in the event handler childRepeater_ItemDataBound(object sender, RepeaterItemEventArgs e) is never reached. The radoi buttons are displayed but all are selectable.
My code copied below:
aspx:
<script type="text/javascript">
function SetUniqueRadioButton(nameregex, current)
{
re = new RegExp(nameregex);
for(i = 0; i < document.forms[0].elements.length; i++)
{
elm = document.forms[0].elements[i]
if (elm.type == 'radio')
{
if (re.test(elm.name))
{
elm.checked = false;
}
}
}
current.checked = true;
}
</script>


<asp:repeater id="parentRepeater" runat="server">
<itemtemplate>
 <%# DataBinder.Eval(Container.DataItem,"QID") %>: 
<%# DataBinder.Eval(Container.DataItem,"Question") %> 


<asp:repeater id="childRepeater" datasource='<%# ((DataRowView)Container.DataItem)
.Row.GetChildRows("myrelation") %>' runat="server">

<itemtemplate>
     
<asp:RadioButton ID="choices" runat="server" GroupName=<%# DataBinder.Eval(Container.DataItem, "[\"QID\"]")%> />
<%# DataBinder.Eval(Container.DataItem, "[\"Answer_Num\"]")%>. 
<%# DataBinder.Eval(Container.DataItem, "[\"Answer\"]")%> 
</asp:RadioButton>
</itemtemplate>
</asp:repeater>


</itemtemplate>
</asp:repeater>


aspx.cs

protected void childRepeater_ItemDataBound(object sender,
RepeaterItemEventArgs e)
{
if (e.Item.ItemType != ListItemType.Item && e.Item.ItemType
!= ListItemType.AlternatingItem)
return;
RadioButton rdo = (RadioButton)e.Item.FindControl("rdoSelected");
string script =
"SetUniqueRadioButton('childRepeater.*groupName',this)";
rdo.Attributes.Add("onclick", script);
}

protected void CreateQuiz()
{
//Create the connection and DataAdapter for the questions table.
SqlConnection cnn = new SqlConnection(connectionString);
SqlDataAdapter cmd1 = new SqlDataAdapter("select QID, Question from Curriculum_Questions where ChapterID='2'",cnn);

//Create and fill the DataSet.
DataSet ds = new DataSet();
cmd1.Fill(ds,"questions");

//Create a second DataAdapter for the answers table.
SqlDataAdapter cmd2 = new SqlDataAdapter("select QID, Answer_Num, Answer from Curriculum_Answers where ChapterID='2'", cnn);
cmd2.Fill(ds,"answers");

//Create the relation bewtween the questions and answers tables.
ds.Relations.Add("myrelation",
ds.Tables["questions"].Columns["QID"],
ds.Tables["answers"].Columns["QID"]);

//Bind the questions table to the parent Repeater control, and call DataBind.
parentRepeater.DataSource = ds.Tables["questions"];
Page.DataBind();

//Close the connection.
cnn.Close();
}

Thanks for your help.

pampam11011-Aug-09 10:19

pampam110

11-Aug-09 10:19

when i use asp.net configuration from website tab on Visual Studio 2005. i click on Security Tab i saw this message : "There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Unable to connect to SQL Server database. "

then i select "Choose Data Store" button and select a single provider , and after that Click on test text on page. again i saw an error : "Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider. "

AnyOne know? What should i do?

[]D @ []v[] []D @ []v[]

Abhijit Jana11-Aug-09 10:42

Abhijit Jana

11-Aug-09 10:42

pampam110 wrote:
then i select "Choose Data Store" button and select a single provider , and after that Click on test text on page. again i saw an error : "Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider. "

you have to run aspnet_regsql command from command prompt and chose the database from there for web site configuration.

From Command Prompt >Goto Framework directory > Run aspnet_regsql

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

pampam11012-Aug-09 22:21

pampam110

12-Aug-09 22:21

Thanks Abhijit Jana. I Run aspnet_regsql . . . and i use -? for help me! but i am confused!

I find out something. first of all i havent sql express and I can't setup sql express edition. what should i do?
i have Visual Studio 2005 beta version.
Any Ideas ?!

[]D @ []v[] []D @ []v[]

pampam11015-Aug-09 11:35

pampam110

15-Aug-09 11:35

Thanks AnyWay! my problem Solve!

[]D @ []v[] []D @ []v[]