Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
 ×îÐÂÎÄÕ : access

SQLÓï¾äÈçºÎÔÚAccessÖÐÖ´ÐÐ

SQLÓï¾äÈçºÎÔÚAccessÖÐÖ´ÐÐ
ͦÂé·³
²éѯ->´´½¨ ʲôµÄ

²»¶Ô£¬ ÎÒÒªÖ´ÐеÄÊÇÐÞ¸Ä~£¡

µ½µ×Ҫʲô£¿

ÔÚACCESSÖÐÖ´ÐУ¬¿ÉÒÔ´ÓACCESSµÄÖ÷²Ëµ¥£¬²åÈ룬²éѯ£¬È»ºóÉè¼Æ£¬ÔÙµ½Ö÷²Ëµ¥£¬ÊÓͼÖÐÑ¡Ôñ£Ó£Ñ£ÌÊÓͼ¡£


ÐÞ¸ÄÒ²Ò»Ñù¡£

²éѯ--Éè¼Æ--£Ó£Ñ£ÌÊÓͼ,ÎÞÂÛÊÇÏòµ¼Ð޸ġ¢É¾³ý»¹ÊÇÈ«SQLÓï¾ä¶¼¿ÉÒÔ

² ......

Á¬½ÓaccessÊý¾Ý¿â¼ìÑéÕ˺ÅÎÊÌâ

Public Class loginform1
   
    Dim strCon As String = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source =8021.mdb"
    Dim strCom1 As String = " SELECT *  from loginname "
 
Private Sub OK_Click(ByVal sender As System.Objec ......

ACCESSµÄ±éÀúÎÊÌ⣿

ACCESSÖÐÓÐÐí¶à±éÀú¸÷ÖÖ¶ÔÏóµÄ·½·¨£¬ÎÒÏëÎÊһϸ÷λ´óÏÀ£º
1.ÈçºÎÔÚÔËÐÐʱ±éÀúϵͳ¶¨ÒåµÄ±äÁ¿£¨¾ÍÊÇÔÚ¶ÔÏóä¯ÀÀÆ÷Öп´µ½µÄ¶«Î÷£©£¬ÎÒÏë°ÑËüÃÇ´æµ½Ò»¸ö±íÖÐÈçºÎʵÏÖ£¿
2.ÈçºÎ±éÀú×Ô¼º³ÌÐòÄ£¿éÖж¨ÒåµÄÈ«¾Ö±äÁ¿£¿Óкη½·¨£¿


ÎÒµÄÏë·¨ÊÇÕâÑùµÄ£º
ÓÃÁËÒ»¶ÎACCESS·¢ÏÖMS¸ãµÃ¶«Î÷¿´Ëƹ¦ÄÜÇ¿´ó£¬ÓÃÆðÀ´²¢²»·½±ã.
ÎÒÃÇÉè¼Æ´ ......

ÓÃC#ÔÚAccessÖÐн¨Ò»¸ö±í

ÎÒÏëÓÃC#ÓïÑÔÔÚAccessÖÐн¨Ò»¸ö±í£¬Ï£Íû¿ÉÒÔддһС³ÌÐò¶Îлл
http://dotnet.aspx.cc/ShowDetail.aspx?id=275E8772-A68A-417F-FD66-B75EA44499A4

Create  Table  tbl 
  ( 
  id  text(10)  not  null, 
  name  text(10)  ......

C#²Ù×÷Accessʱģºý²éѯBug

ÎÊÌ⣺

    ·²ÊǶÔAccessÊý¾Ý¿â½øÐÐÄ£ºý²éѯ£¬¼´´ølike¹Ø¼ü×Ö²éѯʱ£¬¾­³£ÐԵı¨ÄÚ´æÒç³öÎÊÌ⣡

    baidu,googleÁËÖ®ºó£¬¾ù˵ÕâÊÇMS AccessµÄÒ»¸öBug,ÎҶԴ˰ëÐŰëÒÉ¡£ÍøÉÏÌá³öµÄ½â¾ö·½·¨´ó¶àÊÇÕæ¶ÔÈÕÎÄ¡¢º«ÎÄÐÔÖʵĴ洢ÄÚÈݽøÐбàÂëת»»£¬ Ìá½»²éѯÌõ¼þºÍ²éѯÍêÁËÖ®ºó£¬ÔÙת»»¹ýÀ´¡£ºÜ ......

vb+accessÌí¼ÓÊý¾Ý

ÒÔÏ´úÂ룺
Private Sub Form_Load()
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\¹¤×÷\SQL\fetion.mdb;Persist Security Info=False"
conn.Open connStr


Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = "&qu ......
×ܼǼÊý:990; ×ÜÒ³Êý:165; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [44] [45] [46] [47] 48 [49] [50] [51] [52] [53]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ