accessÖÐʹÓÃtableÈ·¶¨Î»ÖÃ
¡¡¡¡²»ÖªµÀaccessÖÐÊÇ·ñÄܹ»Ê¹ÓÃtableÀ´½«¸÷¸ö¿Ø¼þ·ÅÈëÏàÓ¦µÄtableµÄ¸÷¸ö¸ñ×ÓÖУ¬¾Í¸úvsµÄaspÒ»Ñù¡£ÔÚdesignÖÐûÓÐÕÒµ½¿ÉÒÔÔÚÒ³ÃæÖгÊÏÖÒ»¸ötableµÄ¹¤¾ß£¬Ïò´ó¼ÒÇó½Ì£ºaccessµ½µ×ÊÇ·ñÓÐÕâÑùµÄ¹¤¾ß£¿
¿´À´£¬accessµÄ½çÃæ¹¦ÄÜ»¹ÊÇûÓÐvsÇ¿´ó£¬ºÇºÇ£¡
ÓÃÁËÒ»¸ösub form£¬Ò²²»ÊǺܺÃÓá£
Ïà¹ØÎÊ´ð£º
ÎÊÌâÈçÏ£º
ÓòéѯÓï¾ä
select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´
¸ÄΪ
select * from tab where fil = 'CK090902'
¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎÎ ......
ÎÒÔÚSQL2000ÖÐÏÂÃæµÄÕâ¾äÊÇûÎÊÌâµÄ,¿Éµ½ÁËaccessÀï¾Í»áÁË´í
select max(classname) as classname,max(parentpath) as parentpath,max(rootid) as rootid,max(classid) as classid from prodclass where parentpa ......
Public Rs As New ADODB.Recordset
Public Conn As New ADODB.Connection
Private Sub Command1_Click()
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & A ......