The Fill method we have developed so far, executes the Select command on the underlaying server and picks up RowCount records from startRowIndex position. For example, if Select * from Person returnS 20 rows, and startRowIndex is 0, only the first RowCount records will be fetched. This means that the complete result set will be [...]
Archive for July 15th, 2008
Implementing a 3-Tier architecture with C# – Part 3
Posted in ADO.NET, ASP.NET, Architecture, C#, SQL SERVER, tagged 3-TIER, 3Tier, ADO.NET, Architecture, ASP.NET, C#, FirstReturnedRecord, IDENTITY, N-TIER, NTier, PAGING, ROW_NUMBER, SCOPE_IDENTITY, SQL SERVER, SQL SERVER 2005, StoredProcedure, TIER, UpdateRowSource on July 15, 2008 | Leave a Comment »