Problem when load DataReader object into DataTable

Question

4.00/5 (1 vote)

See more:

Dear guys,
I have a small prob when trying to load datareader object into datatable
special if the object of datareader have column of LONGTEXT DataType "am use mysql database"
when convert datatype to "Text" the problem is solved,
My questions :
1- what's the difference between LONGTEXT and TEXT?
2- how to fix this problem without convert the datatype to TEXT?

The Error Message at DataTable.GetErrors() is "Column 'photo_file' exceeds the MaxLength limit."

Posted 14-Nov-12 3:07am

Ahmad Abou Hamdh

Add a Solution

Comments

Herman<T>.Instance 14-Nov-12 9:12am

The error says it. ou have a LONGText block. The size of that object is larger than a string value can hold. Like trying to parse a 64bit int in a 32 bit. After some number this fails

Ahmad Abou Hamdh 14-Nov-12 14:59pm

no my friend cause the text length not more than 10 characters

Herman<T>.Instance 16-Nov-12 4:13am

then cast the field in the qery as Text

Kschuler 14-Nov-12 12:33pm

To get more detailed help, please click the Improve Question link and add the relevant code to your question. This will help us understand more about your problem.

Killzone DeathMan 26-Nov-12 11:24am

Just do not use a DataReader...
Use a DataAdapter and a DataSet...
Something like:

MySQLConnection conn = new MySQLConnection(connectionstring);
DataAdapter adapter = new DataAdapter("SELECT * FROM TEST", conn);
DataSet ds = new DataSet();
adapter.Fill(ds);
DataTable table = ds[0];

I am not sure, but you must download the mysql connector...
Regards,
KZ

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)