Adjustment of dynamic soft layer-3 paging massive data statistics

Dbhelpersql. Cs source file

Add the followingCode

/**/ ///   <Summary>
/// Total number of returned records
///   </Summary>
///   <Param name = "fieldname"> </param>
///   <Param name = "tablename"> </param>
///   <Returns> </returns>
Public   Static   Int Getcount ( String Strwhere)
{
String Strsql = Strwhere;
Object OBJ = Dbhelpersql. getsingle (strsql );
If (OBJ =   Null )
{
Return 1;
}
Else
{
Return Int. Parse (obj. tostring ());
}
}

Add to Dal Layer Public   Int Getcount ( String Strwhere)
{
Stringbuilder strsql =   New Stringbuilder ();
Strsql. append ( " Select count (*) " );
Strsql. append ( " From Users " );
If (Strwhere. Trim () ! =   "" )
{
Strsql. append ("Where" +Strwhere );
}
Return Dbhelpersql. getcount (strsql. tostring ());
// Return dbhelpersql. executesql (strsql. tostring ());
}

Add the following to the BLL layer: /**/ ///   <Summary>
/// Total number of returned records
///   </Summary>
///   <Param name = "strwhere"> </param>
///   <Returns> </returns>
Public   Int Getcount ( String Strwhere)
{
ReturnDal. getcount (strwhere );
}

Originally, dataset was used to read the number of records. When a massive amount of data is encountered, it will die, wasting all the memory and making it unavailable.