Insert and retrieve Image in Access 2007 DB from C# App

Question

I need to insert an image in access database that has a column of type OLE Object I tried to use the following code but it gives me a Syntax Error in insert staetment but I am sure of table name and column name and the imageContent value is not null

    System.Data.OleDb.OleDbConnection MyConnection;
    private void Insert_Customer_Load(object sender, EventArgs e)
    {
        string strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Customer.accdb;Persist Security Info=True;Jet OLEDB:Database Password=123";
        MyConnection = new System.Data.OleDb.OleDbConnection(strConn);
    }

    private void InsertBtn_Click(object sender, EventArgs e)
    {
        System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand();
        string sql = null;

        MyConnection.Open();
        myCommand.Connection = MyConnection;
        byte[] imageContent = File.ReadAllBytes(imagePathTxt.Text);
        sql = "INSERT INTO [Customer_Data] (Image) VALUES (@photo)";
        myCommand.CommandText = sql;
        OleDbParameter ph = new OleDbParameter("@photo", OleDbType.VarBinary);
        ph.Value = imageContent;
        ph.Size = imageContent.Length;
        myCommand.Parameters.Add(ph);
        myCommand.ExecuteNonQuery();
        MyConnection.Close();
    }

Also I tried to use ? instead of @photo but also the same exception raised.

Thanks in advance

Gert Arnold · Accepted Answer · 2011-08-26 23:56:52Z

2

I think Image is a reserved word, so maybe it's just that you should use [Image] or, better, rename the column. (BTW, are you sure you want to store images in your database?)

answered Aug 26, 2011 at 23:56

Gert Arnold

110k36 gold badges218 silver badges319 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Meisam · Accepted Answer · 2020-04-02 07:44:43Z

1

rename the column you should use [Image]

answered Apr 2, 2020 at 7:44

Meisam

111 bronze badge

1 Comment

Joe Sonderegger Over a year ago

Please be more specific. Which line of code are you talking about? Where is the column that should be renamed?

Collectives™ on Stack Overflow

Insert and retrieve Image in Access 2007 DB from C# App

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related