With sql 2005 this is not such a bad thing to do any longer. They also have
varbinary(max) where you can just pass a byte[] or SqlBinary(I think) to a
stored proc using the sqlclient. For large byte[] (i.e. MBs or GBs) you
can't just load them in memory to pass, so you need to chunk it up.
Chunking down is on msdn and is ~easy, but a chunking upload to the db is a
bit more work. I have an up/down sample I did using varbinary(max) and new
..Write with Update TSQL/SP few weeks ago. I will try to get it up on my
blog. Any interest?
--
William Stacey [MVP]
"Hrvoje Voda" <hr*********@luatech.com> wrote in message
news:d8**********@ss405.t-com.hr...
How to insert a blob arraylist into database?
I know it's not good, but my customers want that, so if someone has some
simple example of how to do it...
Hrcko