Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

»¹ÊÇVBºÍSQLµÄÎÊÌâ

ÎÒÓÃVB¶ÁÈ¡WinCCµÄ¹ý³Ì±äÁ¿A£¨¶þ½øÖÆ£©µ½text16 ÖÐ £¬Ö»Òªtext6ÖÐΪ1£¬¾ÍÏòSQLÊý¾Ý¿â×öÒ»Ìõ¼Ç¼¡£
ÏÂÃæµÄ´úÂëÊǵ±Ìõ¼þÂú×ãʱ£¬Óð´Å¥command1Ìí¼Ó¼Ç¼µÄ£¨Õâ¸öÒѾ­ÊµÏÖ£©¡£
Private Sub command1_click()
If Text16.Text = "1" Then
Adodc1.Recordset.MoveLast
Adodc1.Recordset.AddNew
Text1.Text = Text19.Text  ¡®SQL×Ö¶Î1
Text2.Text = Text5.Text    ¡®SQL×Ö¶Î2
Text3.Text = Text17.Text  ¡®SQL×Ö¶Î3
Text20.Text = Date        ¡®SQL×Ö¶Î4
Text4.Text = Time        ¡®SQL×Ö¶Î5
Adodc1.Recordset.UpdateBatch
Else
End If
End Sub

ÎÒµÄÎÊÌâÊÇ£¬ÔõÑùд£¬¿ÉÒÔÈÃVB¸ù¾Ý±äÁ¿AΪ1ʱ×Ô¶¯×öÒ»Ìõ¼Ç¼¡£ÉÏÃæµÄÌõ¼þÓï¾ä·Åµ½Ê²Ã´ÑùµÄ¹ý³Ì»ò·½·¨ÖÐÈ¥£¿

Ìí¼Ótimer¿Ø¼þ£¬È»ºóÈçÏ£º
VB code:

Private Sub Form_Load()
Timer1.Enabled = 1000
End Sub

Private Sub Timer1_Timer()
Timer1.Enabled = False
If Text16.Text = "1" Then
Adodc1.Recordset.MoveLast
Adodc1.Recordset.AddNew
Text1.Text = Text19.Text 'SQL×Ö¶Î1
Text2.Text = Text5.Text 'SQL×Ö¶Î2
Text3.Text = Text17.Text 'SQL×Ö¶Î3
Text20.Text = Date 'SQL×Ö¶Î4
Text4.Text = Time 'SQL×Ö¶Î5
Adodc1.Recordset.UpdateBatch
Else
End If
Timer1.Enabled = True
E


Ïà¹ØÎÊ´ð£º

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

SELECT a.tguildname ,SUM(a.ct) +  if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT  tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......

VBÈçºÎ×èֹij³ÌÐòÔËÐС££¿

±ÈÈç½ø³Ì¼ÓÔØÐµijÌÐò¡£

ÔÚÆäÔËÐÐ֮ǰ×èÖ¹¡£

È»ºóÔÊÐíºó·ÅÐС£


±ÈÈç³ÌÐòÖ÷Îļþ·¾¶ÊÇc:\test\test.exe£¬½¨Á¢ÄÚÈÝÈÎÒâµÄÎļþc:\test\test.exe.manifest¡£

¾ÍÊDz»ÖªµÀ³ÌÐòÎļþ·¾¶¡£

ÉèÖ ......

Çó½ÌÏÂVBÈçºÎ¸øD3DÓÎϷдÆÁ - VB / API

ÏëÔÚwarcraft3Àï½øÐÐдÆÁ²Ù×÷¡¾Èç¶Ôսƽ̨ÖеÄʤ¸ºÌáʾÐÅÏ¢¡¿£¬Ð§¹û¾ÍÏñÓÎϷƽ̨ÖÐÒ»Ñù£¬ÎÒÊÔ¹ýÔÚÒ»´°¿ÚÖÐдÈëÎÄ×Ö£¬È»ºóÒ»Ö±Èô°¿ÚÇ¿ÖÆ×îǰ£¬ËäÈ»ÄÜʵÏÖÎÄ×ÖÏÔʾ£¬µ«ÊÇÎÄ×ֻ᲻¶ÏÉÁ˸£¬¶øÇÒÓв»È·¶¨BUG£¬Í¨¹ýÂÛ̳ËÑ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ