Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : vb

Vb.net Access²éѯ°´ÄêÔÂ


    ÎÒÐèҪͨ¹ýµ¥¸ö²éѯÌõ¼þ°´ÄêÔÂ,²éѯµ½accessÊý¾Ý¿âÀïµÄÊý¾ÝΪ (ÈÕÆÚÀàÐÍ2008-02-02)


        Dim DDTP1 As String

        Dim date1 As Date = DTP1.Value

        DDTP1 = Format(date1, "#yyyy-MM#" ......

Vb.net Access²éѯ°´ÄêÔÂ


    ÎÒÐèҪͨ¹ýµ¥¸ö²éѯÌõ¼þ°´ÄêÔÂ,²éѯµ½accessÊý¾Ý¿âÀïµÄÊý¾ÝΪ (ÈÕÆÚÀàÐÍ2008-02-02)


        Dim DDTP1 As String

        Dim date1 As Date = DTP1.Value

        DDTP1 = Format(date1, "#yyyy-MM#" ......

vb.net¸üÐÂACCESSÊý¾Ý¿â±¨´í£¬Çë½Ì¸ßÊÖ£¡

½öÊÇÒ»¶Î¸üÐÂÃÜÂëµÄ´úÂëÈçÏ¡£±¨´íÐÅϢΪ£º

δ´¦ÀíµÄ¡°System.Data.OleDb.OleDbException¡±ÀàÐ͵ÄÒì³£³öÏÖÔÚ System.Data.dll ÖС£

ÆäËûÐÅÏ¢: UPDATE Óï¾äµÄÓï·¨´íÎó¡£

µ¥¶ÀµÄINSERTÓïÑÔÔÚÊý¾Ý¿âÖÐÔËÐÐͨ¹ý¡£²¢ÇÒselectcommand ,insertcommand ¶¼ÊÇ¿ÉÒÔÔËÐеģ¬Î¨¶Àupdate ±¨Óï·¨´íÎó¡£
Çë½Ì¸ß ......

VB.net °ÑExcelÅúµ¼µ½Access

ÓÉExcel±í¸ñµ¼Èëµ½AccessÊý¾Ý¿â,µ¼Èë¹ý³ÌÖгöÏÖÓиö±ðÊý¾Ý³öÏÖÎÊÌâ,

Ê×ÏÈÌø¹ýÓÐÎÊÌâµÄÊý¾Ý,È»ºó°ÑÕâÌõÊý¾Ý´æ·Å½øÊý×é,ÔÚ´¦ÀíÍêËùÓе¼È붯×÷Ö®ºó,

ÔٰѳöÏÖÎÊÌâµÄ¼Í¼(¹¤ºÅºÍ¼Í¼ÌõÊý)ÓÃMSGBOXÌáʾ¸ø¿Í»§.


ÊÇ·ñÐèÒª°Ñµ¼ÈëµÄÊý¾ÝÿÌõ¶ÔÓ¦Êý¾ÝµÄÂÖ×ŶԱÈ?

ÇëÎʸÃÈçºÎʵÏÖ?

ÖªµÀµÄÐÖµÜÇ ......

ÈçºÎÓÃVB2005ѸËÙÇå¿ÕACCESSÊý¾Ý¿â£¿

±¾²ËÄñÔÚʹÓÃVB2005¶ÔACCESS±à³ÌʱÓöµ½ÎÊÌ⣺²»ÖªÈçºÎ°Ñ±íµÄËùÓмǼȫ²¿É¾³ý¡£²»ÖªÓÐûÓиßÊÖÄÜÌṩ´úÂ룿


àÅ£¬Ó¦¸ÃÓÃɾ³ý±íÓï¾ä
DELETE * from ±íÃû
Â¥ÉÏ˵µÃ¶Ô£¡

ÄDz»ÊÇÕû¸ö±í¶¼É¾³ýÁË£¿

ÒýÓÃ
ÄDz»ÊÇÕû¸ö±í¶¼É¾³ýÁË£¿


²»ÊÇɾ³ý,ÊÔÊÔ¿´

delete * from ±íÃû

delete  from ± ......

ÇóVB6.0Á¬½ÓSqliteÊý¾Ý¿â¼°²éѯ´úÂë

ÇóVB6.0Á¬½ÓSqliteÊý¾Ý¿â¼°²éѯ´úÂ룬½â˵ԽÏêϸԽºÃ£¬ÒòΪÎÒ»¹Ã»ÓÐÓùýSQLite£¬Ð»Ð»£¡
Éϴζ¼²»¸øÎÒ·Ö¡£¡£
×¢²ásqltp30.dllÕâ¸öActiveX DLL
ÓÃÀïÃæµÄSQLiteDBÀཨÁ¢¡¢Á¬½ÓÊý¾Ý¿âÎļþ£¬¾ÍÏñADODBÀïµÄConnection
ÓÃÀïÃæµÄDatasetÀà²Ù×÷±í£¬¾ÍÏñADODBµÄRecordset¡£



http://topic.csdn.net/u/20090908/17 ......
×ܼǼÊý:1659; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [213] [214] [215] [216] 217 [218] [219] [220] [221] [222]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ