I don't now what's happening but it seems to be working now, like you said the Datapager1_Prerender code after
initial page load will run, but now working fine only firing on my desired button click
with this code in the button click DataPager1_PreRender(null, null);
Sorry for that but thank you very much for your help