Image insertion to ss2005 from Windows Mobile

Hi ,

I am trynig to insert an image from the Windows mobile to the SQL database.

Is it possible to perform this using RDA ?

After some search in this forum , I got an impression that the only way to do this by storing the image in a local database and then do a merge replication.

I do not want to do the merge replcation just fo rthis reason.

Is it possible in RDA?

Debugging shows only some part of the data is getting updated.

While trying to retrieve the image in a webpage error is poping up.

My code is :

string strbytes = (Convert.ToBase64String(bytes)).ToString();

DbObj.GetSubmitSql("Update Odrs set SignedBy ='" + txtSign.Text + "', Signature = Convert(Image,'" + bytes + "') where OrderId=" + orderNo + "");

Please help....

No, that is not possible to do using SqlCeRemoteDataAccess.SubmitSql() which I presume you’re trying to use.

Use SQL Client and use parameters to pass a byte array with image instead.