DataGridViewButtonCellHey Linda,

I am working on a bound DGV, I want the user to choose a color for each row.
This will be helpful in reporting later.  To do this I have implemented the
DataGridViewButtonCell.  What I want to happen is when the user presses it a
color dialog opens up, when the user selects his color the integer is stored
in the record and the Color is displayed as the background of the button.  I
can get the integer displayed but I can't change the color.  

I have tried to change the cells backcolor with this line:

TblCompositionDataGridView.CurrentRow.Cells(e.ColumnIndex).Style.BackColor =
MyDialog.Color

When that didn't work I tried the approach below trying to create a style,
which didn't work either:

Private Sub TblCompositionDataGridView_CellContentClick(ByVal sender As
System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs)
Handles TblCompositionDataGridView.CellContentClick
       If e.ColumnIndex = 4 Then
           Dim MyDialog As New ColorDialog()
           ' Keeps the user from selecting a custom color.
           MyDialog.AllowFullOpen = True
           ' Allows the user to get help. (The default is false.)
           MyDialog.ShowHelp = True
           ' Sets the initial color select to the current text color,

           ' Update the text box color if the user clicks OK
           If (MyDialog.ShowDialog() = Windows.Forms.DialogResult.OK) Then
               Dim mystyle As New DataGridViewCellStyle
               mystyle.ApplyStyle(cmdColorColumn.CellTemplate.Style)
               mystyle.BackColor = (MyDialog.Color)
               
TblCompositionDataGridView.CurrentRow.Cells(e.ColumnIndex).Value =
MyDialog.Color.ToArgb()
               
TblCompositionDataGridView.CurrentRow.Cells(e.ColumnIndex).Style.ApplyStyle(mystyle)
           End If
       End If
   End Sub

What am I missing here?  I can change the color of a normal button with out
a problem.  

Thanks,