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

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ÖÐʹÓÃWScriptµ÷ÓÃÍⲿÃüÁî - VB / »ù´¡Àà

ÔÚÏÂÊÇvbµÄÐÂÊÖ£¬Ïëд¶Î³ÌÐò£¬ÔÚvbÖУ¬Ê¹ÓÃwscriptµ÷ÓÃһЩÍⲿµÄÃüÁµ«ÊdzÌÐòÖ´ÐÐÒ»Ö±ÓдíÎó£¬Çë¸÷λ¸ßÊÖ°ïæ½â´ðÏ£¬Ð»Ð»¡£
´úÂëÈçÏ£º
VB code:

Private Function getFile_CMD(filename, filepath) As Bo ......

°ïÎҸĸÄÕâVBÌâ - VB / »ù´¡Àà

°ïÎÒ¸Ä¸Ä ÎÒ×ܾõµÃÓÐÎÊÌâ
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£¬ÏÖÔÚÏëÓÃVBµ÷ÓÃÒ»¸ö¶¯Ì¬¿â£¬¶¯Ì¬¿âÀïÃæÓкܶຯÊý¡£ÎÒÖªµÀʹÓÃVBµ÷Óö¯Ì¬¿âµ÷Óú¯Êý£¬ÐèÒª½«Òªµ÷Óõĺ¯ÊýÔÚ³ÌÐòÖÐÉùÃ÷¼´¿É£¬µ«ÊÇÀïÃæÓкܶຯÊý£¬²»»áÿһ¸öº¯Êý¶¼ÒªÉùÃ÷°É¡£Çë¸ ......

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

Private Sub Form_Load()
  recs = Adodc1.Recordset.RecordCount 'Çóµ±Ç°¼Ç¼Êý
  If recs > 0 Then 'ÒÑÓп¼Éú
  Adodc1.Recordset.MoveLast 'ÒÆµ½×îºóÒ»Ìõ¼Ç¼
  num = V ......

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

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

ÎÞÂëÎÞÕæÏ࣡

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

Âé·³¸÷λ´óϺÁ˰¡¡£¡£¡£
Private Sub Comm1_Click()
& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ