¼±µÈ£¡accessÊý¾Ý¿â ÈÕÆÚ/ʱ¼ä ÀàÐ͵IJÎÊýÔõôд£¿£¿
"@LastLoginTime",OleDbType.DBTime,8,admin.LastLoginTime
´ó¼Ò¿´¹þ ¶Ô·ñ £¿´óСÊǶàÉÙ £¿
ÒÔ¼° ±¸×¢ ºÍÎı¾µÄ ¶ÔÓ¦µÄÊDz»ÊÇ char ´óС¸÷¶àÉ٠Ŷ£¿
¼±ÅθßÊÖÖ¸µã£¡
ÕÛÌÚ¹ý×Ŷ«Î÷£¬¿ÉÒÔ²»Ö¸¶¨ÀàÐÍ£¬Ö±½ÓÓÃ×Ö·û´®¡£
new OleDbParamter("@LastLoginTime",admin.LastLoginTime.ToString());
Èç¹ûÊý¾Ý¿âÄܽÓÊÜ´øÊ±¼äµÄÖµ£¬ÉÏÃæµÄ´úÂë»á³É¹¦µÄ¡£
#2009/12/23 12:00:00#
°É
²ÎÊýÊÇ£º»¹ÊÇ@ÍüÁ˶¼ÊÔϾÍÐÐÁË¡£
ÍøÉÏËÑË÷µÃ³öµÄ½á¹ûΪ£ºÎı¾ ÊÇ50¸ö×Ö·û, ±¸×¢×î¶àΪ 65,535 ¸ö×Ö·û
ллÖîλ µÄ´ð¸´
.net ²Ù×÷Access Êý¾Ý¿âʱ Êý¾Ý¿âµÄȨÏÞÒª²»ÒªÉèÖÃŶ
ÔõôÉèÖÃŶ£¿
new OleDbParamter("@LastLoginTime",admin.LastLoginTime.ToString());
Õý½â
UP Â¥É϶¼ÊÇÕý½â£¬¿ÉÒÔ ÓÃÖ¸¶¨ÀàÐ͵ģ¬Ö±½ÓÇ°Ãæ²ÎÊý£¬ºóÃæ¸øÖµ
new OleDbParamter("@LastLoginTime",admin.LastLoginTime.ToString());
ʱ¼äÓõÄʱºòÐèÒªinsert into tb where (time,aa,bb) values (#@time@,a,b)
ǰºóÒªÓÃ##
ÁíÍ⣬ACCESSµÄ²ÎÊýÊǰ´Ë³Ðò´«ÈëµÄ
²»°´²ÎÊýÃû½øÐжÔÓ¦£¬Ã¿¸ö²ÎÊýÓÃÒ»¸öÎʺţ¨?£©×÷ռλ·û
select * from [date]=? and id=?
Ïà¹ØÎÊ´ð£º
ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()
¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...
Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!
(ÔÚA ......
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
ÎÒÔÚÇ°Ì¨Ò³ÃæÊäÈë¿òÊäÈë 20091208 µã»÷Ìá½»Ö®ºó±¨´í,˵ÀàÐͲ»Æ¥Åä.
Êý¾Ý¿âÀï Õâ¸ö×ֶεĸñʽӦ¸ÃÊÇ 2009-12-8 14:27:40
ÊDz»ÊÇÒª°Ñ 20091208 ת»»³É¸ñʽ 2009-12-8 14:27:40
ÇëÎÊÎ ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......