引用 ADO 2.6 Library
提示找不到提供者,在Form_Load()中还需写相关代码吗?
Private Sub ShapedRecordset()
Dim cn As New ADODB.Connection
Dim rsParent As New ADODB.Recordset
Dim hflxResults As MSHFlexGrid
cn.Provider = "MSDateShape"
cn.Open "DATA PROVIDER=SQLOLEDB;SERVER=16.45.65.212;UID=sa;PWD=123;DATABASE=pubs"
rsParent.StayInSync = False
rsParent.Open "SHAPE {select stores.stor_id,stor_name,city,state from stores}Append ({select sales.stor_id,ord_num from sales} RELATE stor_id TO stor_id)", cn
Set hflxResults.DataSource = rsParent
Set rsParent = Nothing
Set cn = Nothing
End Sub
顺便问一下,数据库中的字段名为英文字符,如何让网格中显示的字段名为汉字啊?
提示找不到提供者,在Form_Load()中还需写相关代码吗?
Private Sub ShapedRecordset()
Dim cn As New ADODB.Connection
Dim rsParent As New ADODB.Recordset
Dim hflxResults As MSHFlexGrid
cn.Provider = "MSDateShape"
cn.Open "DATA PROVIDER=SQLOLEDB;SERVER=16.45.65.212;UID=sa;PWD=123;DATABASE=pubs"
rsParent.StayInSync = False
rsParent.Open "SHAPE {select stores.stor_id,stor_name,city,state from stores}Append ({select sales.stor_id,ord_num from sales} RELATE stor_id TO stor_id)", cn
Set hflxResults.DataSource = rsParent
Set rsParent = Nothing
Set cn = Nothing
End Sub
顺便问一下,数据库中的字段名为英文字符,如何让网格中显示的字段名为汉字啊?
解决方案 »
- vb中如何
- 谁能帮我翻译或解释一下这段代码
- IStream、IPersistStream两个类需要引用什么库
- 请问为什么ACCESS建立的记录集有时记录数不准确?
- 怎样用一段代码就可以监测到打印机
- 请教高手:vb自带datareport有没有办法这样输出???
- 你好,来得分吧!
- 我的窗体一最大化,窗体上的控件的位置,停留在原来的位置上.怎能随着最大化而使控件的位置也跟着变.
- 怎样将整数型的变量变为"####.####",如,"1200",变为"1200.000",小数不变 ?
- 劳驾各位大哥帮我做一道题目(内详)
- 能不能给我一个用VB读取注册表DWORD值的代码(最简单的)谢谢!
- 关于称不同重量小球的算法?
————————————---------------
1 ID 1 DG 1 NAME 1 OLD 1
---------------------------------------
1 101 1 上海 1 张飞 1 21 1
--------------------
1 1 1 王奇 1 22 1
--------------------
1 1 1 康建 1 65 1
---------------------------------------
1 102 1 北京 1 李响 1 35 1
--------------------
1 1 1 张迈 1 21 1
---------------------------------------
Me.MSHFlexGrid1.MergeCells = flexMergeFree
Me.MSHFlexGrid1.MergeCol(1) = True
MergeCol()括号内的为需要合并的列
显示汉字表头:
rsParent.Open "SHAPE {select stores.stor_id,stor_name as 汉字A,city as 汉字B,state as 汉字C from stores}