can anyone,
        plz forward m code for updating& retrieval of images from sql-server using vb.net...
                 plz its very urgent..
 regards,,,
preetham

preet

__________________
preet

I haven't worked with this in .NET, only in Dreamweaver using classic ASP, so I'm not sure of the exact syntax mind you. But basically you want to store the images in your image folder like normal. Database calls are one of the slowest things you can make your application do and transmitting an entire file borders on suicidal. If you can avoid storing the actual images on the database your application will run substantially faster, if you can't best of luck to you.

The way you typically eliminate the need to store images, is you create a text field and populate it with the pathname to the image "Images/mypic.jpg" or whatever. Then it's just the paths that are stored as text in the DB and that tells your page where to get the image from.

-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.

Hi preet,

Did you search Google or the P2P internal search engine for this? There are many many good resources about this subject.

For an article discussing the different options you have (store files on disk or in a database) and their pro and cons, take a look here: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=414

I have said it before and I'll say it again: adding "it's very urgent" to your messages generally doesn't help. Of course it's urgent, or otherwise you wouldn't be posting it here. However, that doesn't make it urgent for those posting answer. They'll post, if and when they have the time. If it is really so urgent, you should have searched Google yourself which would have gotten you an answer hours ago.... ;)

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

Look at this thread:

http://p2p.wrox.com/topic.asp?TOPIC_ID=63720

hi imar,
         thanks for the reply-inspite i tried in google,i couldnt get the desired format.even the url provided,is blocked in m office system(http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=414)..
                                plz send m code in vb.net(web-form),vs-2005,without using procedures...
regards,
preetham

preet

Hi preet,

Why would your office block my site? Tell your admin that's a mistake ;)

Anyway, I don't go out and "send y code in vb.net" just like that, especially if it's publicly available from my server. Also, since it uses stored procedures by design, you're asking quite something when you say: "plz send m code in vb.net(web-form),vs-2005,without using procedures...". Ask your admin to open up the server for my site, download the code, read the article and diagnose the code and then make it procedure-less yourself.... ;)

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004