关于数据更新的问题!
我用ADO把数据读出来显示在Listview里面!程序如下:
Private Sub Form_Load()
Dim item As ListItem
Dim conn As New ADODB.Connection
conn.open "driver={Microsoft Access driver (*.mdb)};dbq=" & App.Path & "\data.mdb"
Dim rs As New ADODB.Recordset
sql = "select * from user"
rs.open sql, conn, 1, 1
Do While Not rs.EOF
Set item = ListView1.ListItems.Add(, , rs("user_card"))
item.SubItems(1) = rs("user_name")
If Not rs("user_tel") = "" Then
item.SubItems(2) = rs("user_tel")
End If
If Not rs("user_address") = "" Then
item.SubItems(3) = rs("user_address")
End If
If Not rs("addtime") = "" Then
item.SubItems(4) = rs("addtime")
End If
rs.movenext
Loop
End Sub
可当数据库更新的时候Listview 里的还是不会吧,我在窗体中添加了一个Button 写了以下代码:
Private Sub Command2_Click()
Form1.Refresh
End Sub
还是没有,哪们高手请帮帮我!