vb×Ó³ÌÐò»òº¯Êý䶨Òå - VB / »ù´¡Àà
Private Sub Command1_Click()//ÔËÐÐʱ×ÜÏÔʾÕâÀï¡°×Ó³ÌÐò»òº¯Êý䶨Ò塱 Dim db As Database Dim rs As Recordset Dim ws As Workspace Set ws = CreateWorkspace("", "admin", "", dbUseJet) Set db = ws.OpenDatabase(App.path + "\", False, False, "foxpro 2.5;") Set rs = db.OpenRecordset("select * from block.dbf where [blockname] like '" + trime(Text1.Text) + "'", dbOpenDynaset) If rs.RecordCount Then MsgBox "´Ë°å¿éÒÑ´æÔÚ" rs.Close db.Close ws.Close Exit Sub End If End Sub
Dim db As Database Dim rs As Recordset Dim ws As Workspace ÕâЩ¶¼ÐèÒªÒýÓᣠÁíÍâDAO±È½Ï¹ýʱÁË£¬lz¿¼ÂÇʹÓÃADO°É¡£ÒýÓà Dim db As Database Dim rs As Recordset Dim ws As Workspace ÕâЩ¶¼ÐèÒªÒýÓᣠÁíÍâDAO±È½Ï¹ýʱÁË£¬lz¿¼ÂÇʹÓÃADO°É¡£ ÄǸÃÔõôÒýÓÃÄØ£¿ Trime(Text1.Text) Ó¦¸ÃÊÇTrim(Text1.Text)£¬¶àÇÃÁ˸öe£¬¿ÉÊÇÕâÑùºóÓÖÌáʾ£ºÊµÊ±´íÎó91£¬¶ÔÏó±äÁ¿»òwith¿é±äÁ¿Î´ÉèÖà ÕâÊÇʲôÎÊÌâÄØ£¿ ÎÒ¹À¼ÆÓÐÁ½ÖÖÇé¿ö£ºÒ»¡¢ÄãµÄ°´Å¥¿Ø¼þ»»ÃûÁË£¬Ãû³Æ¸ÄÁË£¬²»ÊÇcommand1ÁË£¬°ÑCommand1_Click»»³É ÐÂÃû×Ö_Click£»¶þ¡¢ADO¶ÔÏóûÒýÓ×—ÒýÓ÷½·¨£¬¹¤³Ì->ÒýÓÃ->¹´Ñ¡Micros
Ïà¹ØÎÊ´ð£º
vbÖÐ ÏÖÔÚÎÒÒª°ÑÊý¾Ý¿âÀï´æ´¢µÄÒ»¸ö¸½¼þµÄÄÚÈÝÌæ»»ÁË£¬Ôõô×ö£¬Ö»ÊÇÌæ»»ÎÒÖ¸¶¨µÄλÖ㬲»ÊÇÈ«²¿Ìæ»» Ç뽫ÎÊÌâ˵Ã÷°×£¬´æ´¢×ֶθñʽ£¬Èç¹ûÊÇBinary¸ñʽµÄ±È½ÏÂé·³£¬Èç¹ûÊÇ×Ö´®£¬Ö±½ÓÌæ»»¡£×îºÃ²»Òª½øÐÐÖ¸¶¨Î»ÖÃÌæ»»¡ ......
¸÷λ¸ßÊÖ£¬Ð¡µÜ×î½üÅöµ½Ò»¸öÎÊÌ⣺ÔÏÈдµÄ³ÌÐò´ó¸ÅµÄ˼·ÊÇ£ºÊ×ÏÈwebbrowser´ò¿ªÍøÖ·£¬ÍøÖ·ÏÔʾºó£¬µã»÷ÍøÖ·ÉϵÄijһ¸öÁ¬½Ó£¬µ±webbrowser¼ì²âµ½ÍøÖ·ÒѾÁ¬½Óµ½ÏëÒªµÄµØÖ·Ê±ºò¾Í¿ªÊ¼ÏÂÔØÎļþ£¬µ±ÓÃIE6µÄʱºòÏÂÔ ......
ÓÃVB±à³Ì¶ÁÈ¡¶ÌÐÅ,µÃµ½Ò»´ó¶Ñunicode±àÂë,Çë½ÌÈçºÎת»»³ÉÎı¾ ÀýÈç:¶ÁÈ¡¶ÌÐźó(»ªÎª900C»òTC35i),´®¿ÚµÃµ½ÈçÏÂÊý¾Ý: +CMGL: 17,"REC UNREAD","8615007557713",,"10/03/30,09:37:15+32&qu ......
Çó¸övbÖеÄsqlÓï¾äµÄд·¨£¬´ÎsqlÓï¾äµÄÓ÷¨ÊÇ·ÖÒ³³ÌÐò ÎÒдµÄÈçÏ£ºÆäÖÐAÊÇÓÃÀ´½ÓÊÕÿҳÏÔʾµÄ¼Ç¼µÄÌõÊý£¬BÊÇÓÃÀ´½ÓÊÕÏÔʾµÄµ±Ç°µÄÒ³Ãæ. sqltext="select top A * from log where id not in(select top ( ......
СµÜÓÃVBµ÷EXCEL×÷ͼ objExlApp.Workbooks.Add objExlApp.Charts.Add objExlApp.ActiveChart.ChartType = xlLine objExlApp.ActiveChart.HasLegend = True objExlApp. ......