Inserting Data Into A Row With An Identity Specification

I am trying to build a Windows application using: Windows XP Pro ; VS Pro 2005, C# and SQL2005.

I have a database table as follows:
eg
1) myGameRecency which contains columns : GameId (identity specification column/primary key/not null), Date (not null), [1], [2], [3], [4]

Using the myGameRecencyAllBalls table ---

I wish to insert a date into a new row but have not been able to determine how to with the identity specification on the GameId column.

Can anyone please assist?
Thank you.
lpbcorp



sqlCmd.CommandText = "DECLARE @date datetime SET @date = '" + Date +

"DECLARE @lastRowGameId int " +

"DECLARE lastrow_gameidcursor CURSOR SCROLL FOR " +

"(SELECT GameId FROM " + DBGameName.ToString() + "RecencyAllBalls) " +

"OPEN lastrow_cursor " +

"FETCH LAST FROM lastrow_gameidcursor INTO @lastRowGameId " +

"' INSERT INTO " + DBGameName.ToString() + "RecencyAllBalls.Date VALUES (@date) WHERE GameId = @lastrow_gameidcursor + 1";

sqlCmd.ExecuteScalar();