Jeff B
jeff.developer at gmail.com
Thu Dec 1 11:16:39 CST 2011
Ok, thanks for your help!
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 11:08 AM
To: Discussion concerning Visual Basic and related programming issues.
Subject: Re: [dba-VB] Signature capture in ASP.NET / VB.NET
Sorry, neither of the ASP.Net apps I've written involved any reporting. In
Access at least, all you have to do is have an image box on the report then
set the source of the image box to the path of the signature file when the
report section loads.
Doug
On Thu, Dec 1, 2011 at 9:05 AM, Jeff B <jeff.developer at gmail.com> wrote:
> 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
>
>
> _______________________________________________
> 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