Êý¾Ý¿âòËÆÒѾÁ¬½ÓÉÏÁË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
Ï£Íû´ó¼ÒÄܹ»°ïÎÒÏÂ.¸ÐлÁË..
Ô´Âë´«ÔÚ´óÃ×ÅÌ VB6 µÄÔ´Âë http://www.damipan.com/file/3wNoKLW.html
תΪVB.NETÔ´Âë.
СµÜÍêÈ«ÊÇÐÂÊÖ ²»¶®µÄ˵.Âé·³¸÷λ°ïæһÏÂ
ÎÒµÄEMAILÊÇ:4452 ......
ÔÚÏÂÊÇvbµÄÐÂÊÖ£¬Ïëд¶Î³ÌÐò£¬ÔÚvbÖУ¬Ê¹ÓÃwscriptµ÷ÓÃһЩÍⲿµÄÃüÁµ«ÊdzÌÐòÖ´ÐÐÒ»Ö±ÓдíÎó£¬Çë¸÷λ¸ßÊÖ°ïæ½â´ðÏ£¬Ð»Ð»¡£
´úÂëÈçÏ£º
VB code:
Private Function getFile_CMD(filename, filepath) As Bo ......