I cannot delete the player. If you are outside of season then the player can be deleted it says. The recored is not deleted.

I changed my system date to 2/20/06 and 8/20/06 for testing and created me as a player to delete and my date is 2/17/2006.

Please review and let me know what is missing to delete.
NOTE: I use the WroxUnited and created me then deleted. It deleted all players. I used the dave login account.
My code and yours is:
--------------------------------------------------------------
 Protected Sub DetailsDataSource_Deleting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceCommandEven tArgs) Handles DetailsDataSource.Deleting
        Dim today As DateTime = DateTime.Now()
        Dim startYear As Integer
        Dim endYear As Integer
        Dim seasonStart As DateTime
        Dim seasonEnd As DateTime

        If today.Month > 5 Then
            startYear = today.Year
            endYear = today.Year + 1
        Else
            startYear = today.Year - 1
            endYear = today.Year
        End If

        seasonStart = New DateTime(startYear, 8, 20) '20th August 8 >> Feb 2
        seasonEnd = New DateTime(endYear, 5, 31) '31 May

        If today >= seasonStart And today <= seasonEnd Then
            e.Cancel = True
            Message.Text = "Cannot delete players during the season"
        Else
            'GridView1.DataBind()
            Message.Text = ""
        End If


    End Sub

I'm getting problems here as well. It appears that the user is being deleted but the gridview is not being updated. :(

You will find the same problem if you add a new user. To see if your add/delete has worked click on one of the paging numbers at the bottom of the gridview. This will refresh the gridview for you and you will see that the player has been added or deleted (depending on your opreation)

There are only 10 kinds of people.
Those who understand binary...and those who don't!

I've just worked out the problem here guys. Updating the datagrid within the DELETING event procedure is pointless. After all, the data has NOT YET BEEN DELETED.

To make this example work you need to add another event procedure to handle the DELETED event.


Protected Sub DetailsDataSource_Deleted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEvent Args) Handles DetailsDataSource.Deleted
        GridView1.DataBind()
    End Sub

This book must be teaching me something eh :)

There are only 10 kinds of people.
Those who understand binary...and those who don't!