We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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]

 

  1. Now, establish a connection to the database SQL and then need to store it in the database table.
  2. The same way is required to retrieve the stored canvas string from the database.
  3. 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

Article ID: Published Date: Last Revised Date: Platform: Control:
7234 01/12/2017 10/09/2018 ASP.NET Web Forms Signature
Did you find this information helpful?
Comments
Qanita Ahmad Dec 28, 2017

How can we do something similar in ASP NET Core?

Reply
Add Comment
You must log in to leave a comment

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon