繁體中文当前位置: 首页 > 图文教程 > 网络编程 > ASP > 如何从数据库得到一个列表表单
- ASP
- 用ASP做一个分页程序
- 用ASP实现网站的“目录树”管理
- 网页在线人数统计的做法
- 用ASP生成Chart
- 用ASP构建你的网站新闻发布（一）
- 用ASP构建你的网站新闻发布（三）
- 如何处理ASP中的图象
- 用ASP编写计数器
- ASP防盗链及防下载的方法
- ASP数据类型
- ASP组件中的安全问题
- ASP漏洞集-ASP漏洞分析和解决方法
- ASP漏洞集-Carello Web 使 ASP 源码暴露(APP,缺陷)
- ASP漏洞集-MS IIS server的ASP安全缺陷(MS,缺陷)
- ASP漏洞集-MS IIS虚拟主机ASP源码泄露(MS,缺陷)
- ASP漏洞集-给你的FileSystemObject对象加把锁
- ASP漏洞集-通过asp入侵web server,窃取文件毁坏系统
- ASP漏洞集-MS IIS server/Frontpage Ext Server
- ASP漏洞集-虚拟web目录容易泄露ASP源代码 (MS,缺陷)
- ASP漏洞集-用ASP实现网页保密的两种方法
ASP 中的 如何从数据库得到一个列表表单
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-11-03 浏览: 127 ::
收藏到网摘: n/a
<TITLE>ASPHole - Fill List Box Example</TITLE>
</HEAD>
<BODY>
<FORM METHOD=POST>
Country: <SELECT NAME="Country">
<%
' Construct path to database
sPath = Request.ServerVariables("Path_Translated")
sPath = Left(sPath,InStrRev(sPath,"\")) & "Countries.mdb"
'
' Open Connection & Recordset
set oSample = Server.CreateObject("ADODB.Connection")
oSample.Open _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Persist Security Info=TRUE;" & _
"Data Source=" & sPath, "Admin", ""
'
' Check for default...
mCountry = Trim(Request("Country"))
'
' Create the List
Set oRS=oSample.Execute _
("SELECT ID,COUNTRY " & _
"FROM COUNTRIES " & _
"ORDER BY ID")
DO WHILE NOT oRS.EOF
mSelected = ""
IF mCountry=trim(oRS("Country")) then mSelected=" SELECTED"
%>
<OPTION<%=mSelected%>><%=oRS("Country")%></OPTION>
<%
oRS.MoveNext
Loop
%>
</SELECT><BR>
<INPUT TYPE=SUBMIT>
</FORM>
</BODY>
</HTML>
Key points of the sample:
sPath is used to construct the path to the database based on the home directory of the script. This means
that the database must be in the same directory as the script., otherwise, set sPath to the absolute path
of the database.
The database is assumed to a be an Access 2000 Database with a table Countries with a character field
Country.
Forms are assumed to point at the same script which created it unless action is specified.
The IF mCountry=... statement is used to insert the word SELECTED into the OPTION containing the previous
country value, should one have been passed in by a submit.
If you have problems running this script, your database drivers may be out of date. Go to
http://www.microsoft.com/data for the current MDAC RTM.
-END-
评论 (0) All
