Problems Inserting Into Database :(

Hello everyone,

 I am having some problems inserting some data into a database - I have been stuck on this almost all day now and I'm almost pulling my hair out! I'm quite new to ASP.net and have been thrown in the deep end with this assignment... And advice or help would be greatly appreciated. Thanks.

  Protected Sub CreateUserWizard1_CreatedUser1(ByVal sender As Object, ByVal e As System.EventArgs) Handles CreateUserWizard1.CreatedUser

'Assign new user to role of Applicant
Roles.AddUserToRole(CreateUserWizard1.UserName, "Applicant")

'Create Connection String

UserName = CreateUserWizard1.UserName


Dim DBConn As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True")

Dim DBCmd As New SqlCommand


DBConn.Open()


'Add Insert Statement

DBCmd = New SqlCommand("INSERT INTO aspnet_Users(MobileAlias) VALUES (@Applicant) WHERE UserName=@UserName", DBConn)


'Add Database Parameters

DBCmd.Parameters.Add("@Applicant", SqlDbType.NVarChar).Value = "Applicant"

DBCmd.ExecuteNonQuery()

'Close Database connection

'and Dispose Database objects

DBCmd.Dispose()

DBConn.Close()

DBConn = Nothing


End Sub

 

---------------------------------------------------------------------------------

error generated:

 

 Incorrect syntax near the keyword 'WHERE'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'WHERE'.