Server Error in '/' Application.

Input string was not in a correct format.

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.FormatException: Input string was not in a correct format.

Source Error:


Line 565:					cmd.Parameters.Add(new SqlParameter("@dir_id", SqlDbType.Int)).Value = 0;					 
Line 566:
Line 567:					resultDR = cmd.ExecuteReader();
Line 568:					if (resultDR.HasRows)
Line 569:					{

Source File: c:\inetpub\wwwroot\thailandbuilders\App_Code\dbHelper.cs    Line: 567

Stack Trace:


[FormatException: Input string was not in a correct format.]
   System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +14286670
   System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +174
   System.String.System.IConvertible.ToInt32(IFormatProvider provider) +58
   System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) +565
   System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) +1572

[FormatException: Failed to convert parameter value from a String to a Int32.]
   System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) +1676
   System.Data.SqlClient.SqlParameter.GetCoercedValue() +253
   System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc) +215
   System.Data.SqlClient.SqlCommand.SetUpRPCParameters(_SqlRPC rpc, Int32 startCount, Boolean inSchema, SqlParameterCollection parameters) +155
   System.Data.SqlClient.SqlCommand.BuildRPC(Boolean inSchema, SqlParameterCollection parameters, _SqlRPC& rpc) +128
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3392
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +725
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +84
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +207
   System.Data.SqlClient.SqlCommand.ExecuteReader() +142
   BizEnterpriseLib.dbHelper.GetValueAdHits(String outputfield, String table, String compinput, String compoutput) in c:\inetpub\wwwroot\thailandbuilders\App_Code\dbHelper.cs:567
   AdHits.GetValue(String outputfield, String table, String compinput, String compoutput) in c:\inetpub\wwwroot\thailandbuilders\AdHits.aspx.cs:111
   AdHits.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\thailandbuilders\AdHits.aspx.cs:41
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4494.0