Last post Jul 09, 2013 02:26 AM by oned_gk
Jul 09, 2013 01:41 AM|su88rao|LINK
I have got to insert employee details in EditProfile page of my project, it should be like the employee who logs in can edit his profile and insert the details and once he inserts, data will get stored in database and next time he/she logs in, their details
should get display in home page depending on their respective user id n passwrd..
i have done most of the things , but im not able to get the employee name while inserting d datas in edit profile... i mean to say that i one employee logs in n edits his/her profile data gets saved in database but not with the respective employee name...
i have tried stored procedure to insert the values to employee data but i dnt no wer to use emp name in tht.. plz help me... below is my stored procedure
ALTER PROCEDURE [dbo].[InsertProfile]
@EmpID bigint OUTPUT
Insert Into dbo.EmployeeData
Select @EmpID = SCOPE_IDENTITY();
Jul 09, 2013 02:26 AM|oned_gk|LINK
How to link userid and Employee data?
You should have UserID field in the employeedata?
If not exist, do insert. If exist do edit/update.
You can select the record based current loged userid