datagrid with large record

[caheo]

Hi all I have a datagrid tied up to sql server. Also I have a very large record need to page during runtime. I have looked up solutions to find out how to increase the performance of my application when paging. However I'm not satisfied with those solutions. I would like to ask if there is an optimmize solution out there so that I can do the following: paging, sorting, update, insert and delete. Thanks for any instructions