Private Sub Command1_Click()
Dim str As String
Dim conn As Connection
Dim rst As Recordset
Set conn = New Connection
Set rst = New Recordset
sdbname = App.Path + "\net1.mdb"
sPassword = ""
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Persist Security Info=False;" & "Data Source=" & sdbname & ";" & "Jet OLEDB:Database Password=" & sPassword & ";"
str = "Select * from ask"
rst.Open str, conn, 3, 1
Set DG1.DataSource = rst
DG1.Refresh
End Sub当点击按钮的时datagrid不显示任何数据库信息,这是为什么呢?请各位多多帮忙!
Dim str As String
Dim conn As Connection
Dim rst As Recordset
Set conn = New Connection
Set rst = New Recordset
sdbname = App.Path + "\net1.mdb"
sPassword = ""
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Persist Security Info=False;" & "Data Source=" & sdbname & ";" & "Jet OLEDB:Database Password=" & sPassword & ";"
str = "Select * from ask"
rst.Open str, conn, 3, 1
Set DG1.DataSource = rst
DG1.Refresh
End Sub当点击按钮的时datagrid不显示任何数据库信息,这是为什么呢?请各位多多帮忙!
解决方案 »
- NullReferenceException???
- 关于VB中WinSock的问题
- 求《MIS系统开发与应用 : Visual Basic+SQL Server版》附光盘内容下载
- 请帮我看看,小问题(急)
- 我自己做了一个控件,在其中定义了一个方法,怎么老是出现错误,大家帮忙看看 谢谢了!!
- 如何使MSFlexGrid控件记录递增后,下一行能明显的被看到,即可以颜色不同或有明显边框!!
- 请教各位朋友 谢谢大家了
- 如何动态存取数据库目录
- 如果你来写一本VB的入门书,你会怎么写?
- 谁会“混合生产排期”的算法,谁能解决,我将把我所有的分全给你!1000分。
- 菜鸟问题……为什么我在vb明明执行表单b,vb却老是要跑去执行表单a呢?
- 从文本文件中读取十六进制数据并转化为十进制在写入文本文件中
rst.Open str, conn, 3, 1
rst.Open str, conn, 3, 1