c# saving a 2D array into the DB

[EFileTahi-A]

Hello,

 

Is it possible to save a full string array into an Access data base? What kind of field will it require? I saw an OleObject field property which can old binary data, but I have no ideia what step should I make next...

 

Please aid.

 

tks!

[EFileTahi-A]

I got no posts yet, please, if my thread is not explicit enough let me know about it...

 

cheers!

[PlausiblyDamp]

You could serialze the array into a blob field, or possibly turn it into a delimited string and store that.

Is there a reason you need to fit this into a single field? Could you not store the elements within a seperate table and use a PK/ FK relationship to associate them with the parent record?

Without a bit more detail on the size of the array and the strings it contains and the possible contents it is a bit difficult to say what method may be best.

[EFileTahi-A]

Hi, tks for the reply...

 

I would just like to save an string array into the database, if the array contais 3 fields or 3000 is not relevant. But I need to know this:

 

1 - Can I directly save it into db as an Ole Object or something?

2 - If so, I would like to know about loading it too.

3 - I could save the string array to a binary file on HD then sending the file

to the DB if I knew how...

 

"You could serialze the array into a blob field, or possibly turn it into a delimited string and store that".

 

PS: what is serialize the array into a blob field?, what is: turn it into a delimited string? Is it put all array fields in one full length string? Well if so, thats what am doing, but when I load it, I have to store it again into the array file thus, giving me more code to do. thats why am trying to avoid.

 

Anyway the array config am using its as follows: sFilterConfig[80,3]