Midterm help?

[ecameow]

Im working on a midterm for an asp.net/sql :

now i have

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Page Language="VB" Debug="true" %>
<Script Runat="Server">

Sub clickBtn(s As Object, e As EventArgs)
Dim hookup As SqlConnection
Dim strInsert As String
Dim cmdInsert As SqlCommand

hookup=New SqlConnection("Server=137.49.6.2;uid=backe;pwd=*******;database=*******")

strInsert = "Insert Designer (custAccount,cliID,serviceCharge,cliService,setUpCharge,totalCharge,USA) Values

(@custAccount,@cliID,@serviceCharge,@cliService,@setupCharge,@totalCharge.@USA)"
cmdInsert = New SqlCommand(strInsert, hookup)
cmdInsert.Parameters.Add("@custAccount",account.Text)
cmdInsert.Parameters.Add("@cliID",cName.Text)
cmdInsert.Parameters.Add("@serviceCharge",sCharge.Text)
cmdInsert.Parameters.Add("@cliService",cService.Text)
cmdInsert.Parameters.Add("@setupCharge",setup.Text)
cmdInsert.Parameters.Add("@totalCharge",tCharge.Text)
cmdInsert.Parameters.Add("@USA",abc.Text)

hookup.Open()
cmdInsert.ExecuteNonQuery()
hookup.Close()


If IsValid Then
verify.Text="Thank you"
End If
End Sub
</Script>


and for some reason when i go to submit the information i get this.

Line 22:
Line 23: hookup.Open()
Line 24: cmdInsert.ExecuteNonQuery()
Line 25: hookup.Close()
Line 26:



anyone have any ideas?

 

[SiDiuS]

*edit (im wrong) hehe

 

[Cardboard Hammer]

@totalCharge.@USA

Maybe it's just a typo if you retyped the code for your post, but that period should be a comma...