Saving image as OLE Object

[Sl1ver]

i've got this piece of coding. i need help with opening a picture box and then saving it as OLE Object in access DB

How would i massage this code tho fit in?

try
{
   //save image to byte array and allocate enough memory for the image
   byte[] imagedata = image.ToByteArray(new Atalasoft.Imaging.Codec.JpegEncoder(75));
 
   //create the SQL statement to add the image data
   myConnection = new OleDbConnection(CONNECTION_STRING);
   OleDbCommand myCommand = new OleDbCommand("INSERT INTO Atalasoft_Image_Database (Caption, ImageData) VALUES ('" + txtCaption.Text + "', ?)", myConnection);
   OleDbParameter myParameter = new OleDbParameter("@Image", OleDbType.LongVarBinary, imagedata.Length);
   myParameter.Value = imagedata;
   myCommand.Parameters.Add(myParameter);
 
   //open the connection and execture the statement
   myConnection.Open();
   myCommand.ExecuteNonQuery();
}
finally
{
   myConnection.Close();
}
 

Here is my open file code (works fine)

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) + "\\" + openFileDialog.FileName;
                FullFileName = openFileDialog.FileName; 
                txtComp_Image.Text = path;
 
 
            }
            else
            {
                return;
            }
 

and here is my insert code

 string UpdateStr = "";
            if(count == 0)
            {
 
 
                int i = 1;
                UpdateStr = "Insert into qx_Company " +
                                          "(AST__ID, AST__NAME, AST__STREET, AST__TOWN, AST__CITY, AST__TEL, AST__FAX, AST__MAIL, AST__SITE, AST__POST, AST__PATH )" +
                                          "values('" + i.ToString() + "','" + txtComp_Name.Text + "','" + txtComp_Street.Text + "','" + txtComp_Town.Text + "','" + txtComp_City.Text + "','" + txtComp_Tel.Text + "','" + txtComp_Fax.Text + "','" + txtComp_Email.Text + "','" + txtComp_Website.Text + "','" + txtComp_Box.Text + "','" + txtComp_Image.
 

as i said, i just want to save the picture as a OLE Object
Help is much appreciated.

[Curtis Rutland]

Notice how in the first piece of code that they use parameters instead of long string concatenation?

OleDbCommand myCommand = new OleDbCommand("INSERT INTO Atalasoft_Image_Database (Caption, ImageData) VALUES ('" + txtCaption.Text + "', ?)", myConnection);
OleDbParameter myParameter = new OleDbParameter("@Image", OleDbType.LongVarBinary, imagedata.Length);
myParameter.Value = imagedata;
myCommand.Parameters.Add(myParameter);

When this code is executed, the OleDbCommand will replace the "?" with the parameter's value...which in this case is a byte[].

In the open file part of your code, you should use a System.IO.FileStream to read the file's contents into a byte[] and use that for the parameter to insert into the DB.

Make sure you always close any Streams you open.