[dba-VB] Signature capture in ASP.NET / VB.NET

Hey Doug,

Thanks for the help and sample code.  I decided to follow your example and
store the sig as a jpg image in a folder.  Now, I need to ask you what you
did with the signatures, and how?  

Jeff Barrows
MCP, MCAD, MCSD
 
Outbak Technologies, LLC
Racine, WI
jeff.developer at gmail.com

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Friday, November 11, 2011 10:04 AM
To: Discussion concerning Visual Basic and related programming issues.
Subject: Re: [dba-VB] Signature capture in ASP.NET / VB.NET

Hi Jeff:

We just use SuperSignature as they suggested - to save a file to a folder on
the server.  But I do retrieve the signature data first as a
System.Drawing.Bitmap, then convert it to a jpg and save it.  I assume that
you could write the Bitmap to a blob field in SQL.  Sorry, the code is C#:

// signature is returned as bitmap if no path specified
System.Drawing.Bitmap BM = ctlSignature.SaveSignature("");
   if (!ctlSignature.SignHasError)
   {
       // Save the image in JPEG format.
       BM.Save(Server.MapPath("~/sigs/sign.jpg"),
System.Drawing.Imaging.ImageFormat.Jpeg);
   }
        else
  {
       Response.Write("Error:" + ctlSignature.SignInternalError);
   }

Hope this helps!
Doug





On Fri, Nov 11, 2011 at 5:30 AM, Jeff B <jeff.developer at gmail.com> wrote:

> OK, I guess I need to add some more information.
>
> We purchased a signature control from WebSignatureCapture.  When I 
> discovered that their control would not work for our site, they 
> referred me to their sister-site, SuperSignature.
>
> I have worked with their support team as I could not get the signature 
> box to show up on the published site, (it was a VS 2010 issue).
>
> It now appears that things are working ok, but I want to verify that 
> the image is actually being stored in SQL, and I am currently having 
> issues retrieving the image from SQL.  Does anyone have some code they 
> are willing to share that retrieves images?  And the code you use to 
> store it?  (if I am not asking for too much?)
>
>
> Jeff Barrows
> MCP, MCAD, MCSD
>
> Outbak Technologies, LLC
> Racine, WI
> jeff.developer at gmail.com
>
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Doug Steele
> Sent: Thursday, November 10, 2011 6:01 PM
> To: Discussion concerning Visual Basic and related programming issues.
> Subject: Re: [dba-VB] Signature capture in ASP.NET / VB.NET
>
> I did this for a client's app (in C#).  We went with SuperSignature:
>
> http://www.supersignature.com/
>
> If I remember, SuperSignature had a lot fewer options than 
> RealSignature, but did what we wanted (simple signature capture on a 
> web app focused on iPhone use) and was considerably cheaper.
>
> Their copy protection is a little quirky, but their tech support was 
> helpful.
>
> Doug
>
> On Thu, Nov 10, 2011 at 2:37 PM, David McAfee <davidmcafee at gmail.com>
> wrote:
>
> > My coworker is doing that very same thing, but I believe in C#.
> >
> > This is  where he went for the custom control: realsignature.com
> >
> > He said it includes the license file.
> >
> > It looks like they have VB.Net samples on their site.
> >
> > HTH,
> > David
> >
> > On Thu, Nov 10, 2011 at 2:33 PM, Jeff B <jeff.developer at gmail.com>
> wrote:
> >
> > > Does anyone here have experience writing web pages in ASP.NET that
> > require
> > > online signatures?  I have a website ALMOST finished that needs 
> > > users to sign on an iPad and I need to capture the signature, save 
> > > it into an SQL Server 2005 database, and extract the signature 
> > > back out
> to a PDF.
> > >
> > >
> > > Jeff Barrows
> > > MCP, MCAD, MCSD
> > >
> > > Outbak Technologies, LLC
> > > Racine, WI
> > > jeff.developer at gmail.com
> > >
> > >
> > >
> > > _______________________________________________
> > > dba-VB mailing list
> > > dba-VB at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-vb
> > > http://www.databaseadvisors.com
> > >
> > >
> > _______________________________________________
> > dba-VB mailing list
> > dba-VB at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-vb
> > http://www.databaseadvisors.com
> >
> >
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>
_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com