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 17 1156
Hi Bob,
What do you mean with "the load of a dataset"?
Cor
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" <no**********@planet.nl> wrote in message
news:u6**************@TK2MSFTNGP12.phx.gbl... 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" <no**********@planet.nl> wrote in message
news:u6**************@TK2MSFTNGP12.phx.gbl... 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
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" <no****@nowhere.com> 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/>
* "Bob" <no****@nowhere.com> 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]" <hi***************@gmx.at> wrote in message
news:c5***********@ID-208219.news.uni-berlin.de... * "Bob" <no****@nowhere.com> 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]" <hi***************@gmx.at> wrote in message
news:c5***********@ID-208219.news.uni-berlin.de... * "Bob" <no****@nowhere.com> 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" <no**********@planet.nl> wrote in message
news:uT**************@tk2msftngp13.phx.gbl... 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
I want the server time, not the client's.
"Cor Ligthert" <no**********@planet.nl> wrote in message
news:uT**************@tk2msftngp13.phx.gbl... 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" <no****@nowhere.com> wrote in message
news:eE**************@TK2MSFTNGP12.phx.gbl... 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, 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" <no****@nowhere.com> wrote in message
news:eE**************@TK2MSFTNGP12.phx.gbl... 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" <no****@nowhere.com> wrote in message
news:eE**************@TK2MSFTNGP12.phx.gbl... 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" <no****@nowhere.com> wrote in message
news:eE**************@TK2MSFTNGP12.phx.gbl... 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]" <Ja************@msn.com> wrote in message
news:u4**************@tk2msftngp13.phx.gbl... 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" <no****@nowhere.com> wrote in message news:eE**************@TK2MSFTNGP12.phx.gbl... 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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Matt Saunders |
last post by:
Hi all,
In a couple of weeks I get my big break. I joined my present employer (an
ISP) in a real bottom-rung-of-the-ladder customer support job several months
ago, without even getting an...
|
by: Christian Seberino |
last post by:
I wrote some C functions and successfully imported them into Python.
All is apparently well but there is one question about the object returned
by the C function that is bugging me...
Take for...
|
by: Stephanie Stowe |
last post by:
Hi. I have an ASP page which stores a cookie. That cookie is then read on a
different server. This is the crux of an ASP / JSP bridge I am creating for
allowing a user to seemlessly switch from an...
|
by: deko |
last post by:
I need to use Visual Basic to create an ActiveX DLL that
subclasses an Access form (cf. Knowledge Base Article
278379). Should I use Visual Studio .NET --or-- regular
Visual Basic 6 --or-- VS.NET...
|
by: kimshapiro100 |
last post by:
Question on PhP, MySQL
I am thinking of a consumer internet business for which I will have to
have a database driven site built.
I am thinking of using
PhP, MySQL as the main technologies...
| |
by: No Such Luck |
last post by:
Hi all:
I have an unsigned char array (size 4):
unsigned char array;
array = 0x00;
array = 0x00;
array = 0x02;
array = 0xe7;
|
by: iwdu15 |
last post by:
i used regasm to make my vb.net control a tlb file...how can i add it to like
my c++ form? i used regasm and made it to a .tlb file but when i try to add
it to the toolbox it gives an error....what...
|
by: Flack |
last post by:
Hello,
Lets say I built my app on a machine that has Excel 2003 installed. So, the
interop assembly created was built off of 2003.
Now, I have a few questions on what would happen if I ran...
|
by: mitsura |
last post by:
Hi,
I just installed py2exe to create a binary of my Python script.
However, py2exe does not seem to create a binary from my .py script.
This is what I have done:
I create a setup.py script:
"...
|
by: Alexander Dong Back Kim |
last post by:
Dear all,
I want to create a method that return an element in a vector by
selecting the element position by vector's at().
The method should be look like
vector<Apple_appleBox;
Apple &...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |