ADO question: no built-in server-side load time property?

Is there a way in ADO.Net to get the (SQL server) time of load of a dataset?
I'd rather not have to call a separate stored procedure with SELECT
GETDATE() every time I need this information.

Bob

re: ADO question: no built-in server-side load time property?

Hi Bob,

What do you mean with "the load of a dataset"?

Cor

re: ADO question: no built-in server-side load time property?

Hi Bob,

What do you mean with "the load of a dataset"?

Cor

re: ADO question: no built-in server-side load time property?

OK, to be precise, when the SqlDataAdapter's Fill method fills the DataSet
with data. Or, more generally, any time I get data from the SQL Server.

"Cor Ligthert" <notfirstname@planet.nl> wrote in message
news:u6TOKlJIEHA.3248@TK2MSFTNGP12.phx.gbl...[color=blue]
> Hi Bob,
>
> What do you mean with "the load of a dataset"?
>
> Cor
>
>[/color]

re: ADO question: no built-in server-side load time property?

OK, to be precise, when the SqlDataAdapter's Fill method fills the DataSet
with data. Or, more generally, any time I get data from the SQL Server.

"Cor Ligthert" <notfirstname@planet.nl> wrote in message
news:u6TOKlJIEHA.3248@TK2MSFTNGP12.phx.gbl...[color=blue]
> Hi Bob,
>
> What do you mean with "the load of a dataset"?
>
> Cor
>
>[/color]

re: ADO question: no built-in server-side load time property?

Than the time is in Now

It builds a dataset on the client not on the server, it is done using the
datareader.

I hope this helps?

Cor

re: ADO question: no built-in server-side load time property?

Than the time is in Now

It builds a dataset on the client not on the server, it is done using the
datareader.

I hope this helps?

Cor

re: ADO question: no built-in server-side load time property?

* "Bob" <nobody@nowhere.com> scripsit:[color=blue]
> OK, to be precise, when the SqlDataAdapter's Fill method fills the DataSet
> with data. Or, more generally, any time I get data from the SQL Server.[/color]

You want to measure how much time this takes?

<URL:http://www.mentalis.org/soft/class.qpx?id=8>

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

re: ADO question: no built-in server-side load time property?

* "Bob" <nobody@nowhere.com> scripsit:[color=blue]
> OK, to be precise, when the SqlDataAdapter's Fill method fills the DataSet
> with data. Or, more generally, any time I get data from the SQL Server.[/color]

You want to measure how much time this takes?

<URL:http://www.mentalis.org/soft/class.qpx?id=8>

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

re: ADO question: no built-in server-side load time property?

Broken link...

No, that's not what I'm after.

"Herfried K. Wagner [MVP]" <hirf-spam-me-here@gmx.at> wrote in message
news:c5ebpk$m7re$3@ID-208219.news.uni-berlin.de...[color=blue]
> * "Bob" <nobody@nowhere.com> scripsit:[color=green]
> > OK, to be precise, when the SqlDataAdapter's Fill method fills the[/color][/color]
DataSet[color=blue][color=green]
> > with data. Or, more generally, any time I get data from the SQL Server.[/color]
>
> You want to measure how much time this takes?
>
> <URL:http://www.mentalis.org/soft/class.qpx?id=8>
>
> --
> Herfried K. Wagner [MVP]
> <URL:http://dotnet.mvps.org/>[/color]

re: ADO question: no built-in server-side load time property?

Broken link...

No, that's not what I'm after.

"Herfried K. Wagner [MVP]" <hirf-spam-me-here@gmx.at> wrote in message
news:c5ebpk$m7re$3@ID-208219.news.uni-berlin.de...[color=blue]
> * "Bob" <nobody@nowhere.com> scripsit:[color=green]
> > OK, to be precise, when the SqlDataAdapter's Fill method fills the[/color][/color]
DataSet[color=blue][color=green]
> > with data. Or, more generally, any time I get data from the SQL Server.[/color]
>
> You want to measure how much time this takes?
>
> <URL:http://www.mentalis.org/soft/class.qpx?id=8>
>
> --
> Herfried K. Wagner [MVP]
> <URL:http://dotnet.mvps.org/>[/color]

re: ADO question: no built-in server-side load time property?

I want the server time, not the client's.

"Cor Ligthert" <notfirstname@planet.nl> wrote in message
news:uTLlEAKIEHA.3720@tk2msftngp13.phx.gbl...[color=blue]
> Than the time is in Now
>
> It builds a dataset on the client not on the server, it is done using the
> datareader.
>
> I hope this helps?
>
> Cor
>
>[/color]

re: ADO question: no built-in server-side load time property?

I want the server time, not the client's.

"Cor Ligthert" <notfirstname@planet.nl> wrote in message
news:uTLlEAKIEHA.3720@tk2msftngp13.phx.gbl...[color=blue]
> Than the time is in Now
>
> It builds a dataset on the client not on the server, it is done using the
> datareader.
>
> I hope this helps?
>
> Cor
>
>[/color]

re: ADO question: no built-in server-side load time property?

Bob, if the SQL Server is on the same computer as your app/web app, etc,
then you can use Now() which will return the same time as the GETDATE() in
the SQL Server.
If not, then you have to select GETDATE() every time you need it.

"Bob" <nobody@nowhere.com> wrote in message
news:eEsLFcJIEHA.2164@TK2MSFTNGP12.phx.gbl...[color=blue]
> Is there a way in ADO.Net to get the (SQL server) time of load of a[/color]
dataset?[color=blue]
> I'd rather not have to call a separate stored procedure with SELECT
> GETDATE() every time I need this information.
>
> Bob
>[/color]

re: ADO question: no built-in server-side load time property?

Bob, if the SQL Server is on the same computer as your app/web app, etc,
then you can use Now() which will return the same time as the GETDATE() in
the SQL Server.
If not, then you have to select GETDATE() every time you need it.

"Bob" <nobody@nowhere.com> wrote in message
news:eEsLFcJIEHA.2164@TK2MSFTNGP12.phx.gbl...[color=blue]
> Is there a way in ADO.Net to get the (SQL server) time of load of a[/color]
dataset?[color=blue]
> I'd rather not have to call a separate stored procedure with SELECT
> GETDATE() every time I need this information.
>
> Bob
>[/color]

re: ADO question: no built-in server-side load time property?

Bob,
ADO.NET does not support that per se.

You will either need to include it with each command you execute (an extra
column on your select statements). Or a second select statement.

Hope this helps
Jay

"Bob" <nobody@nowhere.com> wrote in message
news:eEsLFcJIEHA.2164@TK2MSFTNGP12.phx.gbl...[color=blue]
> Is there a way in ADO.Net to get the (SQL server) time of load of a[/color]
dataset?[color=blue]
> I'd rather not have to call a separate stored procedure with SELECT
> GETDATE() every time I need this information.
>
> Bob
>[/color]

re: ADO question: no built-in server-side load time property?

Bob,
ADO.NET does not support that per se.

You will either need to include it with each command you execute (an extra
column on your select statements). Or a second select statement.

Hope this helps
Jay

"Bob" <nobody@nowhere.com> wrote in message
news:eEsLFcJIEHA.2164@TK2MSFTNGP12.phx.gbl...[color=blue]
> Is there a way in ADO.Net to get the (SQL server) time of load of a[/color]
dataset?[color=blue]
> I'd rather not have to call a separate stored procedure with SELECT
> GETDATE() every time I need this information.
>
> Bob
>[/color]

re: ADO question: no built-in server-side load time property?

That's too bad... think I'll return two data tables.

Thanks,
Bob

"Jay B. Harlow [MVP - Outlook]" <Jay_Harlow_MVP@msn.com> wrote in message
news:u4BHDWKIEHA.3720@tk2msftngp13.phx.gbl...[color=blue]
> Bob,
> ADO.NET does not support that per se.
>
> You will either need to include it with each command you execute (an extra
> column on your select statements). Or a second select statement.
>
> Hope this helps
> Jay
>
> "Bob" <nobody@nowhere.com> wrote in message
> news:eEsLFcJIEHA.2164@TK2MSFTNGP12.phx.gbl...[color=green]
> > Is there a way in ADO.Net to get the (SQL server) time of load of a[/color]
> dataset?[color=green]
> > I'd rather not have to call a separate stored procedure with SELECT
> > GETDATE() every time I need this information.
> >
> > Bob
> >[/color]
>
>[/color]