Using the db for storage is a Catch22 operation.
You get backups, as well as the ability to replicate the db across data centers. You get a rather large db depending on the volume of transactions and the size of the images. YMMV. ………………………………………………………………… Stephen Russell �C Senior Visual Studio Developer, DBA Memphis, TN 901.246-0159 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Brandon Betances Sent: Friday, November 21, 2008 12:02 PM To: [email protected] Subject: [DotNetDevelopment] Re: How to store image in MSSQL Server using C#? better off uploading the image to a folder and referencing the location in the DB. storing a DB takes ALOT of room up and slows you down considerable. I think my homie Stephen will agree with me here. On Fri, Nov 21, 2008 at 3:47 AM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: find this keyword in your MSDN: "Chunking BLOB Updates (ADO.NET)" hopefully, it will be helpful B'Rgds On Fri, Nov 21, 2008 at 10:26 AM, Joe Enos <[EMAIL PROTECTED]> wrote: I'm sure you can find hundreds of samples online of this, but basically, your .NET datatype should be a byte array, and I believe your SQL Server data type should be an IMAGE (SQL 2000) or a VARBINARY (MAX) (SQL 2005+). Once you get this going, it's not all that different than any other data type. On Nov 20, 1:36 pm, "vijaya kumara.N" <[EMAIL PROTECTED]> wrote: > Hi, > > How to store image in SQL Server and retrieve uisng C#. > > Please help me. > > Thanking u. > > -- > Regards, > vijay -- 一日不见如隔百秋 It's not what you can get but what you can give that makes you a rich person No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.9.9/1802 - Release Date: 11/21/2008 9:37 AM
