I am new in vb.net...so please can you tell me the code for storing photo in database...I am using sql server 2005 and vb.net 2005...I need it for my project...
In general storing large binary objects (BLOB) in a database is a bad idea - makes sense only sometimes. Usually it's better to store the file in the filesystem (hint hint) and in the database just store the path.
This might help though: Store and Retrieve Images in SQL Server database Articles, samples and tutorials
keyword for google: BLOB (plus SQL server, vb etc)
i'd agree with picoflop on the "bad idea" - putting images into a db makes data recovery much harder and data corruption much more likely.. If you must do it as homework, then go ahead, but try to avoid doing it in your professional career
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.