Save and update Multiple records

  StringBuilder builder = new StringBuilder();
            builder.Append("<Root>");

            for (int i = 0; i < grdPermission.Rows.Count; i++)
            {
                string ActivityName = string.Empty;
                string ActivityID = string.Empty;
                string view = string.Empty;
                string edit = string.Empty;
                string delete = string.Empty;

                ActivityID = ((Label)grdPermission.Rows[i].Cells[1].FindControl("lblActivityID")).Text.Trim();
                ActivityName = ((Label)grdPermission.Rows[i].Cells[1].FindControl("lblActivityName")).Text.Trim();
                string rdBtnListAction = ((RadioButtonList)grdPermission.Rows[i].Cells[2].FindControl("rdBtnListAction")).SelectedValue.ToString();

                builder.Append("<Activities ActivityID='" + ActivityID + "' RoleID = '" + ddl_AllRoles.SelectedValue.ToString() + "' Permission ='" + rdBtnListAction + "'></Activities>");

            }
            builder.Append("</Root>");
            builder.ToString();
            objAdminSecurityBL = new AdminSecurityBL();           
            objAdminSecurityBL.PermissiontoActivities( builder.ToString());
            objAdminSecurityBL = null;



   

     
Alter Procedure [sp_insertUsersExcel]     
 (       
  @XmlString xml = null 

         
 )     
AS     
     
Begin     
   
     
  declare @VerseSize  nvarchar(100) 
  declare @CompanyCardID  nvarchar(100) 
  declare @PTextSize nvarchar(100)
  DECLARE @idoc int  
Declare @abcdas int=0
         declare @abc varchar(max) =''
         declare @abc1 varchar(max) =''
         
       
   exec sp_xml_preparedocument @idoc output, @xmlString     
   
   DECLARE pCursor CURSOR FOR     
   select xCompanyCardID,xVerseSize,xPTextSize from openxml(@idoc,'/root/XML_FIRM',1)     
   with(xCompanyCardID nvarchar(100),xVerseSize nvarchar(100),xPTextSize nvarchar(100))      
         
   OPEN pCursor     
   
   FETCH NEXT FROM pCursor into @CompanyCardID,@VerseSize,@PTextSize
    WHILE @@FETCH_STATUS = 0   
       
    BEGIN 
        
     
   if exists(select * from  tbl_Cards  where CompanyCardID=@CompanyCardID)
   begin
      update tbl_Cards set VerseSize=@VerseSize,PTextSize=@PTextSize where CompanyCardID=@CompanyCardID 
      --update tbl_Cards set VerseSize='',PTextSize='' where CompanyCardID=@CompanyCardID 
   end
   else
       begin
       if(LEN(@abc) < 7980)
       begin
      set  @abcdas=@abcdas+1
      
        set @abc= @abc + @CompanyCardID  +'<br/>'
        end
       
        else
        begin
        set @abcdas=@abcdas+1
        set @abc1= @abc1 + @CompanyCardID + '<br/>'
        end
   
       end
        
      FETCH NEXT FROM pCursor into @CompanyCardID,@VerseSize,@PTextSize 
    End      
     CLOSE pCursor     
     DEALLOCATE pCursor        
             
  EXEC sp_xml_removedocument @iDoc     
  
     print @abc
      print @abc1

   
  
End