Question

vb中删除所有记录

我是在VB中用ADO控件连接的ACCESS数据库的，现在我想在窗体关闭时删除临时表中的所有记录，请问我该怎么做啊？请讲的详细点，先谢过了！

Answer 1

Dim coon As New ADODB.Connection
Dim rs As New ADODB.Recordset

Private Sub Form_Unload(Cancel As Integer)

rs.MoveFirst

Do While Not rs.EOF
rs.Delete
rs.Update

rs.MoveNext
Loop

End Sub

Answer 2

Dim conn As New ADODB.Connection
conn已连接，且biao1 为表名，则执行下面语句
Conn.Execute "delete from biao1"

Answer 3

'已建立conn连接的情况下
Private Sub Form_Unload(Cancel As Integer)
Conn.Execute "Delete * From 表名"
End Sub