Hi,
I have a very hard time to insert Image into Sqlce Database.
Table : Test
Column : mypic
Datatype : image
below the code while i am inserting
signFile.txt is already captured image's conversion into txt file
FileStream stream = new FileStream("\\SignFile.txt", FileMode.Open, FileAccess.Read);
BinaryReader reader = new BinaryReader(stream);
byte[] photo = reader.ReadBytes((int)stream.Length);
reader.Close();
stream.Close();
SqlCeCommand cmd = new SqlCeCommand("INSERT INTO Test (mypic) " +
" VALUES (@mypic)", conn);
cmd.Parameters.Add("@mypic", SqlDbType.Image, photo.Length).Value = photo;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
While i am doing it's giving an error that "There was an error parsing the query.[Toekn line no, Token line offset....] "
Can any one help me with this???
Thanks in advance.