Rs.CursorLocation = adUseClientCN.Execute "update sk200212.dbf set sksj='08:27' where zgbh='028032' "Rs.Open "Select * From sk200212.dbf", CN, , , adCmdTextSet DataGrid1.DataSource = Rs End Sub
Dim CN As New ADODB.Connection Dim Rs As New ADODB.Recordset
Dim xx As New ADODB.Connection xx.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Borland\Shared\Data\;Extended Properties=dbase 5.0;Persist Security Info=False" xx.Execute "update T set F = 'sadsad' where 1 = 0"
你首先要在VB菜单中: “工程”-->“引用”-->“Microsoft AxtiveX Data Objects 2.1 Library” 示例:Private Sub Form_Load() Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim cnstr As String cnstr = "Driver={Microsoft Visual FoxPro Driver};" & _ "SourceType=DBF;" & _ "SourceDB=;" & app.path & "\data" & _ "Exclusive=No" cn.CursorLocation = adUseClient cn.Open cnstr xx.Execute "UPDATE XXX表 SET 字段名 = 新值 WHERE 字段名=条件" rs.Open "select * from XXX.DBF", cn, adOpenKeyset, adLockBatchOptimistic set datagrid1.datasource=rs datagrid1.refresh End Sub
CN.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
"DriverID=277;" & _
"Dbq=C:\ST1000\DATA;"
Rs.CursorLocation = adUseClientCN.Execute "update sk200212.dbf set sksj='08:27' where zgbh='028032' "Rs.Open "Select * From sk200212.dbf", CN, , , adCmdTextSet DataGrid1.DataSource = Rs
End Sub
Dim Rs As New ADODB.Recordset
xx.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Borland\Shared\Data\;Extended Properties=dbase 5.0;Persist Security Info=False"
xx.Execute "update T set F = 'sadsad' where 1 = 0"
你首先要在VB菜单中:
“工程”-->“引用”-->“Microsoft AxtiveX Data Objects 2.1 Library”
示例:Private Sub Form_Load()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim cnstr As String
cnstr = "Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBF;" & _
"SourceDB=;" & app.path & "\data" & _
"Exclusive=No"
cn.CursorLocation = adUseClient
cn.Open cnstr
xx.Execute "UPDATE XXX表 SET 字段名 = 新值 WHERE 字段名=条件"
rs.Open "select * from XXX.DBF", cn, adOpenKeyset, adLockBatchOptimistic
set datagrid1.datasource=rs
datagrid1.refresh
End Sub