datagrid不显示,为什么?
Dim conn As New adodb.Connection
Dim rs As New adodb.Recordset
Dim sql As String
Private Sub Form_Load()
conn.Open connstring
sql = "select * from [user]"
rs.Open sql, conn, 1, 1
Set DataGrid1.DataSource = rs
End Sub
Private Sub Form_Unload(Cancel As Integer)
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
End Sub
datagrid数据库内容显示不出来,为什么?
注:connstring为模块内连接字符串