如何从查询中获取所有列的总行数

问题描述：

我有这个简单的查询我想要检索选择的所有数据正在选择加我想要使用相同的查询获得总行数我该怎么做

i have this simple query i want to retrive all the data that select is selecting plus i want to get total rows number using the same query how can i do this

SELECT
--COUNT(tblTaxingSchemeDetails.TaxSchemeDetailsId) as h,
tblTaxingSchemeDetails.TaxSchemeDetailsId,
tblTaxingScheme.TaxSchemeId, 
tblTaxingScheme.TaxSchemeName, 
tblTaxingSchemeDetails.TaxType,
TaxName,
tblTaxingSchemeDetails.TaxRate
From tblTaxingScheme INNER JOIN tblTaxingSchemeDetails  
On tblTaxingScheme.TaxSchemeId = tblTaxingSchemeDetails.TaxSchemeId
INNER JOIN tblTaxType 
on tblTaxingSchemeDetails.TaxType = tblTaxType.TaxTypeID
where tblTaxingScheme.TaxSchemeId =5@TaxSchemeId

我怎么能访问总行数是C＃

and how can i access total row number is C#

答

有两种方法：

您必须在存储过程中编写另一个查询（如果你正在使用）它将返回你的总记录列，然后你可以使用数据集来显示两个表中的记录。

或

尝试这个如果你想进入一个查询

There are two ways :
Either you have to write another query in your stored-procedure (if you are using)which will return you total record column and then you can use Dataset to display records from two tables.
or
try this if you want to do it into one query

SELECT
TotalRecords = COUNT(*) OVER(), -- this will give you total records in your qurey
tblTaxingSchemeDetails.TaxSchemeDetailsId,
tblTaxingScheme.TaxSchemeId,
tblTaxingScheme.TaxSchemeName,
tblTaxingSchemeDetails.TaxType,
TaxName,
tblTaxingSchemeDetails.TaxRate
From tblTaxingScheme INNER JOIN tblTaxingSchemeDetails
On tblTaxingScheme.TaxSchemeId = tblTaxingSchemeDetails.TaxSchemeId
INNER JOIN tblTaxType
on tblTaxingSchemeDetails.TaxType = tblTaxType.TaxTypeID
where tblTaxingScheme.TaxSchemeId =@TaxSchemeId

谢谢

Thanks

如何从查询中获取所有列的总行数

相关推荐