cmd.CommandText = "select * FROM tblstudinfo LIMIT 1,2" rdr = cmd.ExecuteReader
OFFSET
FETCH
SELECT * FROM tblstudinfo ORDER BY studentid OFFSET 1 ROWS FETCH NEXT 2 ROWS ONLY
SELECT TOP 1 * FROM tblStudInfo
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)