Dim dr As DataRow = DataTables("用户").SQLFind("[身份证号] = '" & UserName & "' And [是否可用] = 'true'")
我逐句查找下，这句在登录时用的如果用参数化来改写呢
Dim cmd As New SQLCommand
cmd.Co nnecti '记得设置数据源名称
cmd.CommandText = "Sele ct Count(*) From {疫情表} where 登记日期= '" & Date.today() & "' And 是否正常='正常'"
Dim zcCount As Integer = cmd.ExecuteScalar() '获取总
cmd.CommandText = "Sele ct Count(*) From {疫情表} where 登记日期= '" & Date.today() & "' and 是否正常='异常'"
Dim ycCount As Integer = cmd.ExecuteScalar() '获取总
统计后台的两个数据如何写效率更高呢？
[此贴子已经被作者于2020/2/15 16:47:34编辑过]
加好友 
发短信
Post By：2020/2/15 16:20:00 [显示全部帖子]
