locked
inserting values into database dynamically in web page using c# .net RRS feed

  • Question

  • 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();

    Tuesday, July 9, 2013 1:41 AM

Answers

  • User-1716253493 posted

    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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, July 9, 2013 2:26 AM