How to delete a row from GridView without affecting the Data

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="AbsenceRequestMonitor.aspx.cs" Inherits="Year4Absence.AbsenceRequestMonitor" %> 







    









    


    
    


    
    
    













            
         












    


       OnRowCommand="GridViewViewAllRequests_RowCommand">
        
            
             
            
            
            
            
            
            
            
                
                    
                
            
            
                
                    
                    
                
            
        
    
            
        
    
    





Here is my .cs code:
 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Year4Absence
{
    public partial class AbsenceRequestMonitor : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
        }
        protected void ButtonSearch_Click(object sender, EventArgs e)
        {
            DoAction();
        }
        public Boolean ScraptheRequest(int id, bool action)
        {
            bool success = false;
            success = DBOperation.ScrapAbsencedate(id, action);
            return success;
        }
        protected void GridViewViewAllRequests_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            //Determine the RowIndex of the Row whose Button was clicked.
            int id = Convert.ToInt32(e.CommandArgument);
            //Get the value of column from the DataKeys using the RowIndex.
           // int id = Convert.ToInt32(GridViewViewAllRequests.DataKeys[rowIndex].Values[0]);
           if(e.CommandName == "Scrap")
            {
                ScraptheRequest(id, true);
            }
           else if(e.CommandName == "Undo")
            {
                ScraptheRequest(id, false);
            }
            DoAction();
            UpdatePanelInfo.Update();
        }
        public void DoAction()
        {
            string firstName = null;
            string lastName = null;
            firstName = TextBoxFirstName.Text.ToString();
            lastName = TextBoxLastName.Text.ToString();
            double PdCount = 0;
            double OtherCount = 0;
            if (firstName != null && lastName != null)
            {
                //gets student data from the Student Form
                List l_studentAbsenceInfo = DBOperation.getStudentAbsenceInfo(firstName, lastName);
                AbsenceMonitorData studentAbsenceInfo = l_studentAbsenceInfo.FirstOrDefault();
                PdCount += l_studentAbsenceInfo.Where(x => x.reason == "Personal Day").Where(y => y.isApproved == true).Where(z => z.scrap == false).Select(a => a.daysMissed).Sum();
                OtherCount += l_studentAbsenceInfo.Where(x => x.reason != "Personal Day").Where(y => y.isApproved == true).Where(z => z.scrap == false).Select(a => a.daysMissed).Sum();
                GridViewViewAllRequests.DataSource = l_studentAbsenceInfo;
                GridViewViewAllRequests.DataBind();
                
                 
         if (l_studentAbsenceInfo.Count > 0)
               {
                    LabelGetPersonal.Text = PdCount.ToString();
                    LabelGetOther.Text = OtherCount.ToString();
                    LabelgetTotaldays.Text = (PdCount + OtherCount).ToString();
                    LabelGetFirstName.Text = studentAbsenceInfo.firstName.ToString();
                    LabelGetLname.Text = studentAbsenceInfo.lastname.ToString();
                    LabelGetEmail.Text = studentAbsenceInfo.studentEmail.ToString();
                    PanelAbsenceInfo.Visible = true;
                    LabelNoRows.Visible = false;
                }
                else
                {
                    LabelNoRows.Visible = true;
                }
            }
        }
    }
}