Problem Related to asp.net.......

Question

2.50/5 (2 votes)

See more:

i want to get the search result time like google when i'm using Datareader to fetch record from db
can anyone tell me how to do this?

Posted 2-Oct-12 3:21am

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Guirec · Accepted Answer · 2012-10-02T03:28:00

C#

var sw = new StopWatch();
sw.Start();

// Do your sql query

sw.Stop();

var timeSpent = sw.TotalMilliseconds;

Posted 2-Oct-12 3:28am

Comments

Surendra0x2 2-Oct-12 13:44pm

how to convert
var timeSpent = sw.ElapsedMilliseconds.ToString();
milliseconds to seconds i want to show result in seconds can u help me?

Surendra0x2 2-Oct-12 14:15pm

Thanks Buddy i got the solution :)

Guirec 2-Oct-12 22:27pm

I don't know who downvoted the solution to 1 but some explanations would probably make sense :)