the fastest way to read the data from DataTable

Question

1.00/5 (5 votes)

See more:

How can I read the data in DataTable fastest way?

character by character
recording by recording
records * record size, they can not

I'm trying to find the size of DataTable

what else?

Posted 23-Jun-14 22:57pm

onur_t

Updated 23-Jun-14 23:08pm

v3

Add a Solution

Comments

Nirav Prabtani 24-Jun-14 5:01am

?

_Asif_ 24-Jun-14 5:03am

Can't understand your question!

onur_t 24-Jun-14 5:04am

my question is linked with here

http://www.codeproject.com/Questions/789275/Division-of-Book-File?arn=0

onur_t 24-Jun-14 5:08am

I'm trying to find the size of DataTable

Dave Kreskowiak 24-Jun-14 7:54am

Size of what? The total size of the contents of the DataTable records or the DataTable object itself? No, they are the not the same!

Awadhendra Tripathi 24-Jun-14 8:37am

what you want no of records or you want no of data character? :)

agent_kruger 24-Jun-14 23:01pm

sir, what exactly are you trying to ask?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pradiprenushe · Answer 1 · 2014-06-24T16:14:00

You can serlielise dataset and chechk no of bytes used.
But why you required this?

C#

public static int GetDataLength(DataTable dt)
{

DataSet ds= new DataSet();
ds.Tables.Add(dt);

BinaryFormatter bf = new BinaryFormatter();
        MemoryStream ms = new MemoryStream();
        byte[] Array;
        bf.Serialize(ms, ds);
        Array = ms.ToArray();
        return Array.Length;     

}