<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<%var MM = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\\test.mdb"%>
<%
var rs = Server.CreateObject("ADODB.Recordset");
rs.ActiveConnection = MM;
rs.Source = "SELECT * FROM test01";
rs.CursorType = 0;
rs.CursorLocation = 2;
rs.LockType = 1;
rs.Open();
if(!rs.EOF){
for (x in rs.Fields)
{
Response.write(x.Name);
Response.write(x.Value);
rs.MoveNext;
}
}
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head> <body>
</body>
</html>
<%
rs.Close();
%>
<%var MM = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\\test.mdb"%>
<%
var rs = Server.CreateObject("ADODB.Recordset");
rs.ActiveConnection = MM;
rs.Source = "SELECT * FROM test01";
rs.CursorType = 0;
rs.CursorLocation = 2;
rs.LockType = 1;
rs.Open();
if(!rs.EOF){
for (x in rs.Fields)
{
Response.write(x.Name);
Response.write(x.Value);
rs.MoveNext;
}
}
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head> <body>
</body>
</html>
<%
rs.Close();
%>
