http://www.codeproject.com/aspnet/PicManager.asp How to upload files to Web pages in ASP.NET? How to read an image from a database using ADO.NET and display it in a Web page?
http://www.codeproject.com/useritems/EasyThumbs.asp Shows how to store images in SQL Database Image Storage & create Thumnails easiliy from
http://www.codeproject.com/useritems/images_in_sql_server.asp It example show how insert any image in sql server and perharps other types
http://www.codeproject.com/cs/database/DBViewer.asp A simple database viewer to manipulate SQL Server data types (in particular: image, binary, varbinary and text).
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
vrsanaidu >inserting image into database is not a good thing, after wide usage of your website drastically performance will be decrease.
Vrsanaidu is correct; storing images in the database makes the database significantly bigger, thus fewer rows can be help in a given amount of memory, leading to a fall-off in performance as the database size increases..
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
one way around this, the way i use, is to store the location of the image in the database then read the location as a string then seting to a property as the page is called.
icelotus> one way around this, the way I use, is to store the location of the image in the database then read the location as a string then seting to a property as the page is called.
This is a better way than storing the images directly. It is however preferable to store a relative path such that C:\FRED\UPLOAD can be moved to D:\DINGBAT\FRED\UPLOAD and just change one parameter.
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
>I add just the file name to the database, that way per site I can move the image directory as needed as by make the path a variable such that,
If the number of files is small then this is perfectly OK. There may however be reasons to subdivide the upload directory into a number of directories, hence a partial path name may need to be stored.
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
postmaster
Member
89 Points
24 Posts
Upload Images into SQL Server and display on DataGrid in ASP.NET
Apr 25, 2007 07:55 PM|LINK
SQL Server, Images and DataGrid in ASP.NET
How to upload Images to SQL Server database using ASP.NET tools.
Also retrieve saved images from SQL Server and display them onto DataGrid.
TATWORTH
All-Star
72415 Points
14017 Posts
MVP
Re: Upload Images into SQL Server and display on DataGrid in ASP.NET
Apr 25, 2007 08:29 PM|LINK
See the following:
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
ameenkpn
Contributor
4805 Points
814 Posts
Re: Upload Images into SQL Server and display on DataGrid in ASP.NET
May 23, 2008 08:39 AM|LINK
Check this articles
http://www.aspdotnetcodes.com/Insert_Images_Database.aspx
Thanks
Inserting images into database and display it in GridView
vrsanaidu
Member
421 Points
194 Posts
Re: Upload Images into SQL Server and display on DataGrid in ASP.NET
May 23, 2008 12:22 PM|LINK
Naidu.
http://www.questkt.com
TATWORTH
All-Star
72415 Points
14017 Posts
MVP
Re: Upload Images into SQL Server and display on DataGrid in ASP.NET
May 25, 2008 04:47 PM|LINK
vrsanaidu >inserting image into database is not a good thing, after wide usage of your website drastically performance will be decrease.
Vrsanaidu is correct; storing images in the database makes the database significantly bigger, thus fewer rows can be help in a given amount of memory, leading to a fall-off in performance as the database size increases..This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
icelotus
Member
4 Points
2 Posts
Re: Upload Images into SQL Server and display on DataGrid in ASP.NET
May 26, 2008 02:30 PM|LINK
one way around this, the way i use, is to store the location of the image in the database then read the location as a string then seting to a property as the page is called.
TATWORTH
All-Star
72415 Points
14017 Posts
MVP
Re: Upload Images into SQL Server and display on DataGrid in ASP.NET
May 27, 2008 10:07 AM|LINK
icelotus> one way around this, the way I use, is to store the location of the image in the database then read the location as a string then seting to a property as the page is called.
This is a better way than storing the images directly. It is however preferable to store a relative path such that C:\FRED\UPLOAD can be moved to D:\DINGBAT\FRED\UPLOAD and just change one parameter.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
icelotus
Member
4 Points
2 Posts
Re: Upload Images into SQL Server and display on DataGrid in ASP.NET
May 28, 2008 02:02 AM|LINK
i add just the file name to the database, that way per site i can move the image directory as needed as by make the path a variable such that,
src = <path> + <%#Eval("ImgName")%>
this way the images can move and you dont have to change your database at all
TATWORTH
All-Star
72415 Points
14017 Posts
MVP
Re: Upload Images into SQL Server and display on DataGrid in ASP.NET
May 28, 2008 11:11 AM|LINK
>I add just the file name to the database, that way per site I can move the image directory as needed as by make the path a variable such that,
If the number of files is small then this is perfectly OK. There may however be reasons to subdivide the upload directory into a number of directories, hence a partial path name may need to be stored.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239