How to update GridView Record Based on Unique column value using ASP.Net

Hi fareed.fd7,

You can pass Branch code too and check it with where condition like below

CREATE PROCEDURE CheckUserNameAndPersonName
      @UserName VARCHAR(50)
     ,@PersonName VARCHAR(50)
     ,@BranchCode VARCHAR(50)
AS
BEGIN
      SET NOCOUNT ON;
 
      DECLARE @Exists VARCHAR(20)
 
      IF EXISTS(SELECT UserName,PersonName
                FROM YourTableName
                WHERE YourUserNameColumn = @UserName 
                AND YourPersonNameColumn = @PersonName
                AND YourBranchCodeColumn = @BranchCode)
      BEGIN
            SET @Exists = 'Exists'
      END
      ELSE
      BEGIN
            --Your Update Statement Comes Here
            SET @Exists = 'Not Exists'
      END
 
      RETURN @Exists
END

above will check the username and personName with the particular branchcode

i have used this condition already but if i want to update person name only then this conditon will fail sir

Hi fareed.fd7,

Are you using any identity column in a table that maintains the uniqueness of the users.

If Yes then you need to use that unique value condition whenever person are trying to update his/her records.so it will check if the belonging person is same as person who is trying to update the record.

If No then please share your table structure with data.

i'm using primary key, for keeping uniqueness

Hi fareed.fd7,

Which column is referring to the primary key in your table.

Please share the table structure with some records so that we can provide you a proper solution.