ÊDz»ÊÇÄÜÏñ²Ù×÷sqlÊý¾Ý¿âÒ»Ñù²Ù×Ýaccess £¿
SQL code:
A£ºÐèÅäODBCÊý¾ÝÊý¾ÝÔ´
*---------------------------
&&ODBCµÄÅäÖÆ·½·¨ÔÚÕâÀï²»ÔÙ½éÉÜ£¬ÒÔÏÂfinger3ΪÊý¾ÝÔ´Ãû
nhandle=SQLConnect("finger3",'','ÃÜÂë')
If nhandle<0
Messagebox("Êý¾Ý¿âÁ¬½Óʧ°Ü£¡£¡£¡",16, '´íÎóÐ ......
String SQL="select name from stu where id='01'";ÓÃÕâÒ»¾ä¿ÉÒÔÕý³£²éѯ
String id="01";
String SQL="select name from stu where id="+id;ÓÃÕâÁ½¾ä¾Í²»ÄÜÁË£¬±¨´í£º±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£
ÕâÊÇÔõô»ØÊ£¬´ú²ÎµÄ²éѯÔõôʵÏÖÄØ£¿
ÎÒÖ±½ÓÔÚACCESSÀï²é
select name from stu whe ......
ÎÒ½¨Á¢ÁËÒ»¸ö±í
id NAME
1 1.Îļþ
2 3.Îļþ
3 5.Îļþ
4 2.Îļþ
5 4.Îļþ
ÈçºÎ°ÑÕâ¸öÊý¾Ý¿âÖеÄÊý¾Ý°´Ë³Ðò1.Îļþ
2.Îļþ
......
declare @number int select @number=max(ÀàÐͱàºÅ) from ¿Í·¿ÀàÐÍ if(@number is null) begin select @number=0 end select @number insert into [¿Í·¿ÀàÐÍ] values(@number+1,@ÀàÐÍÃû³Æ,@¿Í·¿¼Û¸ñ,@ÊýÁ¿)
Õâ¸öÓï¾äÊÇÔÚsqlÖÐÖ´Ðеģ¬Ôõô»»³ÉÔÚaccessÖÐÖ´ÐУ¬Ä¿Ç°»á±¨´í£¡
ÎÒÒ²ÕÒÁË£¬¸ÄÁË»¹ÊDz»ÐÐ
ÊDz»ÊÇÄãÁ¬½Ó×Ö·û ......
System.IO.File.Copy(Server.MapPath("~/App_Data/lulukang.mdb"), "DataBackup", true);ÎÒÊÇÕâôдµÄ£¬Ôõô²»ÐУ¿
DataBackupÊÇÎÒÏîÄ¿Ò»¸öÎļþ¼ÐÃû
System.IO.File.Copy(Server.MapPath("~/App_Data/lulukang.mdb"), Server.MapPath("~/DataBackup/lulukang.mdb"), true);
......
ÎÒÏë×öÒ»¸ö¹¤³Ì£¬ÓÐÁ½¸öexeµÄÎļþ£¬¹²Í¬ÔËÓÃͬһ¸öÊý¾Ý¿â£¬¶Ôͬһ¸öÊý¾Ý¿âµÄÎļþ½øÐвÙ×÷£¬µ«ÊÇ£¬²»ÖªµÀÔõôÔÚÆäÖвÁÈëÒ»¸öÊý¾Ý¿â£¬Íû¸ãÈËÖ¸µã
Èç¹ûÓÐÁ½¸öexeµÄ´úÂë¸Ä´úÂë¾ÍÐÐÁË,ûÓеĻ°¾Í²»ÖªµÀÁË.
ÐèÒªÓõ½½ø³Ì¼äͨѶÎÊÌ⣡
{{ ......