vb.net²Ù×÷Êý¾Ý¿âÖ®ACCESS£¨3£©
ÕâһƪÎÒÔÙ˵˵ˮ¾§±¨±íµÄÇé¿ö¡£ACCESSÖжÔӦˮ¾§±¨±í·½Ã棬´ó¼Ò¿ÉÄÜ»áÓöµ½µÄ×î¶àµÄÎÊÌâÓ¦¸Ã¾ÍÊÇ´ò¿ª±¨±íºó
»á³öÏÖÐèÒªµÇ¼µÄÎÊÌâ¡£
Õâ¸öÊÇÎªÊ²Ã´ÄØ£¿Ã÷Ã÷ÎÒûÓÐÉèÖÃÃÜÂ룬Ôõô»áÓÐÒªÊäÈëÃÜÂëÄØ£¿Èç¹ûÄã¹»³Á×Å£¬Èç¹ûÄãµÄdebug¾Ñ鲻ȱ·¦µÄ»°£¬
Äã»á·¢ÏÖÔÚË®¾§±¨±íÌø³öÊäÈëÃÜÂëµÄµÇ¼¿òÖУ¬accessµÄ·¾¶²»ÊÇÎÒÏÖÔÚÊý¾Ý¿â·ÅÖõÄλÖã¬ÈÔÈ»ÊÇÎÒÔÚ±àÂëµÄʱºò
Ñ¡ÔñµÄÊý¾Ý¿âµØÖ·¡£ËûΪʲôûÓбäÄØ£¿ÆäʵÕâ¸öʱºòÄãÐèÒªÎÊ£¬Õâ¸öµØÖ·ÎªÊ²Ã´Òª±ä£¿
µ±ÄãʹÓù«Ó÷þÎñÆ÷µÄʱºò£¬¿ÉÄܲ»»á³öÏÖÕâ¸öÎÊÌ⣬ÒòΪÄã²»¹Üµ½Äĸö¿Í»§¶ËʹÓ㬷þÎñÆ÷µØÖ·²»»á±ä¡£È»¶øÄãÓÃaccess£¬
µ±Êý¾Ý¿â¸ú×Å»»Á˵çÄԺ󣬷þÎñÆ÷µØÖ·µ±È»Ò²±äÁË£¬¶øÄã±àÂëÖеĵØÖ·È´Ã»Óб䣬Õâ¸ö¾ÍÊÇÎÊÌâ³öÏÖµÄÔÒò¿©£¡Ã÷°×Á˰ɣ¿
ÆäʵÊǺܼòµ¥µÄÒ»¸öµÀÀí¡£
ÄÇÔõô°ìÄØ£¿ÀÏ¹æ¾Ø£¬¿´´úÂë¡£
‘Êý¾Ý¿âÁ¬½Ó
DBConnection.ConnectionString = DB_CnStr()
DBConnection.Open()
'¿ªÊ¼²éѯ
Dim sql As New System.Text.StringBuilder
Dim DT As New DataTable
sql.Append(" SELECT * from WORDINFO")
Dim cmd As New OleDb.OleDbCommand(sql.ToString, DBConnection)
Dim RS As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(cmd)
DT = New DataTable
RS.Fill(DT)
DBConnection.Close()
’ÒÔÉϾÍÊÇÊý¾Ý¿âÀï²éѯ£¬ÏÂÃæ¾ÍÊǰѲéѯ½á¹û¸øË®¾§±¨±íÀ´ÏÔʾ¡£
’Ïȶ¨Ò屨±íµÄλÖ㬽Ó×Ŷ¨ÒåÒ»¸ö±¨±íÒ³Ãæ£¬È»ºóÊÇÒ»¸ö×Ô¶¯µÇ¼Êý¾Ý¿âµÄ
Dim reportPath As String = Application.StartupPath & "\" & "CrystalReport.rpt"
Dim rptDoc As New CrystalDecisions.CrystalReports.Engine.ReportDocument
Dim logonInfo As New CrystalDecisions.Shared.TableLogOnInfo
rptDoc.Load(reportPath)
‘ÕâÀï¾ÍÊÇÉèÖÃÊý¾Ý¿âµÇ¼µÄÐÅÏ¢£¬ACCESSÖÐÓÐÕ˺ÅÃÜÂëµÄ»°¾ÍÌûÓеϰ¾ÍÈ«²¿¿Õ£¬
’Èç¹ûÆäËûµÄÊý¾Ý¿â£¬Èçsql¾ÍÒªÌî·þÎñÆ÷ºÍÊý¾Ý¿âÃû³ÆÁË
logonInfo.ConnectionInfo.ServerName = ""
logonInfo.ConnectionInfo.DatabaseName = ""
logonInfo.ConnectionInfo.UserID = ""
logonInfo.ConnectionInfo.Password = ""
rptDoc.Database.Tables(0)
Ïà¹ØÎĵµ£º
´°ÌåÉèÖ㬿ؼþ²¼¾ÖʱÓÃ:
alt+v+x¿ÉÒÔ¿ìËÙÏÔʾ³ö¹¤¾ß¿ò
Alt+P+N ÒýÓÃ
ctrl+×óÓÒ¼üÍ·¿ÉÒÔÒÆ¶¯¿Ø¼þ
shift+×óÓÒ¼üÍ·µ÷Õû¿Ø¼þ´óС
F7 Çл»µ½±à¼´°¿Ú
Shift+f7 Çл»´úÂë´°¿Ú
¿ª·¢´úÂ룬µ÷ÊÔ´úÂë¶¼ÄÜÓõģº
Ctrl+C¸´ÖÆ
Ctrl+VÕ³Ìù
Ctrl+X¼ôÌù
Ctrl+F²éÕÒ
¿ª·¢´úÂëʱÓõÄ:
Tab ÏòÓÒÍÆ
Shi ......
len£¨string£©£º¼ÆËã×Ö·û´®³¤¶Èº¯Êý¡£·µ»Ø×Ö·û´®stringÖÐ×Ö·ûµÄ¸öÊý¡£Ò»¸öºº×ÖΪһ¸ö×Ö·û£¬¿Õ¸ñҲΪһ¸ö×Ö·û£¬¿Õ×Ö·û´®µÄ³¤¶ÈΪ0.
Ltrim£¨string£©¡¢Rtrim£¨string£©¡¢Trim£¨string£©£º
Ltrim£¨string£©º¯Êý¹¦ÄÜÊÇ·µ»ØÉ¾³ýÁË×Ö·û´®string×ó±ß¿Õ¸ñÖ®ºóÊ£ÓàµÄ²¿·Ö¡£
Rtrim£¨string£©º¯Êý¹¦ÄÜÊÇ·µ»ØÉ¾³ýÁË×Ö·û´®ÖÐstringÓ ......
ÒÑÖªÓÐÒ»¸öXMLÎļþ£¨bookstore.xml£©ÈçÏ£º
<?xml version="1.0" encoding="gb2312"?>
<bookstore>
<book genre="fantasy" ISBN="2-3631-4">
<title>Oberon's Legacy</title>
<author>Corets, Eva</author>
<price>5.95</price>
</book>
< ......
VBÎÞËù²»ÄÜÖ®Î壺½¨Á¢“±ê×¼”DLL¶¯Ì¬Á´½Ó¿âÎļþ£¨2£©
——×÷ÕߣºÖÓÉù
²©¿ÍµØÖ·£ºhttp://blog.csdn.net/useway
×òÌìÎÒÃǽ²µ½£¬ÈçºÎͨ¹ýÌØÊâ·½·¨»ñÈ¡OBJÎļþ£¬ÄÇô½ñÌìÎÒÃǼÌÐø½²ÈçºÎ½øÐбàÒëÁ¬½Ó¡£
  ......