Hello,
i need obtain pages in a recordset for a very large query without get all records in the recordset. If I use OleDbDataAdapter.Fill(DataSet, startRecord, maxRecords, "tablename") the sqlserver gives me all records (1000000) and after this the pagination show me the records in X records. I would like the sqlserver gives me the records in pages with 1000 records(for example) and after show these 1000 records.
Thank you!!!
i need obtain pages in a recordset for a very large query without get all records in the recordset. If I use OleDbDataAdapter.Fill(DataSet, startRecord, maxRecords, "tablename") the sqlserver gives me all records (1000000) and after this the pagination show me the records in X records. I would like the sqlserver gives me the records in pages with 1000 records(for example) and after show these 1000 records.
Thank you!!!