⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 xsxg.asp

📁 vbsql做的销售管理课程设计样本不完全仅为范例
💻 ASP
字号:
<!--#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="xsxgconf.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 + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -