PC Review


Reply
Thread Tools Rate Thread

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

 
 
Bob
Guest
Posts: n/a
 
      12th Apr 2004
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

 
Reply With Quote
 
 
 
 
Cor Ligthert
Guest
Posts: n/a
 
      12th Apr 2004
Hi Bob,

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

Cor


 
Reply With Quote
 
Bob
Guest
Posts: n/a
 
      12th Apr 2004
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
>
>


 
Reply With Quote
 
Cor Ligthert
Guest
Posts: n/a
 
      12th Apr 2004
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


 
Reply With Quote
 
Herfried K. Wagner [MVP]
Guest
Posts: n/a
 
      12th Apr 2004
* "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/>
 
Reply With Quote
 
Bob
Guest
Posts: n/a
 
      12th Apr 2004
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/>


 
Reply With Quote
 
Bob
Guest
Posts: n/a
 
      12th Apr 2004
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
>
>


 
Reply With Quote
 
Chris Botha
Guest
Posts: n/a
 
      12th Apr 2004
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
>



 
Reply With Quote
 
Jay B. Harlow [MVP - Outlook]
Guest
Posts: n/a
 
      12th Apr 2004
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
>



 
Reply With Quote
 
Bob
Guest
Posts: n/a
 
      12th Apr 2004
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
> >

>
>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
set server control property in markup using server side variable, even just a constant, is that possible? Ryan Liu Microsoft ASP .NET 0 21st Feb 2009 08:25 PM
Server-side events do not fire the first time after client-side validators have fired Stuart Whiteford Microsoft ASP .NET 2 25th Apr 2006 11:10 AM
How to get Control's property value at server side? ca___t Microsoft C# .NET 1 11th Jan 2005 06:43 PM
Safe to have client-side AND server-side page load event procedures? Fred Microsoft ASP .NET 2 12th Jul 2004 07:46 PM
Execute client side jscript on page load based on server side logic moondaddy Microsoft ASP .NET 2 18th Mar 2004 01:33 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:36 AM.