想从Name表中执行下面的SQL语句:"select * from Name"
dim rs
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Name"
dim rs
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Name"
调试欢乐多
set conn=server.CreateObject("adodb.connection")
conn.Open db
sqlstr="select * from name"
set rs=server.createobject("adodb.recordset")
rs.open sqlstr,conn
var constr = "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\Inetpub\\wwwroot\\jxjzd\\dbDutyArrange.mdb"
conn.Open(constr);
var rs = conn.Execute("select * from Name");
//-----------------
//todo:读取内容并显示
//ex:
// document.write(rs("字段名").value;);
//-----------------
rs.Close();
conn.Close();读出来的当然是数据库的内容.
var conn = new ActiveXObject("ADODB.Connection");
var constr = "Driver={Microsoft Access Driver (*.mdb)};DBQ=d:\\cbegraph.mdb"
conn.Open(constr);
var rs = conn.Execute("select * from gnumber");
//-----------------
//todo:读取内容并显示
//ex:
for(1==1;rs.eof == false;)
{
document.write(rs("id").value);
document.write("<br>")
rs.movenext;
}
//-----------------
rs.Close();
conn.Close();
</Script>
var xDOM6= new ActiveXObject("MSXML.DOMDocument");
var sSQL
sSQL="select *from njtgl";
sConn= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\bs.mdb";
rsXML.Open(sSQL, sConn1);
连接access型数据库
dbcn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\data.mdb");
var rs=new ActiveXObject("ADODB.Recordset");
rs.Open("Select * from mytable",dbcn,3);