473,385 Members | 2,003 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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 7532
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: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...

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.