Something like this:
Here the SigData table has a column Signature of type Image. This column contains full .bmp file data. Notice that there is an issue of creating a BMP file out of Bitmap object. Basically it is not possible without taking some drastic measures (
http://www.opennetcf.org/Articles/GdiObjects.asp). It is rather easy to do if you capture parts of the screen using Windows API
Retrieving:
SqlCeCommand cmd = GlobalClass.Global.Connection.CreateCommand();
cmd.CommandText = "select Signature from SigData where id = " + ID.ToString();
SqlCeDataReader rdr = cmd.ExecuteReader();
if ( rdr.Read() )
{
MemoryStream ms = new MemoryStream(rdr.GetSqlBinary(0).Value);
Bitmap bm = new Bitmap(ms);
pbSignature.Image = bm; // pbSIgnature is a picturebox
}
Inserting:
SqlCeCommand cmd = myConnection.CreateCommand();
cmd.CommandText = string.Format("insert into SigData (id, Signature) values( ?, ? )");
cmd.Parameters.Add("id", SqlDbType.Int).Value = ID;
byte[] Sig;
// Populate the array with the byte representation of the image
// How to do it is a subject for a separate discussion
...
//
SqlCeParameter param = cmd.Parameters.Add("Signature", SqlDbType.Image, Sig.Length);
param.Value = Sig;
cmd.ExecuteNonQuery();
