Store System.Array in SQL ???

[duongthaiha]

Hi

I am having a object System.Array and i want to store in SQL database.The object will be array of byte, but in SQL server doesn't have anytype to store that. Can you please tell me what is the most appropriate data type in SQL that i should use? Do i need conversion to store and get data in SQL database.

Thanks a lot for your help. I reall do appreciate that.

Maverick

[WarlockSoul]

You could store this in a VarBinary or xml.

[hspc]

If the array is large, you can store it in image field
this article explains this:
http://www.codeproject.com/cs/database/ImageSaveInDataBase.asp