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

ÓйØvbµÄÎÊÌâ - VB / »ù´¡Àà

Êý¾Ý¿âÃ²ËÆÒѾ­Á¬½ÓÉÏÁËvb£¬£¬¿ÉÊÇΪʲôÊý¾Ý¿âÉϵÄÊý¾Ý²»ÄÜÏÔʾÔÚ¿ò±íÖÐÄ󣿣¿£¿
¾ßÌåµÄ´úÂ룿


ÎÞÂëÎÞÕæÏ࣡

Äã°ÑÀºÇò±§ÔÚ»³À¾ÍÄÜԶͶµÃ3·Ö£¿

Âé·³¸÷λ´óϺÁ˰¡¡£¡£¡£
Private Sub Comm1_Click()
  Dim sqltxt As String
  sqltxt = "delete tmpksb"
  Set conn = New ADODB.Connection
  conn.ConnectionString = "dsn=KS;uid=MICROSOF-45B405;pwd=;"
  conn.Open
  conn.Execute sqltxt
  If condstr = "" Then
  sqltxt = "insert into tmpksb select * from ksb "
  Else
  sqltxt = "insert into tmpksb select * from ksb where " + condstr
  End If
  conn.Execute sqltxt
  conn.Close
  DataEnvironment1.Command1 '´ò¿ªÊý¾ÝÔ´
  DataEnvironment1.rsCommand1.Requery 'Ë¢ÐÂ
  DataReport1.Show vbModal
  DataEnvironment1.rsCommand1.Close
End Sub

´úÂë¡£¡£¡£¡£´úÂë¡£¡£¡£¡£ÄÃÀ´ÎÒÃÇ¿´Ï¡£¡£¡£

Private Sub Comm1_Click() 
  Dim sqltxt As String 
  sqltxt = "delete tmpksb" 
  Set conn = New ADODB.Connection 
  conn.ConnectionString = "dsn=KS;uid=MICROSOF-45B405;pwd=;" 
  conn.Open 
  conn.Execute sqltxt
  debug.print condstr '¿´Êä³öʲô
  If condstr = "" Then 


Ïà¹ØÎÊ´ð£º

vb²åÈëÊý¾Ý¿âÖØ¸´ÖµÎÊÌâ

ÔÚvbÖÐÔõôÅжϣ¬²åÈëµ½Êý¾Ý¿âÖеÄÖµÊÇÖØ¸´µÄ£¬±¾È˲ŸսӴ¥VBÓïÑÔ£¬ÉõÊÇÓÐºÃ¶àµØ·½»¹²»¶®£¬»¹Çë¸÷λ´óÏÀÃǸø³ö´úÂ룬ллÁËѽ£¡£¡£¡
²åÈë֮ǰselectһϰ¢¡£
»òÕßдһ¸ö×éºÏSQL²åÈëÓï¾ä£¬ÀýÈç
IF not Exist(
& ......

ÇóÖú£ºVBµ÷Óö¯Ì¬¿âÎÊÌâ - VB / »ù´¡Àà

¸÷λ´óϺ£º
  ÎÒÊǸÕѧVB£¬ÏÖÔÚÏëÓÃVBµ÷ÓÃÒ»¸ö¶¯Ì¬¿â£¬¶¯Ì¬¿âÀïÃæÓкܶຯÊý¡£ÎÒÖªµÀʹÓÃVBµ÷Óö¯Ì¬¿âµ÷Óú¯Êý£¬ÐèÒª½«Òªµ÷Óõĺ¯ÊýÔÚ³ÌÐòÖÐÉùÃ÷¼´¿É£¬µ«ÊÇÀïÃæÓкܶຯÊý£¬²»»áÿһ¸öº¯Êý¶¼ÒªÉùÃ÷°É¡£Çë¸ ......

Çóvb´óϺ¿´Ò»Ï°¡£¡£¡£¡

Private Sub Form_Load()
  recs = Adodc1.Recordset.RecordCount 'Çóµ±Ç°¼Ç¼Êý
  If recs > 0 Then 'ÒÑÓп¼Éú
  Adodc1.Recordset.MoveLast 'ÒÆµ½×îºóÒ»Ìõ¼Ç¼
  num = V ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ