Select based on User Identity Name included in Insert into Second Table

Discussion in '.NET' started by dprichard, Aug 25, 2006.

  1. dprichard

    dprichard

    Joined:
    Aug 25, 2006
    Messages:
    1
    I am having issues getting this to work. I have the user login to a page to put in a request for vacation. When they login, I have a label that isn't visible that is equal to their User.Identity.Name.

    I select the user from the employee table where the username = the label (User.Identity.Name) and pull in the emp_id which is the primary key that identifies the user.

    I need to insert the request into the request table with the emp_id from the select statement, without showing the em_id on the screen. I tried using a hidden field and assigning the emp_id as the value, but it isn't working.

    Not sure if this is the best way to do this. Really new to ASP.NET 2.0 so I really appreciate any help.

    Thank you!
     
    dprichard, Aug 25, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Giovanni Bassi
    Replies:
    0
    Views:
    661
    Giovanni Bassi
    Oct 20, 2003
  2. nalbayo
    Replies:
    2
    Views:
    5,534
    Bruce Barker
    Nov 11, 2005
  3. Frederick D'hont
    Replies:
    0
    Views:
    323
    Frederick D'hont
    Jul 25, 2005
  4. andrew.sher@gmail.com
    Replies:
    6
    Views:
    465
    andrew.sher@gmail.com
    Apr 16, 2006
  5. Antonio O''Neal

    user.identity.name returns old AD user name

    Antonio O''Neal, Oct 31, 2008, in forum: ASP .Net Security
    Replies:
    5
    Views:
    2,155
    Antonio O''Neal
    Nov 3, 2008
Loading...

Share This Page