GridView with merged Column Edit/Delete

[SK2010]

I have a gridview with merged columns. When I try to delete a row, my previous row is deleted. I have done this on my other webpages (with normal gridview) and its works fine there.

Can anyone please help me with this? I tried to debug and see which rowindex is it taking...and found that if I select rowindex =4 ...rowindex = 3 is selected and passed to delete query.

Please help.

Here is my code for delete:

protected void grdItems_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        //get the id of selected row
        GridViewRow row = grdItems.Rows[e.RowIndex];
        if (row != null)
        {
            grdItems.Rows[e.RowIndex].Cells[0].FindControl("lblRowID");
            Label lblRowID = (Label)grdItems.Rows[e.RowIndex].Cells[0].FindControl("lblRowID");
            string id = lblRowID.Text;
            DeleteRecord(id);
        }
        calculatetot();
        populateItems();
 
    }
    private void DeleteRecord(string ID)
    {
        SqlConnection myConnection = new SqlConnection(connectionString);
        string sqlstmt = "delete bod_items where rowid = @rowID";
 
        try
        {
            myConnection.Open();
            SqlCommand cmd = new SqlCommand(sqlstmt, myConnection);
            cmd.Parameters.AddWithValue("@rowid", ID);
            cmd.CommandType = CommandType.Text;
            cmd.ExecuteNonQuery();
        }
        catch (Exception err)
        {
            lblResult.Text = "Error deleting record. ";
            lblResult.Text += err.Message;
        }
        finally
        {
            myConnection.Close();
        }
 
    }