Server Error in '/' Application.

Conversion failed when converting the varchar value '55.01' to data type int.

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: Conversion failed when converting the varchar value '55.01' to data type int.

Source Error:


Line 212:                objCMD = New SqlCommand(strSQL, objConn)
Line 213:                objRdr = objCMD.ExecuteReader
Line 214:                objRdr.Read()
Line 215:                lblAG2H.Text = objRdr.Item("Antal").ToString
Line 216:                lblG2.Text = lblG2.Text & " - " & objRdr.Item("Antal").ToString

Source File: C:\inetpub\wwwroot\hockeyligaen.dk\GameSheet_SA_Live.aspx.vb    Line: 214

Stack Trace:


[SqlException (0x80131904): Conversion failed when converting the varchar value '55.01' to data type int.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +212
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2843
   System.Data.SqlClient.SqlDataReader.HasMoreRows() +266
   System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +278
   GameSheet_SA_LIVE.page_load() in C:\inetpub\wwwroot\hockeyligaen.dk\GameSheet_SA_Live.aspx.vb:214
   System.Web.Util.CalliHelper.ArglessFunctionCaller(IntPtr fp, Object o) +12
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +11130222
   System.Web.UI.Control.OnLoad(EventArgs e) +132
   System.Web.UI.Control.LoadRecursive() +66
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428


Version Information: Microsoft .NET Framework Version:2.0.50727.8806; ASP.NET Version:2.0.50727.8762