Another Q Regarding a Picture BOX, Savind to Access DB

[Sl1ver]

hi there
here's my code, it get and displays the image for a preview but i can't save it to my access DB i really need help with this one

 public void openBMP(String filename)
        {
            //Declare the OpenFileDialog as a new OpenFileDialog.
            OpenFileDialog openFileDialog = new OpenFileDialog();
            //Declare the PictureBox as a new PictureBox
            //PictureBox pic = new PictureBox();
            //Set the openFileDialog's Filter.
            openFileDialog.Filter = "Bitmap Image|*.bmp|All Files|*.*";
            //Set the openFileDialog's FileName to nothing.
            openFileDialog.FileName = "";
            string path = "";
            //Show the openFileDialog
            if (openFileDialog.ShowDialog(this) == DialogResult.OK)
            {
                //To do code if the Open button was pressed
                //Use something like:
                filename = openFileDialog.FileName;
                pic.Image = Image.FromFile(filename);
                pic.Size = new System.Drawing.Size(280, 140);
                pic.SizeMode = PictureBoxSizeMode.CenterImage;
                path = System.IO.Path.GetDirectoryName(openFileDialog.FileName);
                txtComp_Image.Text = path;
            }
            else
            {
                return;
            }
 

[tlhintoq]

here's my code, it get and displays the image for a preview but i can't save it to my access DB

You've shown us the code you state already works (open/preview image)... but none of the code that you are having problems with (save to Access db). Please show us what you are trying along with the error(s) you are getting from your save routine.

[Sl1ver]

Problem is i dont know how to convert it so that it will get inserted into the DB as OLE object. The other text boxes and everything inserts fine. i just would like to know how to convert the image.

[tlhintoq]

Maybe covert to/from a byte array?
Since I don't deal with databases I've never had to deal with this issue.
Anyone else?

[PRR]

1. Read the image as byte[].. FileStream
2. Use Sqlparameter of type image... Value as byte[]...Look into SqlDbType.Image

[balame2004]

Try this code sample to insert image into database table.

System.IO.MemoryStream ms = new System.IO.MemoryStream();
            Image img = Image.FromFile(@"C:\Documents and Settings\balaji.umapathi\Desktop\Arrow.PNG");
            img.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
            System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
            cmd.CommandText = "INSERT INTO ImageDataTable(ImageName,ImageData) VALUES('Arrow.PNG',@Image)";
            System.Data.SqlClient.SqlParameter param = new System.Data.SqlClient.SqlParameter("@Image",SqlDbType.Image);            
            param.Value = ms.GetBuffer();
            cmd.Parameters.Add(param);
            cmd.ExecuteNonQuery();

[Sl1ver]

The problem is that i dont know to save the picturebox image as OLE Object in an access database

[PRR]

You need to save the image not the picturebox...