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

Hi Bob,

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

Cor

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Bob,
>
> What do you mean with "the load of a dataset"?
>
> Cor
>
>

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

* "Bob" <(E-Mail Removed)> scripsit:
> 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.

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/>

Broken link...

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

"Herfried K. Wagner [MVP]" <hirf-spam-me-(E-Mail Removed)> wrote in message
news:c5ebpk$m7re$(E-Mail Removed)...
> * "Bob" <(E-Mail Removed)> scripsit:
> > 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.
>
> 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/>

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

"Cor Ligthert" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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

Thanks,
Bob

"Jay B. Harlow [MVP - Outlook]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >
>
>