如何将Db.OpenRecordset(Sqlstr)的记录赋值给DataReport? dim Db As Database DataReport1.DataSource=Db.OpenRecordset(Sqlstr) ,报错类型不匹配,可是用adodb.Recordset赋值是结果是对的,不知知怎么将Db.OpenRecordset(Sqlstr)的记录赋值给DataReport? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用Recordset.add rs.fields("字段名")=db.recordset.fields("字段名") dim i as integerfor i=0 to 100 rs.fiels(i)=db.recordset.fields(i)next Dim rs As New ADODB.RecordsetPrivate Sub DataReport_Initialize() Dim Sql As String Dim Sqltable As String Sqltable = Trim$(Fsettle.Ttableno.Text)'连接数据库(Access)'打开记录集( 根据frmMain窗体上Text1中的日期查询 ) Sql = "select food.foodname,choicemenu.qty from food,choicemenu " & _ "where choicemenu.tableno='" & Sqltable & "'and food.foodno=choicemenu.foodno" rs.Open Sql, P_cnn, adOpenKeyset, adLockOptimistic '设置text控件属性 DataReport1.Sections("Section1").Controls("text1").DataField = "foodname" DataReport1.Sections("Section1").Controls("text2").DataField = "qty" DataReport1.Sections("Section1").Controls("Label2").Caption = CStr(DataReport1.Width) DataReport1.BottomMargin = 1440 DataReport1.LeftMargin = 70 'DataReport1.RightMargin = 7000 DataReport1.TopMargin = 70 Set DataReport1.DataSource = rs DataReport1.ReportWidth = 700End SubPrivate Sub DataReport_QueryClose(Cancel As Integer, CloseMode As Integer) rs.CloseEnd Sub 有人用vb開發過廣告系統么? 请教一个获取外部运行的程序的窗体标题的问题! 请教一个导出到excel的问题? 欢度国庆,散分 自己编了一个程序运行后,系统不能关机,求助高手!!! 图形菜单控件 visual basic6.0 企业完全版 不支持win 7 吗 请问在VB中怎么实现通过POST方式传递参数给一个Web服务器?? 突然兴奋起来`!找了些VB程序来编,但后来说我错误啊`! 请教,vc的Debug和Release之间有什么区别 请问有没有批量改文件名的软件 引用了没有双向兼容文件设置的工程,如何解决?
rs.fields("字段名")=db.recordset.fields("字段名")
for i=0 to 100
rs.fiels(i)=db.recordset.fields(i)
next
Private Sub DataReport_Initialize()
Dim Sql As String
Dim Sqltable As String
Sqltable = Trim$(Fsettle.Ttableno.Text)
'连接数据库(Access)'打开记录集( 根据frmMain窗体上Text1中的日期查询 )
Sql = "select food.foodname,choicemenu.qty from food,choicemenu " & _
"where choicemenu.tableno='" & Sqltable & "'and food.foodno=choicemenu.foodno"
rs.Open Sql, P_cnn, adOpenKeyset, adLockOptimistic
'设置text控件属性
DataReport1.Sections("Section1").Controls("text1").DataField = "foodname"
DataReport1.Sections("Section1").Controls("text2").DataField = "qty"
DataReport1.Sections("Section1").Controls("Label2").Caption = CStr(DataReport1.Width)
DataReport1.BottomMargin = 1440
DataReport1.LeftMargin = 70
'DataReport1.RightMargin = 7000
DataReport1.TopMargin = 70
Set DataReport1.DataSource = rs
DataReport1.ReportWidth = 700
End SubPrivate Sub DataReport_QueryClose(Cancel As Integer, CloseMode As Integer)
rs.Close
End Sub