Store ArrayList in SQL Database

Question

1.00/5 (2 votes)

See more:

SQL-Server-2005

, +

I have an ArrayList:

ArrayList arrayc = new ArrayList();
     arrayc.Insert(0,"asd");
     arrayc.Insert(1,"wet");
     arrayc.Insert(2,"wertWER");

I want to store it in a database. How can I achieve this?

Posted 13-Apr-11 0:23am

beginner in C#.net

Updated 19-Jul-18 21:06pm

jim lahey

v2

Add a Solution

Comments

Sandeep Mewara 13-Apr-11 6:35am

How do you think it can be done? Thoughts? Ideas?

BTW, any thoughts on the table structure?

Tarun.K.S 13-Apr-11 6:37am

I think you should start learning about querying databases and also to self-learning. Simply asking for code won't help you in the long run.

3 solutions

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)

OriginalGriff · Answer 1 · 2011-04-13T00:38:00

There are two ways: make each item in your ArrayList a separate row in a database (recommended) or serialize your ArrayList and store the resulting stream as binary data.

I would do the former: the later relies too much on the implementation of your program.

In addition, please try to avoid ArrayList: use the typesafe version List<T> instead. It promotes readability by restricting what can be put into the list, and does not require checking and casting when you take data out.

Dave Kerr · Answer 2 · 2011-04-13T01:07:00

Hi,

Consider creating an SQL Compact Edition database, which will store the database in a file but allow standard database access through an API like the entity framework. See this article:

http://technet.microsoft.com/en-us/library/cc835495.aspx[^]

This way a SQL CE database is distributed with your application.

Use the Entity Framework to create a model (i.e. the table structure) and create the database from this. You can then use the classes created to add data to your database or query data from it.

Member 13919202 · Answer 3 · 2018-07-19T21:07:00

Solution 3

Another way I think is simple, is by appending the items to a single string using some symbol between the items(- or _ or &, etc) and store it in the database. While reading it, you can parse it to an ArrayList with a single line of code. I use this because sometimes, I don't know how many items there will be in the ArrayList to prepare columns. (Make sure you use a symbol that you're sure won't be present in any of your items).

Posted 19-Jul-18 21:07pm

Member 13919202

Comments

CHill60 20-Jul-18 8:00am

This is a truly awful way to go about things. Never concatenate things into a single string to store them - one item = one row on a table! If you don't know how many there are going to be it doesn't matter. Learn about Foreign Keys

Store ArrayList in SQL Database

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0