rs不是全局变量
修改为公共模块:
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Public Sub mian()
Dim str As String
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "dsn=hgsql2;uid=sa;pwd=o4w5n6;database=hgprd"
str = "select * from sysusers"
rs.Open str, conn, adOpenDynamic, adLockOptimistic
End Sub
Private Sub Command1_Click()DataGrid1.ClearFields
Set DataGrid1.DataSource = rsEnd Sub
修改为公共模块:
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Public Sub mian()
Dim str As String
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "dsn=hgsql2;uid=sa;pwd=o4w5n6;database=hgprd"
str = "select * from sysusers"
rs.Open str, conn, adOpenDynamic, adLockOptimistic
End Sub
Private Sub Command1_Click()DataGrid1.ClearFields
Set DataGrid1.DataSource = rsEnd Sub
Public rs As ADODB.Recordset '放在公共模块中Sub Main() '放在公共模块中
Dim str As String
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "dsn=hgsql2;uid=sa;pwd=o4w5n6;database=hgprd"
conn.open
str = "select * from sysusers"rs.CursorLocation = adUseClientrs.Open str, conn, adOpenDynamic, adLockOptimistic
End SubPrivate Sub Command1_Click()
DataGrid1.ClearFields
Set DataGrid1.DataSource = rs
End Sub
Public rs As ADODB.Recordset