Inserting a New Record.

    Right now the database uses a DetailView to show one record. The person then has the opportunity to select that one record as being "used". When this occurs the program needs to pull information from the one table (Games) and insert the information into a different table (LastPlayed). Here is my current code:
Dim key As DataKey = DetailsView1.DataKey
Dim varid As String
varid = key.Value.ToString()
Label1.Text = key.Value.ToString()
Dim sql As String
sql = "INSERT INTO [LastPlayed] (uID, gID, LastPlayedDate) VALUES (" & Profile.UserName & ", " & varid & ", " & DateTime.Now & ")"
SqlDataSource1.InsertCommand = sql
    Anyways, I'm just generally over my head in this area, any websites w/documentation on SQL in ASP.NET 2.0 would be appreciated as well as specific tips on how to handle this code.
David.

Just been messing about with the Data Access Model of .NET 2.0, this might help:

Create a new class with similar code (I'm gonna call my class TestClass):

Public Sub InsertData(string name)
Dim conn As New SqlConnection("...")
'Blah blah blah
'Execute the insert statement
End Sub

Then drop a ObjectDatasource into your page, change the TypeName property to TestClass, then change the InsertMethod to InsertData and click on the InsertParameters...

Add a new Profile parameter and set the property...

Then when your ready just go ObjectDatasource1.Insert();