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
Allowing somebody to sign a document if they are in a SQL table?
Started by randolphb1388, Nov 22 2010 12:34 AM
1 reply to this topic
#1
Posted 22 November 2010 - 12:34 AM
|
|
|
#2
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.
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


Sign In
Create Account

Back to top









