473,473 Members | 1,548 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Find the size of a DataSet

Hello,

Is it possible to find the size of a populated DataSet?

I have an application (VB.Net) that that populates a DataSet and then
sends that DataSet to a PDA.
The application on the PDA then uses that DataSet.
The size of the DataSet makes quite a bit of difference to the transfer
time and the response of the PDA application so I would like some way
to determine the DataSet size for some benchmarks.

It would be great to be able to pop up a warning message before
the transfer to the PDA if the user has selected too much data.
Thanks,

Matt

Jul 21 '05 #1
4 7542
Matt,

I think that it is important how you transport the dataset when it is as XML
dataset than it is of course just one of the properties as result from the
fileinfo class.

However just a gues

Cor

"Matt" <mt*****@gladstonemrm.com>
Hello,

Is it possible to find the size of a populated DataSet?

I have an application (VB.Net) that that populates a DataSet and then
sends that DataSet to a PDA.
The application on the PDA then uses that DataSet.
The size of the DataSet makes quite a bit of difference to the transfer
time and the response of the PDA application so I would like some way
to determine the DataSet size for some benchmarks.

It would be great to be able to pop up a warning message before
the transfer to the PDA if the user has selected too much data.
Thanks,

Matt

Jul 21 '05 #2
Hi Cor,

Of course! I am in fact turning it into an XML file in order to send it
to the PDA, I didn't mention that bit because I did not want to bore
people with the details.

I expect I shall use your idea of the FileInfo class.
I was just wondering if there was a way to do it without writing the
file to disk first as it would save on processing.

Thanks,

Matt

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 21 '05 #3
Matt,

I was assuming you was writing it as file already, when not than maybe you
can just serialize it as string than you have the "almost" length.

\\\
Dim sw As New System.IO.StringWriter
ds.WriteXml(sw)
Dim mystring As String = sw.tostring
///
I hope this helps?

Cor
Jul 21 '05 #4
Yes that's just the kind of thing I was after.
I shall use that.

Thanks,

Matt

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 21 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: André Almeida Maldonado | last post by:
When I use this code: Dim dtsDataSet As DataSet = New DataSet("Dados") Dim dttUsuarios As DataTable = dtsDataSet.Tables.Add("Usuarios") Dim dtvUsuarios As DataView = New...
2
by: thejackofall | last post by:
Hi. How do I get the size of the object at runtime? I tried Marshal.SizeOf, but it fails with ArgumentException. Suppose I want to do the following: DataSet oDS = new DataSet(); // Get...
2
by: Amadelle | last post by:
Hi all and thanks in advance, I am thinking of passing around a dataset as parameter to different methods through my code ...my question is what is a reasonable size for a dataset in order to...
1
by: ad | last post by:
I want to write a MemoryStream to a buffer. I use the codes below; The code is from the msdn help, They always declare the size of buffer as the (length of memorystream)+1; The code run ok, but...
2
by: Josh | last post by:
Hi Guys, I have been stuck on this problem for several days now, i have a set of nested datagrids. Inside the second datagrid i have a dropdown list, a textbox and a label. I want the textbox...
1
by: Dotnet Gruven | last post by:
I've posted this in the adonet group, however it was suggested I might have better luck here.... ============================================================= I'm trying to use a typed dataset and...
4
by: Matt | last post by:
Hello, Is it possible to find the size of a populated DataSet? I have an application (VB.Net) that that populates a DataSet and then sends that DataSet to a PDA. The application on the PDA...
5
by: Scott Emick | last post by:
I have rather small project that is a store/dealer locator but it is consuming about 143 MB in terms of the virtual memory I believe. Working set is 46 MB and Private Bytes 32 MB. The project...
0
by: RN | last post by:
Hi everyone, First please let me explain. I am attempting to store pdf files in an MS Access DB (2000) and I have written a subroutine to do this. My code seems to work perfectly (see code...
0
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...
0
Oralloy
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
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...
0
agi2029
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,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
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...
0
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 ...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.