How to handle large datatables c# and update database -

good day.

i asking bit of advise on other experience has been , pitfalls ect. sql developer needing write front end using c#.

i returning query mssql database via stored procedure , putting datatable. there 140k rows in result set. using standard calls datareader return resultset. no binding.

what return parts of datatable datagrid on form , allow user manipulate data in grid , save datatable collect next part of datatable , manipulate that. don't want to pull things datatable in segments need update calculations on entire datatable when change made.

and save changes database, when done.

if can point me best , efficient way appreciated.

thank in advance scott