query execution time

Hi,
how can I get query execution time?
I am using ODBC conncetion, and OdbcDataReader

re: query execution time

Hi

I guess the execution time is time that ExecuteReader consumes.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Dino L." <sekretar@gmail.com> wrote in message
news:O%23lzfVMwEHA.3320@TK2MSFTNGP14.phx.gbl...[color=blue]
> Hi,
> how can I get query execution time?
> I am using ODBC conncetion, and OdbcDataReader[/color]

re: query execution time

Miha Markic [MVP C#] wrote:
[color=blue]
> Hi
>
> I guess the execution time is time that ExecuteReader consumes.
>[/color]
how can I get that time?

re: query execution time

Two easy solutions:

Store DateTime.Now before and compare it to DateTime.Now after the execution
or
do the same with Environment.TickCount.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Dino L." <sekretar@gmail.com> wrote in message
news:uLM8RkMwEHA.2568@TK2MSFTNGP10.phx.gbl...[color=blue]
> Miha Markic [MVP C#] wrote:
>[color=green]
>> Hi
>>
>> I guess the execution time is time that ExecuteReader consumes.
>>[/color]
> how can I get that time?[/color]

re: query execution time

Miha Markic [MVP C#] wrote:[color=blue]
> Two easy solutions:
>
> Store DateTime.Now before and compare it to DateTime.Now after the execution
> or
> do the same with Environment.TickCount.
>[/color]

Hvala,
thanks

re: query execution time

[color=blue]
> Hvala,[/color]

:-), Ni za kaj.
[color=blue]
> thanks[/color]

You're welcome.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com