我想用datareport 做一个分层的报表,又不想用其他的引擎(access数据库),有没有其他的解决方法?
解决方案 »
- 同时删除mshflexgrid中的多行数据
- 怎么用vb调用动态连接函数,譬如SMEIDll.dll????
- ●【Ψ】〓【★免费CSDN论坛浏览器★】〓【Ψ】●
- 如何实现条形码的打印和扫描?急!!!给分不吝啬。
- vb程序改成Active组件(高分)
- VB是不是要完蛋了,MYGOOD ,我可爱的VB?
- 在VB中怎样使用CoCreateInstanceEX 指定用户名和密码访问远程计算机组件
- 各位:哪儿有datagrid的例子
- 高分求教!!!!如何在一个image中显示图像的一部分?
- 小白请教:如何将多个EXCEL指定单元格汇总到ACCESS
- 在VB代码编辑器中,如何把“替换”状态变回“插入”状态...?
- 请问怎样计算某个字段不重复的记录数?
Public adoRs As New ADODB.RecordsetPublic Function Connection() As Integer
Dim sCon As String
On Error GoTo Errs
sCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\db1.mdb"
adoCn.CursorLocation = adUseClient
adoCn.Open sCon
Connection = 0
Exit Function
Errs:
Connection = -1
End FunctionPublic Function DisConnection() As Integer
On Error GoTo Errs
If adoCn.State = adStateOpen Then adoCn.Close
Set adoCn = Nothing
DisConnection = 0
Exit Function
Errs:
DisConnection = -1
End Function
Sub datashape()
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim rsChapter As Variant cnn.Provider = "MSDataShape"
cnn.Open "Data Provider=MSDASQL;" & _
"DSN=vfox;uid=sa;pwd=vfox;database=pubs”
'步骤 1
rst.StayInSync = FALSE
rst.Open "SHAPE {select * from authors}
APPEND ({select * from titleauthor} AS chapter
RELATE au_id TO au_id)",
cnn
'步骤 2
While Not rst.EOF
Debug.Print rst("au_fname"), rst("au_lname"),
rst("state"), rst("au_id")
'步骤 3
Set rsChapter = rst("chapter")
'步骤 4
While Not rsChapter.EOF
Debug.Print rsChapter(0), rsChapter(1),
rsChapter(2), rsChapter(3)
rsChapter.MoveNext
Wend
rst.MoveNext
Wend
End Sub这是MSDN中ODBC的一个例子,不知道怎么用MS Jet OLEDB来实现?
Set cn = New ADODB.Connection
cn.Provider = "MSDataShape" '设定成阶层式的联结
'设定资料库的所在
cn.ConnectionString = "Provider=MSDataShape;Data Source=C:\Program Files\Microsoft Visual Studio\VB98\Nwind.mdb;
Data Provider=Microsoft.Jet.OLEDB.4.0"
cn.Open
不管怎么样,还是十分感谢的!!
http://expert.csdn.net/Expert/topic/2342/2342897.xml?temp=.1999475