Sixe in KB of a dataset or datatable

[Manekurt]

Hello, does anyone knows how to know the size in Kb of data stored ina a
dataset?
Thanks

[Lloyd Sheen]

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

"Manekurt" <m.*********@ga.m.a.c.om.com.arwrote in message
news:Of**************@TK2MSFTNGP03.phx.gbl...

Hello, does anyone knows how to know the size in Kb of data stored ina a
dataset?
Thanks

[Manekurt]

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

"Lloyd Sheen" <[e-mail]ó en el mensaje
news:e3**************@TK2MSFTNGP02.phx.gbl...

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

"Manekurt" <m.*********@ga.m.a.c.om.com.arwrote in message
news:Of**************@TK2MSFTNGP03.phx.gbl...

>Hello, does anyone knows how to know the size in Kb of data stored ina a
dataset?
Thanks

[Lloyd Sheen]

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

"Manekurt" <ma********@g-a-ma.com.com.arwrote in message
news:uk*************@TK2MSFTNGP06.phx.gbl...

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

"Lloyd Sheen" <[e-mail]ó en el mensaje
news:e3**************@TK2MSFTNGP02.phx.gbl...

>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

"Manekurt" <m.*********@ga.m.a.c.om.com.arwrote in message
news:Of**************@TK2MSFTNGP03.phx.gbl...

>>Hello, does anyone knows how to know the size in Kb of data stored ina a
dataset?
Thanks