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

Joined
Aug 25, 2006
Messages
1
Reaction score
0
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!
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,768
Messages
2,569,575
Members
45,051
Latest member
CarleyMcCr

Latest Threads

Top