Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 STORNG IMAGES IN SQL WITH ASPX FORMS

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-02-16 : 08:14:29
chris writes "I want to setup a sql database that can store images.
Images that can be retrived/stored using aspx web form.

Any help appreciated."

jhermiz

3564 Posts

Posted - 2005-02-16 : 10:36:16
Store the image on a network resource. In your db table store the path and any other relevant information you need.
In your aspx page you can easily build a page which allows you to hyperlink to, or reference these images.

Good luck,
Jon



Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page

sanu_s
Starting Member

2 Posts

Posted - 2005-02-16 : 12:09:55
Any help appreciated."
As jhermiz said it is the best way to store the photos and
display them on aspx page. But if at all you want to store them
in SQL Server define column datatype as Image and store the image
in it. Storing and retriving will be the conventional way of streaming
the data and saving it or retriving it.
Go to Top of Page
   

- Advertisement -