Sixe in KB of a dataset or datatable

  • Thread starter Thread starter Manekurt
  • Start date Start date
M

Manekurt

Hello, does anyone knows how to know the size in Kb of data stored ina a
dataset?
Thanks
 
That is sort of a how long is a string question.

You would need to calculate the number of rows, and the amount of data for
each row. If you have strings this will be very difficult. There is also
overhead with internal variables in the object etc.

Not an easy thing to calculate as there is not SizeOf(object as object) as
integer to return this information.

Lloyd Sheen
 
Thank you, what I really need, is to calculate the data transfer from a SQL
Server database, I thought this was less complicated.
I renew my question, is there a simple way to calculate in Kb, the
comunication to a SQL Server?
Thank you again
 
I guess we need to know what you mean by the KB's for a connection.

There are many resources used depending on how you connect. There will be
objects on the client workstation , a connection and a command. On the
server there will the connection and whatever memory is used for the query
and the query plan.

What is it that you are trying to use this information for?

Lloyd Sheen
 
Back
Top