public int Update(int iEmpIndex, string strPassword, string strFirstName, string strLastName, int iDesigIndex, int iUsedAnnualLeaves, int iUsedSickLeaves, DateTime enteredate, DateTime updatedDate) { try { //updating the DB: VALUES PASSED CORRECTLY BUT DOESNT PERFORM THE TASK return empAdapter.Update(strPassword, strFirstName, strLastName, iDesigIndex, iUsedAnnualLeaves, iUsedSickLeaves, enteredate, updatedDate, this.OldEmpIndex, this.OldPassword, this.OldFirstName, this.OldLastName, this.OldDesigIndex, this.OldUsedAnnualLeaves, this.OldUsedSickLeaves, this.OldEnteredDate, this.OldUpdatedDate); } catch { throw; } } thsi update satement maps to the stored procedure that has the followin SQL query: set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[ProcUpdateEmployee]( @Password nvarchar(50), @FirstName nvarchar(50), @LastName nvarchar(50), @DesigIndex int, @UsedAnnualLeaves int, @UsedSickLeaves int, @EntryDate datetime, @UpdatedDate datetime, @Original_EmpIndex int, @Original_Password nvarchar(50), @Original_FirstName nvarchar(50), @Original_LastName nvarchar(50), @Original_DesigIndex int, @Original_UsedAnnualLeaves int, @Original_UsedSickLeaves int, @Original_EntryDate datetime, @Original_UpdatedDate datetime, @EmpIndex int)AS SET NOCOUNT OFF;UPDATE [tblEmployees] SET [Password] = @Password, [FirstName] = @FirstName, [LastName] = @LastName, [DesigIndex] = @DesigIndex, [UsedAnnualLeaves] = @UsedAnnualLeaves, [UsedSickLeaves] = @UsedSickLeaves, [EntryDate] = @EntryDate, [UpdatedDate] = @UpdatedDate WHERE (([EmpIndex] = @Original_EmpIndex) AND ([Password] = @Original_Password) AND ([FirstName] = @Original_FirstName) AND ([LastName] = @Original_LastName) AND ([DesigIndex] = @Original_DesigIndex) AND([UsedAnnualLeaves] = @Original_UsedAnnualLeaves) AND ([UsedSickLeaves] = @Original_UsedSickLeaves) AND ([EntryDate] = @Original_EntryDate) AND ([UpdatedDate] = @Original_UpdatedDate)); SELECT EmpIndex, Password, FirstName, LastName, DesigIndex, UsedAnnualLeaves, UsedSickLeaves, EntryDate, UpdatedDate FROM tblEmployees WHERE (EmpIndex = @EmpIndex)