Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ʵÏÖÓÉÎı¾µ¼Èëµ½AccessÒѾ­¶¨ÒåºÃµÄ±í

ÏëʵÏÖ ´ÓÎı¾Îļþµ¼Èëµ½AccessÒѾ­¶¨ÒåºÃµÄ±í£¬

Îı¾ÎļþÄÚÈÝÊÇ£º

id1,value11, value12,value13
id2,value21,value22,value23

±í×Ö¶Î
id, value0,value1,value2,value3,value4

ʵÏÖ°ÉÎı¾ÀïÃæµÄÄÚÈÝ£¬¶ÔӦÿ¸ö×Ö¶Î µ¼Èëµ½±íÀïÃæ£¬ÓÐûÓбȽϿìËٵķ½·¨¡£

Îı¾ÎļþÀïÃæÃ»ÓÐ ±íÍ·ÐÅÏ¢

Óа¡ ÎÒ¾ÍÊÇÓÃÊÖ¶¯µ¼Èë´óÁ¿txtÊý¾ÝµÄ¡£
н¨Ò»¸öaccess£¬µã»÷ÍⲿÊý¾Ý£¬Ñ¡Ôñtxt£¬µ¼ÈëÄãµÄtxtÎļþ·¾¶£¬ÉèÖÃϾͿÉÒÔÁË µ«ÊÇtxtÊý¾ÝÀïÃæ¸ñʽһ¶¨µÄ¶ÔÆë¡£

Äã¿ÉÒÔÔÚtxtµÄµÚÒ»ÐмÓÉϱíÍ·ÐÅÏ¢£¬ ÔÚµ¼ÈëtxtºóÓиöÑ¡ÏîÊǽ«µÚÒ»ÐÐÉèΪ±íÍ·ÐÅÏ¢µÄ ²»Óõ£ÐÄÕâ¸ö

ÒýÓÃ
Óа¡ ÎÒ¾ÍÊÇÓÃÊÖ¶¯µ¼Èë´óÁ¿txtÊý¾ÝµÄ¡£
н¨Ò»¸öaccess£¬µã»÷ÍⲿÊý¾Ý£¬Ñ¡Ôñtxt£¬µ¼ÈëÄãµÄtxtÎļþ·¾¶£¬ÉèÖÃϾͿÉÒÔÁË µ«ÊÇtxtÊý¾ÝÀïÃæ¸ñʽһ¶¨µÄ¶ÔÆë¡£

ÎÒ²»ÊÇÊÖ¶¯µ¼£¬ÊÇÓóÌÐòÀ´ÊµÏÖ£¬
ÔÙÒ»¸ö£¬ÎҵıíʱÌáǰ¶¨ÒåºÃµÄ¸ñʽ£¬²»Äܱ»Ð޸쬵¼ÈëµÄʱºò£¬Îı¾ÎļþÀïÃæµÄÄÚÈÝ ÊÇËùÓÐ×ֶεÄÒ»²¿·Ö£¬²»ÊÇËùÓÐ×ֶζ¼ÓÐÖµ

ÄÇÄ㽫ÉÏÃæÊÖ¶¯µÄ²½ÖèÒ²³É´úÂëÖ´ÐÐÒ²¿ÉÒԵģ¬ ÎÒ¿ìµÄ»° ²»³¬¹ý30Ãë

ÒýÓÃ
ÄÇÄ㽫ÉÏÃæÊÖ¶¯µÄ²½ÖèÒ²³É´úÂëÖ´ÐÐÒ²¿ÉÒԵģ¬ ÎÒ¿ìµÄ»° ²»³¬¹ý30Ãë


²»»á²ÅÎÊÄãµÄ°¡

ÌøÐеÄÎı¾Êý¾ÝÖ»ÄÜ×Ô¼ºÐ´³ÌÐò£¬Ò»ÐÐÒ»ÐжÁ³öÀ´£¬ÓÃInsertÂýÂý²å°É¡£

ÒýÓÃ
ÌøÐеÄÎı¾Êý¾ÝÖ»ÄÜ×Ô¼ºÐ´³ÌÐò£¬Ò»ÐÐÒ»ÐжÁ³öÀ´£¬ÓÃInsertÂýÂý²å°É¡£


²»ÓÃÌøÐУ¬ÐèÒªÌøÁÐ


ÒýÓÃ
Ê×ÏÈ£¬È·¶¨Îı¾µÄ¸ñʽ£¬Ò»ÌõÊý¾ÝÒ»ÐÐ


Ïà¹ØÎÊ´ð£º

DbgridÁ¬½ÓaccessÍ϶¯¹ö¶¯ÌõËÀ»ú£¿

DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿

ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿

Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£

ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......

½â¾öaccess¼¶Áª¸üÐÂÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

CREATE TABLE Product(model integer, 
maker varchar(20), 
CONSTRAINT SAND PRIMARY KEY (model), 
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) 
ON DELETE CASCADE ......

VC ADO ACCESS sql ²éѯ - VC/MFC / Êý¾Ý¿â

´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ