窗体连接数据库如下,获得数据集adoPrimaryRS
Private Sub Form_Load()
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Task2000.mdb;"
Set adoPrimaryRS = New Recordset
adoPrimaryRS.Open "select datafield from table ", db, adOpenStatic, adLockOptimistic
------------现在在同一窗体中设置一报表输出按钮,输出单个记录
即如下sql形式
"select datafield from table where datafield='" & Trim(txtFields(0).Text) & "'" 请问如何设置数据集的绑定啊
Set DataReport1.DataSource =
DataReport1.DataMember =End Sub
Private Sub Form_Load()
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Task2000.mdb;"
Set adoPrimaryRS = New Recordset
adoPrimaryRS.Open "select datafield from table ", db, adOpenStatic, adLockOptimistic
------------现在在同一窗体中设置一报表输出按钮,输出单个记录
即如下sql形式
"select datafield from table where datafield='" & Trim(txtFields(0).Text) & "'" 请问如何设置数据集的绑定啊
Set DataReport1.DataSource =
DataReport1.DataMember =End Sub
DataReport1.sections(1).controls("label1").caption=rs(0)
.
.
.
DataReport1.show
Set DataReport1.DataSource =adoPrimaryRS
就可以了
'printer.Orientation =
'以下准备数据源(记录集)
'要打印的数据源(记录集)必须是一个全局级别的,或者是本设计器模块级别的记录集
'数据库使用的是 Northwind.mdb
adoConnectionX.Open "dsn=sybase;uid=sa;pwd=abcd1234" '"Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & App.Path & "\Northwind.mdb"
adoRecordsetX.Open "select * from STUDENTCARD", adoConnectionX
Set DataReport1.DataSource = adoRecordsetX '设置 DataReport 的数据源
'-------------------------------------------------------------------------
'以下根据控件所在区域(Sections)和所属控件类别等将它们分成若干集合