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)
Ïà¹ØÎĵµ£º
ÊÔ×ÅÓÃÁËÒ»ÏÂMindManager,ʹÓúÜÈÝÒ×,ÏÂÃæÊÇÎÒÁ·Ï°×Å×öµÄÒ»¸öͼÐÎ,Ï£ÍûÒÔºó»áÔ½ÓÃÔ½ÊìÁ·,×öµÃ¸üºÃ!
& ......
java ÓÃrmi±àд¿Í»§/·þÎñ³ÌÐò
³öÏÖaccess denied ÎÊÌâ
ÒòΪ²»ÖªµÀÔõôÅäÖà ²ßÂÔÎļþ ¾Í½«¿Í»§¶ËµÄSystem.setSecurityManager(new RMISecurityManager())ɾÁË£¬ÔËÐÐjava ProductClient
³É¹¦£¡
ÅäÖòßÂÔÎļþµÃÖ®ºó²ÅŪÀ² ......
VBÎÞËù²»ÄÜÖ®Î壺½¨Á¢“±ê×¼”DLL¶¯Ì¬Á´½Ó¿âÎļþ£¨2£©
——×÷ÕߣºÖÓÉù
²©¿ÍµØÖ·£ºhttp://blog.csdn.net/useway
×òÌìÎÒÃǽ²µ½£¬ÈçºÎͨ¹ýÌØÊâ·½·¨»ñÈ¡OBJÎļþ£¬ÄÇô½ñÌìÎÒÃǼÌÐø½²ÈçºÎ½øÐбàÒëÁ¬½Ó¡£
  ......
ÉÏһƪÖÐÎÒÒѾ˵ÁËÏÂÈçºÎ²Ù×÷ACCESSÊý¾Ý¿â£¬ÏÂÃæÀ´ËµËµ´æÈ¡Í¼Æ¬£¬ÉùÒôÖ®ÀàµÄÎÊÌâ¡£
ÓÉÓÚͼƬ£¬ÉùÒô²»ÄÜÖ±½Ó´æ´¢£¬ÕâÀï¾ÍÒªÓõ½Êý¾ÝÁ÷·½Ê½ÁË¡£¶ÔÓÚ.NETÖеÄһЩÊõÓï¸ÅÄîÎÒÈÔÈ»ºÜÃÔºý£¬ÔÚѧϰÖС£Ö÷ÒªÎÒ²»ÊÇרҵµÄ£¬
Ö»ÊÇ¿ªÊ¼Ñ§Á˵ãVB6´úÂ룬Ȼºó¾ÍÓÃVB.NETÁË£¬ËùÒÔĿǰֻÊÇ»áдµã´úÂ룬ȴ²»Öªµ ......