Bitmap from stream or byte[]

/*this example will show you how to get a stream from a database and then save into file and read it again as an image, be sure to save the right format in the database */ string sql = "Select * from Users"; con1.Open(); OleDbCommand com1 = new OleDbCommand(sql,con1); OleDbDataAdapter myAdapter = new OleDbDataAdapter(sql,con1); DataSet myDataSet = new DataSet("Users"); OleDbCommandBuilder builder = new OleDbCommandBuilder(myAdapter); myAdapter.Fill(myDataSet); DataRow dataRow = myDataSet.Tables[0].Rows[0]; byte[] rawData = new byte[0]; rawData = (byte[])dataRow["UserPhoto"]; int len = rawData.GetUpperBound(0); FileStream fs = new FileStream(savedImageName,FileMode.OpenOrCreate,FileAccess.Write); fs.Write(rawData,0,len); fs.Close(); curImage = Image.FromFile(savedImageName); pictureBox1.Image = curImage; con1.Close(); // Later if you want to know how to get it from a memory stream direct to image tell me.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

zsafadi22y ago
/*this example will show you how to get a stream from a database and then save into file and read it again as an image, be sure to save the right format in the database */ string sql = "Select * from Users"; con1.Open(); OleDbCommand com1 = new OleDbCommand(sql,con1); OleDbDataAdapter myAdapter = new OleDbDataAdapter(sql,con1); DataSet myDataSet = new DataSet("Users"); OleDbCommandBuilder builder = new OleDbCommandBuilder(myAdapter); myAdapter.Fill(myDataSet); DataRow dataRow = myDataSet.Tables[0].Rows[0]; byte[] rawData = new byte[0]; rawData = (byte[])dataRow["UserPhoto"]; int len = rawData.GetUpperBound(0); FileStream fs = new FileStream(savedImageName,FileMode.OpenOrCreate,FileAccess.Write); fs.Write(rawData,0,len); fs.Close(); curImage = Image.FromFile(savedImageName); pictureBox1.Image = curImage; con1.Close(); // Later if you want to know how to get it from a memory stream direct to image tell me.