Server Error in '/' Application.

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

Source Error:


Line 27: 	   conn.Open()
Line 28: 	   reader_villa = cmd.ExecuteReader
Line 29: 	   If reader_villa.Read() Then
Line 30:    
Line 31: 	   If reader_villa("urlr_it") Is DBNull.Value Then 

Source File: \\WAGNER\wwwroot$\luxuryvillaitaly.com\2018villa_details.aspx.vb    Line: 29

Stack Trace:


[SqlException (0x80131904): Conversion failed when converting the varchar value '642,642' to data type int.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1968714
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4907387
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2412
   System.Data.SqlClient.SqlDataReader.HasMoreRows() +206
   System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +185
   System.Data.SqlClient.SqlDataReader.Read() +9
   _villaDetails.Page_Load(Object Src, EventArgs E) in \\WAGNER\wwwroot$\luxuryvillaitaly.com\2018villa_details.aspx.vb:29
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


Version Information: Microsoft .NET Framework Version:2.0.50727.9061; ASP.NET Version:2.0.50727.9062