c# saving a 2D array into the DB

E

EFileTahi-A

Well-known member
Joined
Aug 8, 2004
Messages
539
Location
Portugal / Barreiro
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!
 
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.
 
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]
 
Back
Top