Dear all,

I have build an ASP.net application which calls different store procedure.
When my customer request datga from store procedure, I would like to display
on the page, the time it takes to return data.

How to do that ?

regards
serge

Ah, you could generate at time delta (GetDate()) and return it as an output
Parameter but this would not really give an accurate representation of how
long it takes to "return" the data. Much of the time is used up serializing
the data to TDS and back again on the client. You would also not see this
OUTPUT parameter until all the rows had arrived. By then you could have
built a client-side timer to measure the operation time.

Show quoteHide quote

UpdateBatchSize and SqlTransaction
Find Equivalent
Does creating a Static SQL interface class make sense
DataView RowFilter and Sort properties
Not triggering a change to rowstate - Maybe!!!!!