Adding next max row value to newly added row

I've added a button to a Windows form that allows a user to move a selected row from datagrid 1 to datagrid 2.

Datagrid 2 has a column that holds sequential numbers 1, 2, 3, 4..named "priority order" but that does not exist on datagrid 1.

How can the next number be assigned to the newly added row after the user decides to move it from dg1 to dg2?

Here is the code that places the row from datagrid 1 to datagrid 2:

Private Sub btnMoveDown_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnMoveDown.Click
        If grdAvailableDistributors.Enabled Then
            'Make sure a row is selected first
            If (grdAvailableDistributors.RowSel > 0) Then
                grdAvailableDistributors.AllowDelete = True

                'Add the selected category to the assigned grid
                grdCurrentDistAssignment.Rows.Add()
                grdCurrentDistAssignment.SetData(grdCurrentDistAssignment.Rows.Count - 1, "Distributor #", _
                    grdAvailableDistributors.GetData(grdAvailableDistributors.RowSel, "Distributor #"))
                grdCurrentDistAssignment.SetData(grdCurrentDistAssignment.Rows.Count - 1, "Type", _
                    grdAvailableDistributors.GetData(grdAvailableDistributors.RowSel, "Type"))
                grdCurrentDistAssignment.SetData(grdCurrentDistAssignment.Rows.Count - 1, "Name", _
                    grdAvailableDistributors.GetData(grdAvailableDistributors.RowSel, "Name"))

                'Remove the selected category in the available grid
                grdAvailableDistributors.Remove(grdAvailableDistributors.RowSel)

                'Don't select anything in the source grid
                grdAvailableDistributors.Select(-1, -1, -1, -1)

                'Sort the grids
                grdAvailableDistributors.Sort(C1.Win.C1FlexGrid.SortFlags.Ascending, 0)
                grdCurrentDistAssignment.Sort(C1.Win.C1FlexGrid.SortFlags.Ascending, 0)

                Me.grdCurrentDistAssignment.Select(Me.grdCurrentDistAssignment.Count - 1, 0)
            End If
        End If
    End Sub


any help on this is very much appreciated.

Thank you. Start Free Trial