Image save in Sql Server using C#

Question

Hi Frnds I Have Table contains columns as emp_id intemp_name varchar(30)emp_image image...For this table i have to save details from C# page.I have converted my image to byte[]. We have dbtypes as follows DbType.Object  DbType.DecimalDbType.BinaryDbType.Int64DbType.byte etc...In this how can send image byte[] to database(what dbtype i have to use).

Neha Sharma · Answer

Hii Refer the following links please : http://www.c-sharpcorner.com/Forums/Thread/190743/store-image-files-in-sql-server.aspx http://www.c-sharpcorner.com/Forums/Thread/191149/how-to-store-images-in-sql-server-2005-database.aspx http://www.c-sharpcorner.com/Forums/Thread/191148/how-to-store-images-in-sql-server-2005-database.aspx http://www.c-sharpcorner.com/Forums/Thread/191148/how-to-store-images-in-sql-server-2005-database.aspx Hope these help youif it helps you mark it as answer.

suresh Palaniyappan · Answer

in your link u r using sqldbtype but i need dbtype

Vithal Wadje · Answer

refer my this article click here http://www.c-sharpcorner.com/UploadFile/0c1bb2/uploading-and-downloading-excel-files-from-database-using-as/ and just change extension of .xls to .jpeg or as your requirement