[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
>
>