Jump to content

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

randolphb1388

    Newbie

  • Members
  • Pip
  • 2 posts
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,
Bart

#2
gokuajmes

gokuajmes

    Programming God

  • Members
  • PipPipPipPipPipPipPip
  • 518 posts
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.




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users