如何从查询中获取所有列的总行数 [英] how to get total number of rows from a query with also all column

问题描述

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

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

这篇关于如何从查询中获取所有列的总行数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！