dbtools.asp
来自「办公自动化系统 适用于办公室的各种几本功能的操作 功能比较简单」· ASP 代码 · 共 70 行
ASP
70 行
<%
'Select Data From Tables
sub Options(InputName, TableName, Field, Selected)
dim Rstmp
dim str,myselected
if selected="" then
myselected=0
else
myselected=selected
end if
response.write "<select name="& InputName &" >"
response.write "<option value=0>请选择..."
set Rstmp=server.createobject("adodb.recordset")
str = "select * from "& TableName &" order by id"
Rstmp.open str, Conn, 1, 1
while not Rstmp.eof
if cint(Rstmp("id"))= cint(myselected) then
response.write "<option value="&Rstmp("id")&" selected>"&server.htmlencode(trim(Rstmp(field)))
else
response.write "<option value="&Rstmp("id")&">"&server.htmlencode(trim(Rstmp(field)))
end if
Rstmp.MoveNext
wend
Rstmp.close
set Rstmp=nothing
response.write "</select>"
end sub
sub Options1(InputName, TableName, Field, Selected)
dim Rstmp
dim str,myselected
if selected="" then
myselected=0
else
myselected=selected
end if
response.write "<select name="& InputName &" onchange='document.DocForm.submit();'>"
response.write "<option value=0>请选择..."
set Rstmp=server.createobject("adodb.recordset")
str = "select * from "& TableName &" order by id"
Rstmp.open str, Conn, 1, 1
while not Rstmp.eof
if cint(Rstmp("id"))= cint(myselected) then
response.write "<option value="&Rstmp("ID")&" selected>"&server.htmlencode(trim(Rstmp(field)))
else
response.write "<option value="&Rstmp("ID")&">"&server.htmlencode(trim(Rstmp(field)))
end if
Rstmp.MoveNext
wend
Rstmp.close
set Rstmp=nothing
response.write "</select>"
end sub
function GetTableValue(TableName, ValueField, ID)
ID=trim(ID)
dim Rs
set Rs=server.createobject("adodb.recordset")
Rs.open "select "&ValueField&" from "& TableName &" where id="& ID, Conn, 1, 1
if not Rs.eof then
GetTableValue = trim(Rs(ValueField))
else
GetTableValue = ""
end if
Rs.close
set Rs=nothing
end function
%>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?