KB Issue

ASP.NET BC30205: End of statement expected

Issue Details

The "BC30205: End of statement expected." can sometimes happen when you have an extra character at the end of the string on which the error is presented.

Recreate IssueOn Line 940, there is an extra parenthesis at the end.
This will cause the error.

ASP.NET - Bad Character Placement
Line: 937 strInsUp = "Update TableOne set ColDateID = @ColDateID where ColID = @ColID"
Line: 938 FullCMD = New SqlCommand(strInsUp, Artistcon)
Line: 939 FullCMD.Parameters.Add(New SqlParameter("@ColDateID", rsReleaseDate("ColDateID")))
Line: 940 FullCMD.Parameters.Add(New SqlParameter("@ColID", GlobalVariables.strSharedID)))
Line: 941 Try
Line: 942 FullCMD.ExecuteNonQuery()
Line: 943 Finally
Line: 944 End Try

Resolve Issue

Removing the extra parenthesis will allow the code to run.
Line 3, below.

[ASP.NET - Character Placement Corrected]

CFFCS | CarrzSynEdit: | ASP.NET (VB/C#)

strInsUp = "Update TableOne set ColDateID = @ColDateID where ColID = @ColID"
FullCMD = New SqlCommand(strInsUp, Artistcon)
FullCMD.Parameters.Add(New SqlParameter("@ColID", GlobalVariables.strSharedID))
Try
   FullCMD.ExecuteNonQuery()
Finally
End Try