hi,
I wrote some code for generating online exam in asp.net.
my database table contains following columns
QuestionTab is table name
columns are qid,qname,opt1,opt2,opt3,opt4,ans
And after that my design page is like below
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script language ="javascript" >
var tim;
var min = 20;
var sec = 60;
var f = new Date();
function f1() {
f2();
document.getElementById("starttime").innerHTML = "Your started your Exam at " + f.getHours() + ":" + f.getMinutes();
document.getElementById("endtime").innerHTML = "Your time is :"+f.toLocaleTimeString();
}
function f2() {
if (parseInt(sec) > 0) {
sec = parseInt(sec) - 1;
document.getElementById("showtime").innerHTML = "Your Left Time is :"+min+" Minutes ," + sec+" Seconds";
tim = setTimeout("f2()", 100);
}
else {
if (parseInt(sec) == 0) {
min = parseInt(min) - 1;
if (parseInt(min) == 0) {
clearTimeout(tim);
location.href = "default5.aspx";
}
else {
sec = 60;
document.getElementById("showtime").innerHTML = "Your Left Time is :" + min + " Minutes ," + sec + " Seconds";
tim = setTimeout("f2()", 100);
}
}
}
}
</script>
</head>
<body onload="f1()">
<form id="form1" runat="server">
<div>
<table width="100%" align="center">
<tr>
<td colspan="2">
<h2>This is head part for showing timer and all other details</h2>
</td>
</tr>
<tr>
<td>
<div id="starttime"></div><br />
<div id="endtime"></div><br />
<div id="showtime"></div>
</td>
</tr>
<tr>
<td>
<asp:datalist id="DataList1" runat="server" width="100%" xmlns:asp="#unknown">
onitemdatabound="DataList1_ItemDataBound">
<HeaderTemplate >
<table width="100%" align="center">
</HeaderTemplate>
<itemtemplate>
<tr>
<td>
<table width="100%" border="1" bordercolor="green" cellspacing="0" cellpadding="0">
<tr>
<td>
<asp:label id="Label1" runat="server" text="<%#Eval("qid") %>"></asp:label> <%#Eval("qname") %></td>
</tr>
<tr>
<td>
<asp:radiobuttonlist id="RadioButtonList1" runat="server">
</asp:radiobuttonlist>
</td>
</tr>
</table>
</td>
</tr>
</itemtemplate>
<footertemplate>
</footertemplate></table>
</asp:datalist>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
And then my code behind file contains following code.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MylocalDataClassesDataContext db = new MylocalDataClassesDataContext();
var f = from d in db.QuestionTabs
select d;
DataList1.DataSource = f;
DataList1.DataBind();
}
}
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
RadioButtonList rdblist = (RadioButtonList)e.Item.FindControl("RadioButtonList1");
Label lblqid = (Label)e.Item.FindControl("Label1");
string qid = lblqid.Text;
MylocalDataClassesDataContext db = new MylocalDataClassesDataContext();
var f = from d in db.QuestionTabs
where d.qid ==int.Parse (qid)
select d;
foreach (QuestionTab qt in f)
{
rdblist.Items.Add(new ListItem(qt.opt1, qt.opt1));
rdblist.Items.Add(new ListItem(qt.opt2, qt.opt2));
rdblist.Items.Add(new ListItem(qt.opt3, qt.opt3));
rdblist.Items.Add(new ListItem(qt.opt4, qt.opt4));
}
}
}
Try this code .Here I used linq for retrieving data instead of this you can use normal process for retrieving data from database
All the Best