Wednesday, August 3, 2011

Code for store and fetching image from database in ms access.

//// its code for store image in ms access database ,,,first make datatype of image as oledb object if u r using oledb.


MemoryStream msStream = new MemoryStream();
if (txtImage.Text == "")
{
pictureBox1.Image = Image.FromFile(@"D:\DataPresales\Layouts\NoImageAvailable.jpeg");
//pictureBox1.Image = resizeImage(pictureBox1.Image, PicWidth, PicHeight);
pictureBox1.Image.Save(msStream, System.Drawing.Imaging.ImageFormat.Bmp);
//pictureBox1.Image.Save(msStream, pictureBox1.Image.RawFormat);

byte[] data = msStream.GetBuffer();
ob.Photo = data;


}






// its code for fetching image from ms access database,,,,,,



byte[] PreImage = (byte[])ds.Tables[0].Rows[0]["Photo"];
MemoryStream ms = new MemoryStream(PreImage);
pictureBox1.Image = Image.FromStream(ms);


// where ds is object of Dataset in which we are fetching whole data.and "Photo" is column name for image.

1 comment:

Pravin Dubey said...

मिथिलेश बाबू ख्वाबो का उड़ना ठीक बात नही इन्हे तो पालने की ज़रूरत है..