如何从 Asp.Net/C# 代码隐藏中的单个 SQL Select 语句返回多个字符串变量
本文关键字:语句 Select SQL 单个 返回 变量 字符串 Asp Net 隐藏 代码 | 更新日期: 2023-09-27 18:34:39
例如,使用以下代码。
SELECT COUNT(1) as 'ClientActive',
(SELECT COUNT(1) FROM t1 AS t2 WHERE t2.fieldname = 'A') AS TotalA,
(SELECT COUNT(1) FROM t1 AS t2 WHERE t2.fieldname = 'B') AS TotalB,
(SELECT COUNT(1) FROM t1 AS t2 WHERE t2.fieldname = 'C') AS TotalC,
(SELECT COUNT(1) FROM t1 AS t2 WHERE t2.fieldname = 'D') AS TotalD
FROM t1 WHERE clientstatus='active'
我想要这样的东西返回:
lblString1.Text = TotalA;
lblString2.Text = TotalB;
etc..
有人可以生成 C# 代码来执行此操作吗?谢谢。
使用 DataSet 然后遍历它,或者只获取第一行并将每一行值分配给标签(假设您知道如何填充数据集(:
lblString1.Text = row["ClientActive"].toString(); lblString2.Text = row["TotalB"].toString(); etc.