Dim Cnt As Integer = Tables("打印fa piao_Table1").DataTable.GetValues("FZ","DY = False ").Count
Dim s As String
Dim cmd As New SQLCommand
cmd.CommandText = "Select Count(流水号) From {收费明细} Where RQ = #" & Date.Today & "#"
s = cmd.ExecuteScalar
e.Form.Controls("Label10").text = s
第一段代码可用在前台(数据已经加载)
想用类似于第二段的代码从后台统计不重复的流水号,条件是GetValues("流水号","打印 = ture ")
此主题相关图片如下:360截图20140214162936734.jpg
我的流水号根据要求需要重复,但在计算时重复的流水号只计算一次,对流水号进行统计,统计时,排除重复行
如图:统计结果应为 5
[此贴子已经被作者于2014-2-14 16:36:21编辑过]