Hi! I am using the signature capture control from hoodcanalsystems and I have
a question about how the image is saved. Is there a way to compress the image
when it is saved from the control. It seems the signature is saved as a bmp.
Currently, I convert the bmp into a byte array and store it in the database.
But is there an efficient way to store this data in the database, so that the
table storing this data doesn't grow very big.
If there are alternate ways to achieve this, then please post your
suggestions or any resources from where I can get more information.

Thanks for your time!
Regards,
Raj

Check out the sample from
http://msdn.microsoft.com/library/de...gnatureApp.asp.
It saves a series of line segments instead of the entire bitmap, and even
offers enryption support. I don't believe it persists to a DB, but that
shouldn't be too hard to do.

"Raj Kumar" <(E-Mail Removed)> wrote in message
news:95E6330B-3552-4306-A536-(E-Mail Removed)...
> Hi! I am using the signature capture control from hoodcanalsystems and I
> have
> a question about how the image is saved. Is there a way to compress the
> image
> when it is saved from the control. It seems the signature is saved as a
> bmp.
> Currently, I convert the bmp into a byte array and store it in the
> database.
> But is there an efficient way to store this data in the database, so that
> the
> table storing this data doesn't grow very big.
> If there are alternate ways to achieve this, then please post your
> suggestions or any resources from where I can get more information.
>
> Thanks for your time!
> Regards,
> Raj

I am also using the hoodcanal signature control and thus far, byte size has
not been an issue. The other suggestion that Ed proposes is viable, and
would help keep your table size down, but is probably not as handy in
regards to storing in SQLCE.

"Raj Kumar" <(E-Mail Removed)> wrote in message
news:95E6330B-3552-4306-A536-(E-Mail Removed)...
> Hi! I am using the signature capture control from hoodcanalsystems and I
> have
> a question about how the image is saved. Is there a way to compress the
> image
> when it is saved from the control. It seems the signature is saved as a
> bmp.
> Currently, I convert the bmp into a byte array and store it in the
> database.
> But is there an efficient way to store this data in the database, so that
> the
> table storing this data doesn't grow very big.
> If there are alternate ways to achieve this, then please post your
> suggestions or any resources from where I can get more information.
>
> Thanks for your time!
> Regards,
> Raj

Thank you for your input and I am sorry for the delayed response!

Since the signature control from Hood Canal was functioning, I wasn't able
to spend time trying to look into the other options. This control offers a
method SaveToByteArray, which does what I was doing after using the Save
method of the control. I am working with the sample that Ed mentioned and see
if that is a viable option.

Since we are not using SQL Server CE, storing the byte array to the dataset
on the device will not be an issue. Again, size of the image is of concern
here.

Does the Signature control from OpenNETCF allow to store the image in any
other format other than a .bmp file?

Thanks again for your time.
Regards,
Raj
"Raj Kumar" wrote:

> Hi! I am using the signature capture control from hoodcanalsystems and I have
> a question about how the image is saved. Is there a way to compress the image
> when it is saved from the control. It seems the signature is saved as a bmp.
> Currently, I convert the bmp into a byte array and store it in the database.
> But is there an efficient way to store this data in the database, so that the
> table storing this data doesn't grow very big.
> If there are alternate ways to achieve this, then please post your
> suggestions or any resources from where I can get more information.
>
> Thanks for your time!
> Regards,
> Raj