繁體中文当前位置: 首页 > 图文教程 > 网络编程 > ASP > 如何从数据库得到一个列表表单
- ASP
- 一种比较方便的ASP分页程序
- 用一套论坛程序架设多个论坛
- ASP与ASP.NET在COOKIE方面的区别
- 较长数据无法在Asp页面中取出的三种解决方法
- 初试WAP之wml＋ASP查询
- 动态网站首页的静态生成方法
- 使用正则表达式实现模式图片新闻.ASP
- 让你的WAP网站有更好的兼容性
- WAP版的手机号码所在地查询
- asp模仿 Lotus Notes 的界面程序
- ORACLE920与ASP的连接问题的解决办法
- 利用SQLSERVER存储过程实现ASP用户身份验证
- 在ASP中自动创建多级文件夹的函数(使用FSO)
- 利用instr()函数防止SQL注入攻击
- 利用XSL和ASP实现XML文档在线编辑
- 表单对象textarea内容的格式控制（回车、换行、空格）
- 针对select写了一个通用的option输出函数
- ASP无组件BMP汉字生成类+汉字点阵库
- 时间、空间性能极优的asp无组件上传类
- 无组件生成BMP验证码
ASP 中的 如何从数据库得到一个列表表单
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-11-03 浏览: 247 ::
收藏到网摘: 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
