How to save a large ArrayList content to a SQL text DataType through a property

Question

0.00/5 (No votes)

See more:

Hello everybody...
I'd like to save my ArrayList content to my SQL DataBase but because my ArrayList could be very large
i'm gonna need to save the ArrayList to a text DataType in my SQL DataBase and i need to do it through a property.
I know how to use a property but i don't know how can i merge the ArrayList and save it to a text DataType !
I mean when you want to merge the content of ArrayList you gonna need a very large single space for it, like the DataSet or DataTable and also i don't know can i use the DataSet or DataTable or something like that or not !

could you please someone help me ?

Posted 5-Jan-14 20:26pm

Mohammad Sadegh Zohari

Updated 5-Jan-14 21:16pm

Karthik_Mahalingam

v2

Add a Solution

Comments

Karthik_Mahalingam 6-Jan-14 3:21am

what does your array list consists of ??

Mohammad Sadegh Zohari 6-Jan-14 11:20am

just numbers (double)

Mohammad Sadegh Zohari 6-Jan-14 11:34am

because i'm writing a component if i have to do something special to save the ArrayList into text DataType through a property, i'd like to do it on property side.i don't like when user try to save the property content(ArrayList) to Text DataType he or she has to do a very complicated things .

Karthik_Mahalingam 6-Jan-14 19:51pm

post your code, i wil help you.

Amir Mahfoozi 6-Jan-14 4:38am

You can serialize your ArrayList and store it in a text data type.

Mohammad Sadegh Zohari 6-Jan-14 11:35am

Thanks... But how can i do it ? how to serialize the ArrayList ?

Amir Mahfoozi 6-Jan-14 13:30pm

http://bit.ly/1gbVzsR

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)