Thank you cjard and Thread1 for your replies,...
you suggested me to use, datatable and dataadapter would it solve my dynamic column problem only or would it address the performance issue too, Is it better than datareader and IList in terms of speed as well ??

cjard, did you recommend me to use Cursors IN SP irrespective of whether I use paging or not, ? or cursors are to be used only when pagnation is done..

If for some reasons I am not let to do paging, since its a desktop app, then do you think Using datatable and dataadapter would then be an option again..??