SQLÓï¾äÈçºÎÔÚAccessÖÐÖ´ÐÐ
ͦÂé·³
²éѯ->´´½¨ ʲôµÄ
²»¶Ô£¬ ÎÒÒªÖ´ÐеÄÊÇÐÞ¸Ä~£¡
µ½µ×Ҫʲô£¿
ÔÚACCESSÖÐÖ´ÐУ¬¿ÉÒÔ´ÓACCESSµÄÖ÷²Ëµ¥£¬²åÈ룬²éѯ£¬È»ºóÉè¼Æ£¬ÔÙµ½Ö÷²Ëµ¥£¬ÊÓͼÖÐÑ¡Ôñ£Ó£Ñ£ÌÊÓͼ¡£
ÐÞ¸ÄÒ²Ò»Ñù¡£
²éѯ--Éè¼Æ--£Ó£Ñ£ÌÊÓͼ,ÎÞÂÛÊÇÏòµ¼Ð޸ġ¢É¾³ý»¹ÊÇÈ«SQLÓï¾ä¶¼¿ÉÒÔ
² ......
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ÖÐÓÐÐí¶à±éÀú¸÷ÖÖ¶ÔÏóµÄ·½·¨£¬ÎÒÏëÎÊһϸ÷λ´óÏÀ£º
1.ÈçºÎÔÚÔËÐÐʱ±éÀúϵͳ¶¨ÒåµÄ±äÁ¿£¨¾ÍÊÇÔÚ¶ÔÏóä¯ÀÀÆ÷Öп´µ½µÄ¶«Î÷£©£¬ÎÒÏë°ÑËüÃÇ´æµ½Ò»¸ö±íÖÐÈçºÎʵÏÖ£¿
2.ÈçºÎ±éÀú×Ô¼º³ÌÐòÄ£¿éÖж¨ÒåµÄÈ«¾Ö±äÁ¿£¿Óкη½·¨£¿
ÎÒµÄÏë·¨ÊÇÕâÑùµÄ£º
ÓÃÁËÒ»¶ÎACCESS·¢ÏÖMS¸ãµÃ¶«Î÷¿´Ëƹ¦ÄÜÇ¿´ó£¬ÓÃÆðÀ´²¢²»·½±ã.
ÎÒÃÇÉè¼Æ´ ......
ÎÒÏëÓÃ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) ......
ÎÊÌ⣺
·²ÊǶÔAccessÊý¾Ý¿â½øÐÐÄ£ºý²éѯ£¬¼´´ølike¹Ø¼ü×Ö²éѯʱ£¬¾³£ÐԵı¨ÄÚ´æÒç³öÎÊÌ⣡
baidu,googleÁËÖ®ºó£¬¾ù˵ÕâÊÇMS AccessµÄÒ»¸öBug,ÎҶԴ˰ëÐŰëÒÉ¡£ÍøÉÏÌá³öµÄ½â¾ö·½·¨´ó¶àÊÇÕæ¶ÔÈÕÎÄ¡¢º«ÎÄÐÔÖʵĴ洢ÄÚÈݽøÐбàÂëת»»£¬ Ìá½»²éѯÌõ¼þºÍ²éѯÍêÁËÖ®ºó£¬ÔÙת»»¹ýÀ´¡£ºÜ ......
ÒÔÏ´úÂ룺
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 ......