Store and Retrieve Images in SQL Server Database through VB.NET

Question

Hi How to store and retrieve images in SQL server database through VB.NET ?

Satyapriya Nayak · Answer

Hi Arun Please refer the below links http://www.c-sharpcorner.com/UploadFile/satyapriyanayak/add-details-of-an-employee-with-image-and-display-it-into-a/ http://www.c-sharpcorner.com/UploadFile/satyapriyanayak/how-to-save-image-along-with-details-into-database-in-asp-ne/ Thanks

Mayur Gujrathi · Answer

byte[] Imag = null; string finalpath = null; finalpath = Server.MapPath(destpath); FileStream fs = new FileStream(finalpath System.IO.FileMode.Open System.IO.FileAccess.Read); Imag = new byte[fs.Length]; fs.Read(Imag 0 Convert.ToInt32(fs.Length)); fs.Close(); And then store Imag variable in sql server database Its datatype should be varbinary in sql table