jsÈçºÎÏòaccessÊý¾Ý¿âÖÐд¼Ç¼
ÏÂÃæÊÇÒ»¶ÎjsÁ¬½ÓaccessÊý¾Ý¿âµÄ´úÂ룺
<script language="javascript" runat="server">
var conn=new ActiveXObject("Adodb.Connection");
var rs=new ActiveXObject("Adodb.Recordset");
conn.ConnectionString="provider=Microsoft.Jet.OLEDB.4.0;data source="+Server.MapPath("8888.mdb");
conn.Open();
rs.LockType=rs.CursorType=3;
rs.ActiveConnection=conn;
rs.Source="select * from huiyuan where ka='114'";
rs.Open();
rs("login")=1
rs.update();
rs.close
set rs=nothing
Response.Write(rs("sfz")+" <br>");
</script>
À¶É«µÄËľäÊÇÔÚaspÖеÄд·¨£¬ÎÒÏëÖªµÀÔÚjsÖÐÔõôд£¬Çë½Ì¸÷λ´óÏÀ¡£
thank you.
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()
¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...
Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!
(ÔÚA ......
Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
_ConnectionPtr pConn(__uuidof(Connection));
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......
delphi 2007 + access 2007 +odbc +TADODataset,TADOConnection,TADOCommand
//ɾ³ýÊý¾Ý
procedure TCDSSelectTools.DeleteMachine(byMachineID: string);
tmpCmd := TADOCommand.Create(ni ......