How to store and retrieve a Signature content in SQL database?

Description

The Signature control by default records the drawn signature in Base64 string format for later regeneration. Hence, we can use this to store and retrieve the signature in SQL database.

Solution

To store the drawn signature image in the SQL database, follow the steps below:

1. Define a Signature control and buttons for Save and Restore the signatures from database.
2. On client side click handler, get the signature content and convert it to the Base64 string value by using the canvas toDataURL() function and then pass it the  code behind by using jQuery AJAX or AJAX ScriptManager PageMethods.

Refer to the code for control creation - [Default.aspx]

3. Now, establish a connection to the database SQL and then need to store it in the database table.
4. The same way is required to retrieve the stored canvas string from the database.
5. We have set our system location for the local database file.  So, we suggest you change to your local system location like below.

Result

The below image shown, when the signature image is updated successfully on the database.

The below image shown, after retrieving the signature image from database.

The demo sample is also prepared, and it is available in the following link:

Signature sample