Asp连接数据方法

来源:互联网 发布:游侠客 知乎 编辑:程序博客网 时间:2024/05/19 20:42

<%@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>
 

原创粉丝点击