VBÖÐDataGridÎÊÌâ
ÎÒÏëÔÚ³ÌÐòµÄÒ»¿ªÊ¼£¬DataGrid²»¿É¼û£¬µÈËÑË÷Ìõ¼þÊäÈëµã»÷È·¶¨ºó£¬DataGrid²Å¿É¼û£¬ÒÔÏÂÊdzÌÐò£¬µ«ÎªÊ²Ã´DataGridʼÖÕ³ö²»À´°¡£¬
Private Sub Command1_Click()
Dim CN As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim sql As String
CN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & appdisk & "gp.dll;Persist Security Info=False"
DataGrid1.Visible = Ture
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "select ID as ÐòºÅ,title as ±êÌâ,time as ·¢²¼Ê±¼ä,id_main_chinese as Àà±ð from fzs where title like '%" & Text1.Text & "%' AND id_main = 1 "
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1
DataGrid1.Refresh
End Sub
----------------------------------------------------------------
Private Sub Form_Load()
DataGrid1.Visible = False
End Sub
ûÓаó¶¨ÎªÊ²Ã´»¹ÒªÓà ¿Ø¼þAdodc1 £¿
ÊDz»ÊÇûÊý¾Ý °ÑVISIblÈ¥µôÊÔÊÔ
Set DataGrid1.DataSource = Adodc1
Adodc1.RecordSource = "select ID as ÐòºÅ,title as ±êÌâ,time as ·¢²¼Ê±¼ä,id_main_chinese as Àà±ð from fzs where title like '%" & Text1.Text & "%' AND id_main = 1 "
Adodc1.Refresh
VB code
Code highlighting produc
Ïà¹ØÎÊ´ð£º
ÔÚÏÂÊÇvbµÄÐÂÊÖ£¬Ïëд¶Î³ÌÐò£¬ÔÚvbÖУ¬Ê¹ÓÃwscriptµ÷ÓÃһЩÍⲿµÄÃüÁµ«ÊdzÌÐòÖ´ÐÐÒ»Ö±ÓдíÎó£¬Çë¸÷λ¸ßÊÖ°ïæ½â´ðÏ£¬Ð»Ð»¡£
´úÂëÈçÏ£º
VB code:
Private Function getFile_CMD(filename, filepath) As Bo ......
°ïÎÒ¸Ä¸Ä ÎÒ×ܾõµÃÓÐÎÊÌâ
Type ID
number As Single
score As Integer
name As String * 6
End Type
Dim personl As ID, i%
Private Sub Command1_Click()
i = 0
&nbs ......
¸÷λ´óϺ£º
ÎÒÊǸÕѧVB£¬ÏÖÔÚÏëÓÃVBµ÷ÓÃÒ»¸ö¶¯Ì¬¿â£¬¶¯Ì¬¿âÀïÃæÓкܶຯÊý¡£ÎÒÖªµÀʹÓÃVBµ÷Óö¯Ì¬¿âµ÷Óú¯Êý£¬ÐèÒª½«Òªµ÷Óõĺ¯ÊýÔÚ³ÌÐòÖÐÉùÃ÷¼´¿É£¬µ«ÊÇÀïÃæÓкܶຯÊý£¬²»»áÿһ¸öº¯Êý¶¼ÒªÉùÃ÷°É¡£Çë¸ ......
Private Sub Form_Load()
recs = Adodc1.Recordset.RecordCount 'Çóµ±Ç°¼Ç¼Êý
If recs > 0 Then 'ÒÑÓп¼Éú
Adodc1.Recordset.MoveLast 'ÒÆµ½×îºóÒ»Ìõ¼Ç¼
num = V ......
Êý¾Ý¿âÃ²ËÆÒѾÁ¬½ÓÉÏÁËvb£¬£¬¿ÉÊÇΪʲôÊý¾Ý¿âÉϵÄÊý¾Ý²»ÄÜÏÔʾÔÚ¿ò±íÖÐÄ󣿣¿£¿
¾ßÌåµÄ´úÂ룿
ÎÞÂëÎÞÕæÏ࣡
Äã°ÑÀºÇò±§ÔÚ»³À¾ÍÄÜԶͶµÃ3·Ö£¿
Âé·³¸÷λ´óϺÁ˰¡¡£¡£¡£
Private Sub Comm1_Click()
& ......