how to filter and display record with repeater & paging

Hi Harshal,

This you ccan achieve it by implementing custom paging where you will be passing rowcount to be shown on each page, page no along with where condition to stored procedure.

I would be showing sample example hope this will help u.
SELECT ROW_NUMBER() OVER (ORDER BY Column1) as RowNum, * INTO #temp
FROM Table WHERE Column1 LIKE 'a%'

SELECT TOP (pgNo*pgsize) * FROM #temp
WHERE RowNum >= (pgsize*(pgno-1)) AND RowNum <= (pgsize*pgNo)

This will help you to retreive faster and only required result to client instead of whole result set.Mark it asnwered if it helped you.