i have seen a lot of examples of how to get the output parameter from a proc when data is inserted but how do i get the output parameter when the page first loads based on a select query.

Call the procedure in the Page Load Event....

do u mean call the proc directly or use the objectdatasource to extract it?

yes...

explain me clearly your requirement......

In the sense if you want to have the event generated in the page_Load event itself definitely you have to get the parameter from the previous pages right??????

in the page_Load event pass the cookies or session variables

// declare a Variable i; 

protected void Page_Load (object sender,EventArgs e)

{

i=""+Request.Cookies["Karthik"]["Data"];

or

i=""+Session["karthik"];

write the stored procedure here

}

Mark As Answer if this helps you

Further Queries Recommended

Happy Coding

is there not a better way to do this? i was hoping i could get it from the objectdatasource somehow.

writing a stored procedure just to get the output parameter defeats the purpose of having an objectdatasource in the first place (especially when the data it returns is the same)
 

ok i got it sussed now. it has to be done in the objectdatasources Selected event, ie

int totalPages = (int)e.OutputParameters["NumberOfPages"];