Home:ALL Converter>How To Save datagridview image column in sql server 2008 database using WinApp C#?

How To Save datagridview image column in sql server 2008 database using WinApp C#?

Ask Time:2013-04-30T23:39:03         Author:kalai

Json Formatter

In my project I'm using a DataGridView with 32 columns of textbox and 1 column as Image column . My question is how to insert the DataGridView image column to the database (sql server 2008)? I've written same codings below but it doesn't work. Showing error message.

My coding is :

memorystream stream = new memorystream();
string filename=datagridview1.Cells[33].Value;
bitmaps image=new bitmaps(filename);
image.Save(stream,system.Drawing.Imaging.Imageformat.Jpeg)
byte[] pic=new byte(image);

Author:kalai,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/16303751/how-to-save-datagridview-image-column-in-sql-server-2008-database-using-winapp-c
yy