|
Error Message: |
Failed to convert parameter value from a String to a Int32. |
|
|
|
Stack Trace: |
at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming)
at System.Data.SqlClient.SqlParameter.GetCoercedValue()
at System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc)
at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser, SqlParameterCollection parameters, Boolean includeReturnValue)
at System.Data.SqlClient.SqlCommand.BuildExecuteSql(CommandBehavior behavior, String commandText, SqlParameterCollection parameters, _SqlRPC& rpc)
at 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)
at 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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at BTS_Web2.Bill.bindData() in H:\CIS Programmers\Old Programs\Old Programs\Bill Tracking\Web Apps\BTS_Web2 - 2015\Bill.aspx.cs:line 193
at BTS_Web2.Bill.Page_Load(Object sender, EventArgs e) in H:\CIS Programmers\Old Programs\Old Programs\Bill Tracking\Web Apps\BTS_Web2 - 2015\Bill.aspx.cs:line 90 |
|
|
|
SQL: |
SELECT Bills.BillPrefix, Bills.BillSuffix, Bills.BriefDesc, LLS.District, LLS.LastName, Bills.LRNum, FNNum, Committee, Bills.BillTitle, Bills.EffectiveDate, Summary, B2.BillPrefix, B2.BillSuffix, Bills.BillCombined, Bills.SenateCommID, CommCode, Actions.SortOrder, Actions.ActionDate, Actions.BillAction, Actions.SenateJrnPage, Actions.HouseJrnPage, Calendars.SortOrder+1, Calendars.ActionCode, Bills.ApproBill, Bills.FiscalNoteFlag, Actions.ActionCode FROM Bills LEFT JOIN LegislatorList AS LLS ON Bills.SenateSponsorID = LLS.LegislatorID LEFT JOIN FiscalNotes ON Bills.FiscalNoteID = FiscalNotes.FiscalNoteID LEFT JOIN Committees ON Bills.SenateCommID = Committees.CommitteeID LEFT JOIN Summaries ON Bills.SummaryID = Summaries.SummaryID LEFT JOIN Bills AS B2 ON Bills.BillCombined = B2.BillID LEFT JOIN Actions ON Bills.BillID = Actions.BillID LEFT JOIN DayLookupShort ON Actions.ActionDate = DayLookupShort.DayDate LEFT JOIN Calendars ON Bills.BillID = Calendars.BillID WHERE Bills.BillID = @BillID AND Bills.SessionType = @SessionType AND Actions.SortOrder = (SELECT MAX(SortOrder) FROM Actions a WHERE a.BillID = Bills.BillID) |
|
|