vbÀïµÄÎÊÌâ
Ìí¼ÓͼÊéʱ³öÏÖ´íÎ󣺶ÔÏó´ò¿ªÊ±£¬²»ÔÊÐí²Ù×÷
´úÂëÈçÏ£º
Dim Conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim cmd As New ADODB.Command
Public connstring As String
Private Sub cmdadd_Click()
rs.Open strsql, Conn, 3, 3
rs.Open "select * from ͼÊé ", Cn, adOpenKeyset, adLockOptimistic, adCmdText
If txtÊéºÅ.Text = "" Or txtÊéÃû.Text = "" Or Txt×÷Õß.Text = "" Or _
txt³ö°æÉç.Text = "" Or txtµ¥¼Û.Text = "" Or txt½è³ö·ñ.Text = "" Then
MsgBox "ͼÊéµÄÐÅÏ¢Ìîд²»ÍêÕû,ÇëÖØÐÂÌîд!", vbOKOnly + _
vbExclamation, "¾¯¸æ"
Else
rs.AddNew
rst!ͼÊé_bookid = txtÊéºÅ.Text
rst!ͼÊé_ÊéÃû = txtÊéÃû.Text
rst!ͼÊé_×÷Õß = Txt×÷Õß.Text
rst!ͼÊé_³ö°æÉç = txt³ö°æÉç.Text
rst!ͼÊé_¶¨¼Û = txtµ¥¼Û.Text
rst!ͼÊé_½è³ö·ñ = txt½è³ö·ñ.Text
rs.Update
MsgBox "Ìí¼ÓͼÊé³É¹¦!", vbOKOnly
txtÊéºÅ.Text = "": txtÊéÃû.Text = "": Txt×÷Õß.Text = "": _
txt³ö°æÉç.Text = "": txtµ¥¼Û.Text = "": txt½è³ö·ñ.Text
Ïà¹ØÎÊ´ð£º
ÔÚvbÕâ±à³ÌÀïËÆºõÓкܶàµÄ¶«Î÷ÊÇÏàÁªÏµµÄ£¬ÎªÊ²Ã´ÓÐЩÈ˶ÔvbµÄ±à³ÌÃþ²»µ½Í·ÄÔ°¡£¡²¢ÇÒÓÐЩʺÜÈÝÒ׵쬵«ÊÇÈ´°ÑËüÃǵĴúÂë±ä³É¸´ÔÓ£¬Ò²È¥ÏëһЩ²»ÄÜʵÏֵĶ«Î÷°¡£¡
û·ÖÁË£¬Â¥Ö÷¶àÀ´µã·Ö£¡
À´½Óµã·Ö
......
ÔÚÏÂÊÇvbµÄÐÂÊÖ£¬Ïëд¶Î³ÌÐò£¬ÔÚvbÖУ¬Ê¹ÓÃwscriptµ÷ÓÃһЩÍⲿµÄÃüÁµ«ÊdzÌÐòÖ´ÐÐÒ»Ö±ÓдíÎó£¬Çë¸÷λ¸ßÊÖ°ïæ½â´ðÏ£¬Ð»Ð»¡£
´úÂëÈçÏ£º
VB code:
Private Function getFile_CMD(filename, filepath) As Bo ......
ÎÒÊÇVBµÄгÉÔ±£¬ÏÖÔÚÏëÓÃVBÀ´×ö¸öTXTÎĵµ£¬Çë´ó¼Ò¸øÎÒ´úÂë¼°½éÉÜÒ»ÏÂÏàÓ¦µÄ¿Ø¼þ£¡
·Ç³£¸Ðл£¡£¡£¡£¡£¡£¡
¿ÉÒÔÓÃһЩOFFICE¿Ø¼þ
googleÉÏÕÒһϰÉ,VBдÈëTXT,ºÜ¶àÑùÀý´úÂëµÄ
Ö±½Óµ÷²éÓþͿÉÒÔÁË
Ãæ¶ÔÃÀÅ® ......
ÎÒдÁËÒ»¸öÈí¼þ£¬ÒªÓõ½ACCESSÊý¾Ý¿â£¬ÎÒÔÙ·ÃÎÊACCESSµÄʱºò£¬ÎÒÐèÒª´Ó±íÀï¶Á³öÒ»ÐÐÊý¾Ý£¬ÎҵijÌÐòÊÇÕâÑùдµÄ£¬SQLSTRING="SELECT * from '" &ME.TEXTBOX1.TEXT &"' WHERE ID = '"& ......
¸÷λºÃ£¬ÎÒÏÖÔÚÒªÓÃһ̨¼ÆËã»úͬʱ¼à¿Ø32̨ÐźŽÓÊÕ»ú£¨ÓõÄÊÇMOXA¿¨À©Õ¹32¸ö´®¿Ú£©¡£Ïȵ÷ÊÔ8̨¡£ÏÖÔÚµÄÎÊÌâÊÇ£¬ÎÒÓÐÁ½¸öÃüÁîÐèÒªÏò½ÓÊÕ»ú·¢ËÍ£¬Ò»¸öÊÇ¼à¿Ø½ÓÊÕ»úÉϵÄÐźÅËø¶¨×´Ì¬£¬Ò»¸öÊÇ»ñÈ¡½ÓÊÕ»úĿǰµÄ¸÷À๤×÷× ......