hi,
for my coursework im using asp.net/
vb.net. i am also using an oledbconnection. my problem is i need to generate 5 random records from a database when a start button is clicked, and display them on a page. each record must be different from the others. i think i need to use a loop but im not good enough in programming to kno how to do it. can anyone please help me out???? my code so far is displayed below which generates 1 records and displays it. but i need to to gerenate 5 different ones.
Sub Page_Load
if Session("userValid") = "Yes" then
Else
Response.redirect("Login.aspx")
End IF
Msg.Text =context.Session("Name")
Msg1.Text ="Please ensure you have read the instructions first!! and add all the other rules."
End Sub
Sub Log_Click(Src As Object, E As EventArgs)
Session.Abandon()
End Sub
Sub S_Click (Src As Object, E As EventArgs)
Dim i as integer
Randomize
i = CInt(Int((10 * Rnd()) + 1))
Dim strConnection as String = "Provider=Microsoft.Jet.OLEDB.4.0;"
strConnection += "Data Source=C:*****"
Dim objConnection as New OledbConnection(strConnection)
Dim strSQL as string
objConnection.Open()
strSQL = "SELECT * FROM T1 WHERE QuestionNo = "& i &""
Dim objCOmmand as New OledbCommand(strSQL, objConnection)
objCommand = New OleDbCommand(strSQL, objConnection)
objCommand.ExecuteNonQuery()
objConnection.Close()
Dim objDataReader as OledbDataReader
objConnection.Open()
objDataReader = objCommand.ExecuteReader()
objDataReader.Read()
message.text = objDataReader("QuestionNo")
message1.text = objDataReader("Question")
message2.text = objDataReader("Answer1")
message3.text = objDataReader("Answer2")
message4.text = objDataReader("Answer3")
message5.text = objDataReader("Answer4")
objConnection.Close()
end sub
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<center><asp:Label id="Msg1" runat="server"></asp:Label>
</center>
<br />
<br />
<table id="Table1" width="500" align="center" border="1">
<tbody>
<tr>
<td>
Que: <asp:Label id="Message" runat="server"></asp:Label></td>
</tr>
<tr>
<td>
<asp:Label id="Message1" runat="server"></asp:Label></td>
</tr>
<tr>
<td>
<asp:Label id="Message2" runat="server"></asp:Label>
<br />
<asp:Label id="Message3" runat="server"></asp:Label>
<br />
<asp:Label id="Message4" runat="server"></asp:Label>
<br />
<asp:Label id="Message5" runat="server"></asp:Label>
<br />
</td>
</tr>
</tbody>
</table>
<br />
<br />
<table id="Table1" width="500" align="center" border="1">
<tbody>
<tr>
<td>
Que: </td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
<br />
</td>
</tr>
</tbody>
</table>
<br />
<br />
<table id="Table1" width="500" align="center" border="1">
<tbody>
<tr>
<td>
Que: </td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
<br />
</td>
</tr>
</tbody>
</table>
<br />
<br />
<table id="Table1" width="500" align="center" border="1">
<tbody>
<tr>
<td>
Que: </td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
<br />
</td>
</tr>
</tbody>
</table>
<br />
<table id="Table1" width="500" align="center" border="1">
<tbody>
<tr>
<td>
Que: </td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
</td>
</tr>
</tbody>
</table>
<p>
<asp:button id="btnLogin" onclick="Log_Click" runat="Server" Text="Logout"></asp:button>
</p>
<br />
<asp:button id="Start" onclick="S_Click" runat="Server" Text="Start" </asp:button>
</p>
</form>
</body>
</html>
ongoing problem with random records....HELP!
