想把数据库表的东东显示到msflexgrid中,代码如下:
Private Sub Command7_Click()
Dim objconn As ADODB.Connection
Dim objrst As ADODB.Recordset
Dim sql As String
Set objrst = New ADODB.Recordset
Set objconn = New ADODB.Connection
objconn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ddd"
objconn.Open
sql = "select dianchang from machine "
With objrst
.Source = sql
.ActiveConnection = objconn
.LockType = adLockPessimistic
.CursorType = adOpenKeyset
.CursorLocation = adUseClient
.Open
End With
Set MSFlexGrid1.DataSource = objrst(出错地方,数据集objrst=nothing)
objrst.Close
End Sub
运行时,提示“对象变量或WITH 块未定义”,这是为什么,数据库没连上?帮帮忙谢谢!
Private Sub Command7_Click()
Dim objconn As ADODB.Connection
Dim objrst As ADODB.Recordset
Dim sql As String
Set objrst = New ADODB.Recordset
Set objconn = New ADODB.Connection
objconn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ddd"
objconn.Open
sql = "select dianchang from machine "
With objrst
.Source = sql
.ActiveConnection = objconn
.LockType = adLockPessimistic
.CursorType = adOpenKeyset
.CursorLocation = adUseClient
.Open
End With
Set MSFlexGrid1.DataSource = objrst(出错地方,数据集objrst=nothing)
objrst.Close
End Sub
运行时,提示“对象变量或WITH 块未定义”,这是为什么,数据库没连上?帮帮忙谢谢!
解决方案 »
- 有关text控件的sellength和selstart
- 请问WebBrowser控件把网页缓存在哪里了? [
- 求VB6的DataRepeater控件使用源码例子几个
- 大侠请教 一下!pdg是什么文件,应用什么来打开?*.dat用什么可以打开?谢了!
- 通过modem拨号,连接对方的机器。 高分相送
- vb+vfp的简单问题?急,谢谢!
- vb+access2000的图片存取方法有那些?具体例子?50想送
- 变量在赋值前被使用??
- SOS!SOS!SOS!!SOS! 高手请进 SQL Server 存储过程返回结果集
- 各位大神,vb7与vb6什么区别?优点在哪里?vb6前一段不是风闻已经死亡了?(我是delphi阵营叛逃过来的)
- 如何在vb的控件中显示韩文?
- 吐血的sql语句
Dim i As Integer
If checkRct = True Then '不用看这个,这是我自己写的判断是否为空集合
Exit Function
End If
rctdata.MoveFirst '这个rctdata是ADODB.Recordset
With ProJFrm
While (rctdata.EOF = False)
.MSFlexGrid1.AddItem (Empty)
For i = 0 To rctdata.Fields.Count - 1
.MSFlexGrid1.Col = i
.MSFlexGrid1.Text = rctdata.Fields(i).Value
Next
rctdata.MoveNext
.MSFlexGrid1.Row = .MSFlexGrid1.Row + 1
Wend
End With
getDataTo = True
End Function
这个函数里没有如何连接,也没有如何获得数据集,只是将数据集中的数据读到MSF控件上.
是可以的,我就是这么写的
换种游标试试,换成静态的
Public Sub setFG(strsql As String, myVSFG As VSFlexGrid, sCon As String) '将SQl结果显示在GRID上
Dim rs As New ADODB.Recordset
Dim con As New ADODB.Connection con.ConnectionString = sCon
con.Open
rs.Open strsql, con, adOpenStatic
Set myVSFG.DataSource = rs
Set rs = Nothing
con.close
End Sub