<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<%
'const connStr = "Provider=SQLOLEDB;server=.;database=odbcTempDB;uid=sa;pwd=" '1)SQL Server 连接数据
const connStr = "DSN=odbcTempDB;Database=odbcTempDB;UID=sa;PWD=;" ' 2)ODBC 连接数据
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
sql_test = "select * from tuserTemp"
Set rs_test = server.CreateObject("adodb.recordset")
rs_test.CursorLocation = 3
rs_test.Open sql_test, conn, 3, 3
%>
<body>
<form name="form1" method="post" action="">
Name :
<input type="text" name="textfield" value="<%=rs_test.fields("name").value%>">
</form>
</body>
</html>