Data Report的例子: Private Sub DataReport_Initialize() Dim AdoCon As New ADODB.Connection Dim AdoRec As New ADODB.Recordset Dim ctl As Object
AdoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\a.mdb;Persist Security Info=False" AdoRec.Open "select * from a", AdoCon Set DataReport1.DataSource = AdoRec For Each ctl In Me.Sections.Item("Section1").Controls If TypeName(ctl) = "RptTextBox" Then Select Case ctl.Name Case "Text1" ctl.DataField = AdoRec.Fields("aa").Name Case "Text2" ctl.DataField = AdoRec.Fields("bb").Name Case "Text3" ctl.DataField = AdoRec.Fields("cc").Name End Select End If Next End Sub
Private Sub DataReport_Initialize()
Dim AdoCon As New ADODB.Connection
Dim AdoRec As New ADODB.Recordset
Dim ctl As Object
AdoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\a.mdb;Persist Security Info=False"
AdoRec.Open "select * from a", AdoCon
Set DataReport1.DataSource = AdoRec
For Each ctl In Me.Sections.Item("Section1").Controls
If TypeName(ctl) = "RptTextBox" Then
Select Case ctl.Name
Case "Text1"
ctl.DataField = AdoRec.Fields("aa").Name
Case "Text2"
ctl.DataField = AdoRec.Fields("bb").Name
Case "Text3"
ctl.DataField = AdoRec.Fields("cc").Name
End Select
End If
Next
End Sub