CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

 CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:

  • BC30205: End of statement expected.

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    7292
  • Date Created
    Sunday, February 15, 2026
  • Last Updated
    Sunday, February 15, 2026
  • This Article Has been Viewed
    0 times
  • Short Desc

    ASP.NET BC30205: End of statement expected
  • Article Details

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

    On Line 940, there is an extra parenthesis at the end.
    This will cause the error to occur.


     

    Line: 937 strInsUp = "Update Albums set ReleaseDateID = @ReleaseDateID where AlbumID = @AlbumID"
    Line: 938 FullCMD = New SqlCommand(strInsUp, Artistcon)
    Line: 939 FullCMD.Parameters.Add(New SqlParameter("@ReleaseDateID", rsReleaseDate("ReleaseDateID")))
    Line: 940 FullCMD.Parameters.Add(New SqlParameter("@AlbumID", GlobalVariables.strSharedAblumID)))
    Line: 941 Try
    Line: 942 FullCMD.ExecuteNonQuery()
    Line: 943 Finally
    Line: 944 End Try

  • Resolve Issue

    On Line 940, there is an extra parenthesis at the end.
    Removing the extra parenthesis will allow the code to run.


     

    Line: 937 strInsUp = "Update Albums set ReleaseDateID = @ReleaseDateID where AlbumID = @AlbumID"
    Line: 938 FullCMD = New SqlCommand(strInsUp, Artistcon)
    Line: 939 FullCMD.Parameters.Add(New SqlParameter("@ReleaseDateID", rsReleaseDate("ReleaseDateID")))
    Line: 940 FullCMD.Parameters.Add(New SqlParameter("@AlbumID", GlobalVariables.strSharedAblumID))
    Line: 941 Try
    Line: 942 FullCMD.ExecuteNonQuery()
    Line: 943 Finally
    Line: 944 End Try

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles