Jump to content

Check out our Community Blogs

Register and join over 40,000 other developers!

Recent Status Updates

View All Updates

- - - - -

Allowing somebody to sign a document if they are in a SQL table?


  • Please log in to reply
1 reply to this topic

#1 randolphb1388


    CC Lurker

  • Just Joined
  • Pip
  • 2 posts

Posted 22 November 2010 - 12:34 AM

Ok, I have an ASP.NET webpage that interacts with a SQL database. When a user is on the page, they are automatically logged in as their first name.last name. On this webpage, there is a section where certain individuals have to sign for the form to be approved. As it is right now, anybody can sign any of the sections, including the user who's form it is. However, I need to make it so only individuals who's names are in a SQL table on the database. Does anybody have any ideas on how I can make this happen?

Thanks in advance,
  • 0

#2 gokuajmes


    CC Devotee

  • Senior Member
  • PipPipPipPipPipPip
  • 483 posts

Posted 24 November 2010 - 08:11 PM

Unless i know the table you use for authenticating the user it would be a waste to write a code snippet for your problem. Here is a psedocode:
1. Send a request to Sql Server with the username and password.
a. If the user is present , Return the user details to the Asp.net page
b. In asp.net page check if the command succeeded Set a session variable.
  • 0

Also tagged with one or more of these keywords: asp.net

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download