I have a issue in downloading tiff file from sql server columns. The data type is image or varbinary(max). Kindly tell me how can i download this tiff file into any folder of my harddisk by using asp.net c sharp code
Storing the images in the filesystem will give you better performance. You just need to put an entry into a relevant database table for the tiff image attachments - and use that to get the path of the image on the filesystem.
You might want to further boost performance by hosting the images on a web server - IIS (if relevant) and have your client applications (again if relevant) retrieve them directly frmo there instead.
Actually its my requirement to store the image in database. Ihave stored the image perfectly but the issue is coming in retrieving/downloading it in tiff format from database field. Kindly provide any solution for this issue
This not only converts jpg to tiff formats but also allows the conversion of other picture formats to tiff. This does solve my problem for sure. But if there is something else in anyone's mind, they are welcome to share their valuable ideas.
atahmed
Member
5 Points
4 Posts
How to download TIFF image which is stored in sql server
Dec 15, 2012 05:23 PM|LINK
Hi All,
I have a issue in downloading tiff file from sql server columns. The data type is image or varbinary(max). Kindly tell me how can i download this tiff file into any folder of my harddisk by using asp.net c sharp code
RameshRajend...
Star
7983 Points
2099 Posts
Re: How to download TIFF image which is stored in sql server
Dec 15, 2012 05:30 PM|LINK
Storing the images in the filesystem will give you better performance. You just need to put an entry into a relevant database table for the tiff image attachments - and use that to get the path of the image on the filesystem.
You might want to further boost performance by hosting the images on a web server - IIS (if relevant) and have your client applications (again if relevant) retrieve them directly frmo there instead.
Vipindas
Contributor
5514 Points
810 Posts
Re: How to download TIFF image which is stored in sql server
Dec 15, 2012 05:34 PM|LINK
Refer this
http://weblogs.sqlteam.com/randyp/archive/2008/11/20/60771.aspx
atahmed
Member
5 Points
4 Posts
Re: How to download TIFF image which is stored in sql server
Dec 15, 2012 05:35 PM|LINK
Actually its my requirement to store the image in database. Ihave stored the image perfectly but the issue is coming in retrieving/downloading it in tiff format from database field. Kindly provide any solution for this issue
RameshRajend...
Star
7983 Points
2099 Posts
Re: How to download TIFF image which is stored in sql server
Dec 15, 2012 05:41 PM|LINK
Convert between formats
This not only converts jpg to tiff formats but also allows the conversion of other picture formats to tiff. This does solve my problem for sure. But if there is something else in anyone's mind, they are welcome to share their valuable ideas.
http://stackoverflow.com/questions/4749809/setting-contenttype-image-tiff-and-sending-an-image-is-not-working-in-ie