User1011613426 posted
Hello All,
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]
@Full_Name nvarchar(50),
@Add nvarchar(50),
@M_Num bigint,
@Mail_ID nvarchar(50),
@B_Group nvarchar(50),
@EmpID bigint OUTPUT
AS
Insert Into dbo.EmployeeData
(
FullName,
Address,
MobileNumber,
EmailID,
BloodGroup
)
Values
(@Full_Name,
@Add,
@M_Num,
@Mail_ID,
@B_Group
)
Select @EmpID = SCOPE_IDENTITY();