gridview row is deleted but it show again when we delete the

Question

if i delete the  1st row in  a gridview then am going to delete  the 2nd row. if i delete the 2nd row the first row again show.but i need to delete it without affect the database.


my code is

private void BindData()

    {

        string constr = ConfigurationManager.AppSettings["s"].ToString();

        string query = "select Id, Name, Status FROM aten";

        SqlDataAdapter da = new SqlDataAdapter(query, constr);

        DataSet ds = new DataSet();

        DataTable DataTable1 = new DataTable();

        da.Fill(DataTable1);

        GridView1.DataSource = DataTable1;

        GridView1.DataBind();

        ViewState["UsingSelectedRow"] = DataTable1;

        ViewState["UsingRowDeleting"] = DataTable1;

        ViewState["UsingLinkButtonOnClick"] = DataTable1;

        

    }

    

 protected void Delete(object sender, EventArgs e)

    {

 int index = Convert.ToInt32(((sender as LinkButton).NamingContainer as GridViewRow).RowIndex);

        DataTable dt = (DataTable)ViewState["UsingLinkButtonOnClick"];

        dt.Rows.RemoveAt(index);

        this.GridView1.DataSource = dt;

        this.GridView1.DataBind();

    }