如何把两个字段的合计数值显示在Preview - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

With wb.AddPreview("","pv" & dr("memid"),"活动费合计:",dr("changdifee")+dr("qiufee"))

用法一样：http://www.foxtable.com/mobilehelp/topics/0128.htm
只是把帮助里的显示表格改为Preview即可

With wb.AddPreview("","pv" & dr("memid"),"活动费合计:"," " & dr("changdifee")+ dr("qiufee") & "")

没看到加载分页数据的功能

'获取该页数据

Dim cmd As New SQLCommand

cmd.Connecti '记得设置数据源名称

cmd.CommandText = "Select Count(*) From {订单}"

Dim Count As Integer = cmd.ExecuteScalar() '获取总的行数

Dim Pages As Integer = Math.Ceiling(Count/PageRows) '计算出总页数

cmd.CommandText = "Select * From (Select Row_Number() Over(Order by 订单.订单编号 desc ) As RowNum,订单.订单编号,日期,客户,Sum(数量) As 数量,sum(数量*单价) As 金额"

cmd.CommandText = cmd.CommandText & " From 订单 Left JOIN 订单明细 ON 订单明细.订单编号 = 订单.订单编号 Group By {订单}.订单编号,日期,客户) As a "

cmd.CommandText = cmd.CommandText & " Where RowNum >= " & StartRow & " And RowNum <= " & EndRow

Dim dt As DataTable = cmd.ExecuteReader

……

Dim StartRow As Integer = page * pageRows + 1 '此页第一行

Dim EndRow As Integer = (page + 1) * pageRows '此页最后一行

Dim cmd As New SQLCommand

cmd.Connecti '记得设置数据源名称

cmd.CommandText = "Select Count(*) From {Table_Mem}"

Dim Count As Integer = cmd.ExecuteScalar() '获取总的行数

cmd.CommandText = "Select * From (Select Row_Number() Over(Order by huodongdate desc) As [NO.],[memid],huodongdate as 日期,changdifee as 场地费,qiufee as 球费,numpeople as 人数,avecost as 人均,yucunkoufee as 预存扣,shouxufee as 手续费,clubyucun as 场馆预存,offlinefee as 线下,tixianmoney as 提现,demo as 备注 From Table_Mem) As a "

cmd.CommandText = cmd.CommandText & " Where [NO.]>= " & StartRow & " And [NO.] <= " & EndRow

Dim dt As DataTable = cmd.ExecuteReader

For Each dr As DataRow In dt.DataRows

Dim Total As Decimal = dr("changdifee")+ dr("qiufee")

With wb.AddPreview("","pv" & dr("memid"),dr("huodongdate") & "活动费用小计:", "￥" & Total)

.additem("场地费用:","￥" & dr("changdifee"))

.AddItem("备注内容:",dr("demo"))

.Addbutton("点赞", "", 1, "")

End With

wb.AppendHTML(" ")

……

说明没有符合条件的数据

msgbox(cmd.CommandText )

另外sql里把英文名全部改为了中文名，结果代码里还是使用的英文名，服务端肯定会提示出错的

主题：如何把两个字段的合计数值显示在Preview