How to get Binary data in c#

Question

I stored my data in sqlserver column type is image that is data is stored in binary format. I just want to read that data and write in to a file How can i achieve this ? Guid me

hey_mr_art · Answer

Hi Try this code: try { SqlConnection cn = new SqlConnection(strCn); cn.Open(); //Retrieve BLOB from database into DataSet. SqlCommand cmd = new SqlCommand(SELECT BLOBID BLOBData FROM BLOBTest ORDER BY BLOBID cn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds BLOBTest); int c = ds.Tables[BLOBTest].Rows.Count; if(c>0) { //BLOB is read into Byte array then used to construct MemoryStream //then saved to a file. Byte[] byteBLOBData = new Byte[0]; byteBLOBData = (Byte[])(ds.Tables[BLOBTest].Rows[c - 1][BLOBData]); MemoryStream stmBLOBData = new MemoryStream(byteBLOBData); Image image = Image.FromStream(stmBLOBData); image.Save(@c:	est.bmp); } cn.Close(); } catch(Exception ex) {MessageBox.Show(ex.Message);}