<%@ import namespace="system.data" %>
<%@ Page Language="vb" Debug="true" %>
<%@ import namespace="system.data.oledb" %>
<script language="VB" runat=server>
dim cmd as oledbcommand
dim dr as oleDbDataReader
dim sql as string
dim selLesson as string
sub page_load(s as object,e as eventargs)
selLesson=request.querystring("selLesson")
dim title as string,i as integer
dim conn as oledbconnection
conn=new oledbconnection(configurationsettings.appsettings("strconn"))
conn.open()
sql="select * from asp" & selLesson & " order by 题号"
cmd=new oledbcommand(sql,conn)
dr=cmd.executereader()
while dr.read()
dim literal1 as new literalcontrol
dim literal2 as new literalcontrol
dim rlist
if dr.item("类型")="选择"then
rlist=new radiobuttonlist
else
rlist=new checkboxlist
end if
literal1.text="<b>" & dr.item("题号") & "."
literal1.text & =server.htmlencode(dr.item("题目"))
literal1.text & ="(" & dr.item("类型")& ":"
literal1.text & =dr.item("分数") & "分)</b><blockquote>"
literal2.text ="</blockquote>"
for i=1 to 4
rlist.items.add(server.htmlencode(Dr.item("选项"&i)))
rlist.items(i-1).value=i
next
mypanel.controls.add(literal1)
mypanel.controls.add(rlist)
myPanel.controls.add(literal2)
end while
dr.close()
conn.close()
end subsub score_click(sender as object, e as eventargs)
sellesson=request.querystring("sellesson")
dim conn as oledbconnection
conn=new oledbconnection(configurationsettings.appsettings("strconn"))
conn.open()
sql="select * from [asp]" & selLesson & "order by 题号"
cmd=new oledbcommand(sql,conn)
dr=cmd.executereader()
dim i,k,getscore as integer,answer as string
while dr.read()
answer=""
i=dr.item("题号")
dim list as listcontrol=mypanel.controls(1+3*(i-1))
if dr.item("类型")="选择" then
if not list.selecteditem is nothing then
answer=list.selecteditem.value
end if
else
for k=0 to list.items.count - 1
if list.items(k).selected then
if answer="" then
answer=list.items(k).value
else
answer &="," & list.items(k).value
end if
end if
next
end if
if answer=dr.item("解答") then getscore += dr.item("分数")
end while
dr.close()
sql="update 成绩 set " & sellesson & "=" & getscore.tostring() & "where 学号=" & "'" & request("noid") & ""
cmd=new oledbcommand(sql,conn)
cmd.executenonquery()
conn.close()
response.redirect("score.aspx?学号=" & request("noid"))
end sub
</script>
<html>
<head><title>网上考试</title></head>
<body bgcolor="#eeccff">
<form runat="server">
<center><cont size="6"><%=request("sellesson2")%>ASP试题</font></center><hr color="blue">
<blockquote>
<asp:panel runat="server" id ="mypanel"/>
</blockquote>
<asp:linkbutton runat="server" text="交卷" onclick="score_click"/>
</blockquote>
</form>
</body>
</html>
<%@ Page Language="vb" Debug="true" %>
<%@ import namespace="system.data.oledb" %>
<script language="VB" runat=server>
dim cmd as oledbcommand
dim dr as oleDbDataReader
dim sql as string
dim selLesson as string
sub page_load(s as object,e as eventargs)
selLesson=request.querystring("selLesson")
dim title as string,i as integer
dim conn as oledbconnection
conn=new oledbconnection(configurationsettings.appsettings("strconn"))
conn.open()
sql="select * from asp" & selLesson & " order by 题号"
cmd=new oledbcommand(sql,conn)
dr=cmd.executereader()
while dr.read()
dim literal1 as new literalcontrol
dim literal2 as new literalcontrol
dim rlist
if dr.item("类型")="选择"then
rlist=new radiobuttonlist
else
rlist=new checkboxlist
end if
literal1.text="<b>" & dr.item("题号") & "."
literal1.text & =server.htmlencode(dr.item("题目"))
literal1.text & ="(" & dr.item("类型")& ":"
literal1.text & =dr.item("分数") & "分)</b><blockquote>"
literal2.text ="</blockquote>"
for i=1 to 4
rlist.items.add(server.htmlencode(Dr.item("选项"&i)))
rlist.items(i-1).value=i
next
mypanel.controls.add(literal1)
mypanel.controls.add(rlist)
myPanel.controls.add(literal2)
end while
dr.close()
conn.close()
end subsub score_click(sender as object, e as eventargs)
sellesson=request.querystring("sellesson")
dim conn as oledbconnection
conn=new oledbconnection(configurationsettings.appsettings("strconn"))
conn.open()
sql="select * from [asp]" & selLesson & "order by 题号"
cmd=new oledbcommand(sql,conn)
dr=cmd.executereader()
dim i,k,getscore as integer,answer as string
while dr.read()
answer=""
i=dr.item("题号")
dim list as listcontrol=mypanel.controls(1+3*(i-1))
if dr.item("类型")="选择" then
if not list.selecteditem is nothing then
answer=list.selecteditem.value
end if
else
for k=0 to list.items.count - 1
if list.items(k).selected then
if answer="" then
answer=list.items(k).value
else
answer &="," & list.items(k).value
end if
end if
next
end if
if answer=dr.item("解答") then getscore += dr.item("分数")
end while
dr.close()
sql="update 成绩 set " & sellesson & "=" & getscore.tostring() & "where 学号=" & "'" & request("noid") & ""
cmd=new oledbcommand(sql,conn)
cmd.executenonquery()
conn.close()
response.redirect("score.aspx?学号=" & request("noid"))
end sub
</script>
<html>
<head><title>网上考试</title></head>
<body bgcolor="#eeccff">
<form runat="server">
<center><cont size="6"><%=request("sellesson2")%>ASP试题</font></center><hr color="blue">
<blockquote>
<asp:panel runat="server" id ="mypanel"/>
</blockquote>
<asp:linkbutton runat="server" text="交卷" onclick="score_click"/>
</blockquote>
</form>
</body>
</html>
解决方案 »
- linq中如何查询数据库里面的某个字段里面是否包含某个字符串
- 新浪微博接口 远程服务器返回错误:(401)未经授权。
- 紧急情况,开始散分了,请教高手们的指教做一个无人值守安装程序.
- 帮忙呀,请把这个分页存储过程改成Oracle的,现在是Sql Server的!!
- 新手问题,急!!!
- 我的.net调试时偶尔就出现这个毛病,挺奇怪的!!!希望大家出谋划策!
- 关于如何去掉 table 对象的自带格式?
- 一个小问题,忧闷!
- c#中如何读到客户端的IE临时文件夹的位置?我能往里面写东西吧?
- 请问高手“WEB安装项目”是如何使用的?
- asp.net byte[]转换为string,读取的问题。代码放上去了,大家帮忙解决一下!
- 芯片大哥,可否把,vb.net里面的连接贴出来
里是啥。