Comments by Ism Oss (Top 5 by date)

still have -> Additional information: Syntax error (missing operator) in query expression 'System.Byte[]'.

my code->
using (OleDbCommand cmdimage = new OleDbCommand("update PatientVisit set Barcode = "+ Exportimage+" where DNo =" + Convert.ToInt32(DNo.Text) + " and VDate like '" + VDate.Text + "'",helper.con))
{
cmdimage.Parameters.Add("Barcode",OleDbType.VarBinary);
cmdimage.Parameters["Barcode"].Value = Exportimage;

cmdimage.ExecuteNonQuery();

}

also tried AddWithValue

How we can do this?

byte[] image=imagetobyte(picturebox1.Image);

String sqltext="update [table] set [column]="+image+" where id='"+Textbox1.Text+"'";

Note:imagetobyte() is own method

How to represent a form control ,e.g text box , As a record in mdb database table for updating or adding or deleting while using odbc in c++\clr application