ÔõÑùÇå³ýACCESS»º´æ
ACCESS°æÓеãÀäÇå
Õâ¸öÄÄλ¸ßÈË»á
СµÜ¼±ÓÃ
²»»á SORRY
»°ËµÂ¥Ö÷ ÎÒÔÚSQLµÄµÚÒ»¸öÎÊÌⶼÊÇÄã½â¾öµÄ ллÄã ÎÒÓ¡ÏóÉî¿Ì
ÒýÓÃ
²»»á SORRY
»°ËµÂ¥Ö÷ ÎÒÔÚSQLµÄµÚÒ»¸öÎÊÌⶼÊÇÄã½â¾öµÄ ллÄã ÎÒÓ¡ÏóÉî¿Ì
...
ÕæµÄÂð
˵À´²ÑÀ¢°¡£¬¹þ¹þ
ÔÚ°Ù¶ÈÉÏÕÒһϣ¡Õ⸠......
ÔÚAccessÈí¼þÀ¿ÉÒÔÖ±½ÓÉèÖÃÈÕÆÚΪNow(),ºÃÏñÊÇÕâÑù°É¡£
ͨ¹ýsqlÓï¾ä£¬ALTER TABLE [article] ADD [date] datetime
µ«ÊÇÖ±½ÓÔÚºóÃæ¼ÓNow()£¬½á¹û³ö´í£¬Ôõôͨ¹ýsqlÓï¾äÖ±½ÓÉèÖóɵ±Ç°ÈÕÆÚ£¬¶ø²»ÓÃÍùÀïÃæ¼Ó£¿
ALTER TABLE [article] ADD [content] char(1000)£¬·µ»Ø´íÎó£¬Ì«´ó£¬¶ÔÓÚAccessÀ´Ëµ£¬×î´óÊǶàÉÙ£¬ ......
ÎÒÓÐÒ»¸ö±í,
´óÖ½ṹʽÕâ¸öÑù×ÓµÄ
id itname fenlei1id fenlei2id num
1 ÎïÆ·1 1 1 10
2 ÎïÆ·2 & ......
ÎÒÔÚʹÓÃadox+access,ʹÓóÌÐòÌí¼ÓÐÂÁеÄʱºò×ÜÊdzöÏÖ´íÎó,¶¼ÓÐÄÄЩÐèҪעÒâµÄѽ,лл!
ÎҵĴúÂëÊÇÕâÑùµÄ!
C/C++ code:
CoInitialize (NULL);
bsSQL = ...(Êý¾Ý¿âÁ¬½Ó×Ö·û´®)
m_pConnection.CreateInstance(__uuidof(Connection));
m_pCommand.CreateInstance(__uuidof(Comma ......
ÓÃADO²Ù×÷AccessÊý¾Ý¿â£¬ÎªÊ²Ã´°Ñ¼Ç¼ɾ³ýÖ®ºó£¬»¹ÄÜÔÙ²éѯ³öÀ´£¿
Á´½ÓÓï¾ä Provider=Microsoft.Jet.OLEDB.4.0;Data Source= 'MyDataBase'
ɾ³ýÓï¾ä delete from MyTable where ID = 100
1. ÊÇ·ñʹÓÃÁËÊÂÎñ£¬È»ºóûÓÐcommitÌá½»
2. ÖØÆôÒ»ÏÂÄãµÄ¼ÆËã»ú£¬¿´¹ÊÕÏÊÇ·ñÈÔÈ»´æÔÚ£¿
3. ÄãµÄ´úÂëÊÇʲ ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎΪ¡°Memo(Access±¸×¢)¡±µÄʱºò£¬Ê¹ÓÃMSHFlexGrid1.TextMatrixÈ¡µÃµÄÖµ²¢²»ÍêÈ«£¬Ö»ÓÐ999¸ö×Ö·û¡¡À§ÈÅÁËÒ»Ìì£ ......