Agreed - just depends on your situation - whether you're storing just a couple of small gifs or a bunch of large photographs, whether you have a small one-server operation or a large server farm with load balancers and proxy servers and mega security, what you're actually doing with those images, etc.
On Nov 21, 11:11 am, "Stephen Russell" <[EMAIL PROTECTED]> wrote: > 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 - > > 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
