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

Jeff B jeff.developer at gmail.com
Thu Dec 1 11:05:18 CST 2011


Right, but what I am trying to figure out is how to pull the image up and
add it to the report.

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, December 01, 2011 10:47 AM
To: Discussion concerning Visual Basic and related programming issues.
Subject: Re: [dba-VB] Signature capture in ASP.NET / VB.NET

Hi Jeff:

The customer signatures were collected by the iPhone web app as part of a
work order tracking system.  The work order number was the start of the
signature file name. The main processing was done back at the office with an
Access database.  When a work order was being processed, the office user
could check the signature (pulled into an imagebox on the edit screen), and
when the invoice was printed, the signature was printed with it.

I kept the signature files separate from the Access data file partly to keep
the bloat down to a minimum.

Doug

On Thu, Dec 1, 2011 at 8:22 AM, Jeff B <jeff.developer at gmail.com> wrote:

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





More information about the dba-VB mailing list