使用ASP将值插入Access数据库 [英] inserting values into access database using asp
本文介绍了使用ASP将值插入Access数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
任何人都可以建议我使用asp ...将数据插入到访问数据库中的代码....
Can anyone please suggest me the code for inserting data into access database usin asp....
推荐答案
确定..幸运的是，我碰巧是其中之一仍然觉得ASP非常酷的人..大声笑..但我认为您应该准备尽快迁移到ASP.NET.
好的，这里是您想要的示例代码..
ok..Fortunately I happen to be one of the very people who still find ASP pretty cool..lol..but I think you should get ready to move to ASP.NET soon
ok here''s sample code for what you want..
<%@LANGUAGE="JavaScript"%>
var strConnect="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="
strConnect += Server.MapPath("\\GOP") + "\\datastores\\gop.mdb;"
<!-- METADATA TYPE="typelib"
FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->
<HTML>
<HEAD>
<TITLE>Adding data into a database List</TITLE>
</HEAD>
<BODY LINK="red" VLINK="red" ALINK="crimson">
<%
var sql = insert into ([field names]) values ([data to be inserted]);
var objConn=Server.CreateObject("ADODB.Connection");
objConn.Open(strConnect)
objConn.Execute(sql)
objConn.Close()
objConn = null;
Response.Write("The data has been added to the database.")
%>
这篇关于使用ASP将值插入Access数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
