Save image to sql.

Hello, lately I have been triying to create a code to upload an image into my sql database from visual cobol 2012. I have done this in C# with 

byte[] image
object o = Clipboard.GetDataObject().GetData("Bitmap");
if (o != null)
{
pictureBox.SizeMode = PictureBoxSizeMode.StretchImage;
pictureBox.Image = (Image)o;
}

using (MemoryStream ms = new MemoryStream())
{
pictureBox.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
image = ms.ToArray();
}

Im not sure how I can do " pictureBox.Image = (Image)o;"  in visual cobol, since im stuck there I haven't tried to code the rest but I don't think that would be any problem.

How can I manage to do this task in visual cobol? 

Parents
  • Verified Answer

    For the previous error you can try changing this line to:

        set pictureBox1::Image to o as type System.Drawing.Image

    What database are you using?

    Open up the Samples Browser under the Visual COBOL start menu and click on SQL on the left had side and then select and open up the managed LOB Data Types example. This shows how you can store an image field in a SQL database using OpenESQL.

Reply
  • Verified Answer

    For the previous error you can try changing this line to:

        set pictureBox1::Image to o as type System.Drawing.Image

    What database are you using?

    Open up the Samples Browser under the Visual COBOL start menu and click on SQL on the left had side and then select and open up the managed LOB Data Types example. This shows how you can store an image field in a SQL database using OpenESQL.

Children
No Data