1,216
社区成员
发帖
与我相关
我的任务
分享
'修改一个小问题
Dim rst As New ADODB.Recordset
Dim cnn As New ADODB.Connection
cnn1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
dataBaseName1 & ";Persist Security Info=False"
cnn1.CursorLocation = adUseClient
cnn1.Open
Dim sql As String
sql = "SELECT * FROM ip"'这可以跟条件,现在是所有数据
rst.Open sql, cnn, adOpenStatic, adLockPessimistic
rst.MoveFirst'移动到第一条记录
rst(0)=50'编辑第一个字段的数据
rst(1)=35'编辑第二个字段的数据
rst.update'更新数据库
rst.close
cnn.close
'修改一个小问题
Dim rst As New ADODB.Recordset
Dim cnn As New ADODB.Connection
cnn1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
dataBaseName1 & ";Persist Security Info=False"
cnn1.CursorLocation = adUseClient
cnn1.Open
Dim sql As String
sql = "SELECT * FROM ip"'这可以跟条件,现在是所有数据
rst.Open sql, cnn, adOpenStatic, adLockPessimistic
rst.MoveFirst'移动到第一条记录
rst(0)=50'编辑第一个字段的数据
rst(1)=35'编辑第二个字段的数据
rst.update'更新数据库
rst.close
cnn.close
Dim rst As New ADODB.Recordset
Dim cnn As New ADODB.Connection
cnn1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
dataBaseName1 & ";Persist Security Info=False"
cnn1.CursorLocation = adUseClient
cnn1.Open
Dim sql As String
sql = "SELECT * FROM ip"'这可以跟条件,现在是所有数据
rst.Open mySql, cnn, adOpenStatic, adLockPessimistic
rst.MoveFirst'移动到第一条记录
rst(0)=50'编辑第一个字段的数据
rst(1)=35'编辑第二个字段的数据
rst.update'更新数据库
rst.close
cnn.close
Sub Main()
Dim rs As ADODB.Recordset
Set rs = New Recordset
rs.Fields.Append "ID", adInteger
rs.Fields.Append "Name", adVarChar, 10
rs.Open
rs.AddNew
rs!ID = 1
rs!Name = "张三"
rs.Update
rs.AddNew
rs!ID = 2
rs!Name = "李四"
rs.Update
rs.MoveFirst
Debug.Print rs.GetString()
End Sub