Private Sub Command3_Click()
Set cn = New ADODB.Connection
cn.CursorLocation = adUseClient
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=yuancheng;Data Source=YUANCHENG"
Set mrc = New ADODB.Recordset
Set mrc = cn.Execute("select * from yuanliaocaigou")
mrc.MoveNext
If mrc.EOF Then
mrc.MoveFirst
End If
Set cn = New ADODB.Connection
cn.CursorLocation = adUseClient
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=yuancheng;Data Source=YUANCHENG"
Set mrc = New ADODB.Recordset
Set mrc = cn.Execute("select * from yuanliaocaigou")
mrc.MoveNext
If mrc.EOF Then
mrc.MoveFirst
End If
这样打开应该能上能下了
rs.Open str, con, adOpenDynamic, adLockOptimistic
cn.CursorLocation = adUseClient
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=yuancheng;Data Source=YUANCHENG"
Set mrc = New ADODB.Recordset
mrc.Open "select * from yuanliaocaigou", cn, adOpenDynamic, adLockOptimistic
mrc.MoveNext
If mrc.EOF Then
mrc.MoveFirst
End If
这样好象也不行!
if mrc.eof then msgbox "1111":exit sub
mrc.movefist
mrc.movenext
Set cn = New ADODB.Connection
cn.CursorLocation = adUseClient
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=yuancheng;Data Source=YUANCHENG"
Set mrc = New ADODB.Recordset
mrc.Open "select * from yuanliaocaigou", cn, adOpenDynamic, adLockOptimistic
mrc.MoveNext
If mrc.EOF Then
mrc.MoveFirst
End If那我该怎么改?
.MoveFirst
Else
.MoveNext
试试
cn.CursorLocation = adUseClient
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=yuancheng;Data Source=YUANCHENG"
Set mrc = New ADODB.Recordset
mrc.Open "select * from yuanliaocaigou", cn, adOpenStatic, adLockReadOnly
mrc.MoveNext
If mrc.EOF Then
mrc.MoveFirst
End If
Set cn = New ADODB.Connection
cn.CursorLocation = adUseClient
cn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=yuancheng;Data Source=YUANCHENG"
Set mrc = New ADODB.Recordset
mrc.Open "select * from yuanliaocaigou", cn, adOpenStatic, adLockReadOnly
If mrc.EOF Then
MsgBox "没有要过帐的记录!", vbOKOnly, "信息提示"
Else
Text(0).Text = mrc.Fields(0)
Text(1).Text = mrc.Fields(1)
Text(2).Text = mrc.Fields(2)
Text(3).Text = mrc.Fields(3)
Text(4).Text = mrc.Fields(4)
Text(5).Text = mrc.Fields(5)
End If
这样子我还是不行!