xssc.asp

来自「vbsql做的销售管理课程设计样本不完全仅为范例」· ASP 代码 · 共 57 行

ASP
57
字号
<!--#include file="../conn.inc" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body background="../img/bg-1.gif">
<h4>请选择要删除的销售记录</h4>
<form action="xsscconf.asp" method="get">
<br><br>产品编号:
<select name="cpbh">
<%
set rs1=Server.createobject("adodb.Recordset")
rs1.open "select CPBH from XSCP",conn,3
do%>
<option value="<%=TRIM(Server.HTMLEncode(rs1.Fields("CPBH").Value))%>">
<%=Server.HTMLEncode(rs1.Fields("CPBH").Value)%></option><br>
<%
rs1.MoveNext
LOOP UNTIL rs1.eof
rs1.close
conn.close
%></select>
<br><br>销售编号:
<select name="xsbh">
<%
conn.open
set rs2=Server.createobject("adodb.Recordset")
rs2.open "select XSBH from XSCP",conn,3
do%>
<option value="<%=TRIM(Server.HTMLEncode(rs2.Fields("XSBH").Value))%>">
<%=Server.HTMLEncode(rs2.Fields("XSBH").Value)%></option><br>
<%
rs2.MoveNext
LOOP UNTIL rs2.eof
rs2.close
conn.close
%></select>
<br><br>销售时间:
<select name="xssj">
<%
conn.open
set rs3=Server.createobject("adodb.Recordset")
rs3.open "select XSSJ from XSCP",conn,3
do%>
<option value="<%=TRIM(Server.HTMLEncode(rs3.Fields("XSSJ").Value))%>">
<%=Server.HTMLEncode(rs3.Fields("XSSJ").Value)%></option><br>
<%
rs3.MoveNext
LOOP UNTIL rs3.eof
rs3.close
conn.close
%></select><br><br>
<input type=submit value="下一步">
</form></body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?