Server Error in '/' Application.

Error converting data type nvarchar to bigint.

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: Error converting data type nvarchar to bigint.

Source Error:


Line 40:                                         };
Line 41:         SqlDataReader dr = _sqlDataAccessLayer.ExecuteReader(CommandType.Text, query, sqlParameters);
Line 42:         if (dr.Read())
Line 43:         {
Line 44:             ltrCompanyName.Text = Convert.ToString(dr["companyname"]);

Source File: d:\Rx\eShop\IWLS22\ExhibitorListDetail.aspx.cs    Line: 42

Stack Trace:


[SqlException (0x80131904): Error converting data type nvarchar to bigint.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3335264
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +334
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4679
   System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) +255
   System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) +298
   System.Data.SqlClient.SqlDataReader.Read() +43
   ExhibitorListDetail.BindExhibitor(String ExhiId) in d:\Rx\eShop\IWLS22\ExhibitorListDetail.aspx.cs:42
   ExhibitorListDetail.Page_Load(Object sender, EventArgs e) in d:\Rx\eShop\IWLS22\ExhibitorListDetail.aspx.cs:21
   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.4700.0