主题：[求助]后台统计，没有头绪

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

Dim s As String

Dim cmd As New SQLCommand

cmd.CommandText = "Select Count(流水号) From {收费明细} Where 打印 =  ture"

s = cmd.ExecuteScalar

e.Form.Controls("Label10").text = s