Getting error "Input string was not in a correct format." in SelectParameters

Question

Query:

SELECT [VehicleId], [VehicleNumber], [VehicleBrand], [VehicleName], [ModelYear], [PurchasePrice]
FROM [VehicleMaster]
WHERE ([VehicleType]=@VehicleType or @VehicleType = '') and 
    ([VehicleNumber]=@VehicleNumber or @VehicleNumber is null) and 
    ([SaleStatus] = @SaleStatus or @SaleStatus = '-Select-') and 
    ([OwnershipStatus]=@OwnershipDetail or @OwnershipDetail = '-Select-')  and
    ([ModelYear] between @YearFrom and @YearTo or (@YearFrom = 'Year' and @YearTo = 'Year'))

Markup:

<SelectParameters>
    <asp:SessionParameter Name="VehicleType" SessionField="VehicleType" Type="String" />
    <asp:SessionParameter Name="VehicleNumber" SessionField="VehicleNumber" Type="String" />
    <asp:SessionParameter Name="SaleStatus" SessionField="SalesStatus" Type="String" />
    <asp:SessionParameter Name="OwnershipDetail" SessionField="OwnershipStatus" Type="String" />
    <asp:SessionParameter Name="YearFrom" SessionField="YearFrom" Type="Int32"  ConvertEmptyStringToNull="true" />
    <asp:SessionParameter Name="YearTo" SessionField="YearTo" Type="Int32" ConvertEmptyStringToNull="true" />
</SelectParameters>

Error:

Input string was not in a correct format.e....

Please show us your surrounding code.. this is a mess at the moment. — Simon Whitehead
– Simon Whitehead, Commented Mar 14, 2013 at 3:38
It looks like there are misplaced "blockquote" tags in your server side code... maybe hit the wrong button in the HTML-Format toolbar once? — Roman Gruber
– Roman Gruber, Commented Mar 14, 2013 at 3:41
You are declaring @YearFrom and @YearTo to be Int32's but compare them against 'Year' - which isn't a number. - at least I glanced at that in the posted Query that got edited away :) — Roman Gruber
– Roman Gruber, Commented Mar 14, 2013 at 3:44
wow.., what happend to the query in the question? Now its parameters?? — sa_ddam213
– sa_ddam213, Commented Mar 14, 2013 at 3:45

Roman Gruber · Accepted Answer · 2013-03-14 03:50:47Z

1

(@YearFrom = 'Year' and @YearTo = 'Year')

would imply that the varaibles @YearFrom and @YearTo are strings, but you declare them as Int32

<asp:SessionParameter Name="YearFrom" SessionField="YearFrom" Type="Int32"  ConvertEmptyStringToNull="true" />
<asp:SessionParameter Name="YearTo" SessionField="YearTo" Type="Int32" ConvertEmptyStringToNull="true" />

Which will fail during execution since the string 'Year' isn't an int type.

answered Mar 14, 2013 at 3:50

Roman Gruber

1,39111 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Roman Gruber Over a year ago

Did you change the 'Year' to something numeric or the Type of the parameter to "String"? It may also mean that the Session Field "Year From" has a non-integer. The Error message indicates that some string parsing went wrong. Hard to tell just about where without the complete stack trace...

Collectives™ on Stack Overflow

Getting error "Input string was not in a correct format." in SelectParameters

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related