Show Images directly from database
-
-
How can I retrive images directly from datbase and show them in Image1 server control? I have serched on google but not much luck, any suggestion or help is appreciated. Regards.
I Love T-SQL "Don't torture yourself,let the life to do it for you."
-
Blue_Boy wrote:
I have serched on google but not much luck
Luck is not what is required[^] :rolleyes:
led mike
-
How can I retrive images directly from datbase and show them in Image1 server control? I have serched on google but not much luck, any suggestion or help is appreciated. Regards.
I Love T-SQL "Don't torture yourself,let the life to do it for you."
Write a http handler and have it return the bitmap data from the DB. Your image control URL is the URL that returns that data from the HTTP handler. And yes, there's tons of info about this on google.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
Write a http handler and have it return the bitmap data from the DB. Your image control URL is the URL that returns that data from the HTTP handler. And yes, there's tons of info about this on google.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
How can I retrive images directly from datbase and show them in Image1 server control? I have serched on google but not much luck, any suggestion or help is appreciated. Regards.
I Love T-SQL "Don't torture yourself,let the life to do it for you."
There are plenty of articles that talk about storing and retrieving images in SQLServer. What is required more importantly is not the smile of Lady Luck but a diligent effort towards the goal, the first task being research and the first tool in research called as 'Google'.
Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson -
Thanks Chris, I found solution which you are talking about, and I have implemeted it, thanks for your reply...
I Love T-SQL "Don't torture yourself,let the life to do it for you."
-
There are plenty of articles that talk about storing and retrieving images in SQLServer. What is required more importantly is not the smile of Lady Luck but a diligent effort towards the goal, the first task being research and the first tool in research called as 'Google'.
Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson -
Just be aware that the database will increase in size very quickly when you store images in it. An alternative is to store just the URL of the image and use that instead of the actual image. :)