Home » 2011 » November » 14

Archive for November 14, 2011

Arithmetic overflow error converting expression to data type datetime

November 14, 2011 - Posted in application error, Applications, Error - Permalink

Condition: <asp:SqlDataSource ID=”PolExpCurrentMo” runat=”server” ConnectionString=”< %$ ConnectionStrings:appConnectionString2 %>” SelectCommand=”SELECT * FROM [VendorList] WHERE _([EXPIRATION_DATE] >= @EXP_BEGIN) AND ([EXPIRATION_DATE] < @EXP_END) AND _([EXPIRATION_CONTACT] = @EXPIRATION_CONTACT) ORDER BY EXPIRATION_DATE "> <selectparameters> <asp:parameter DefaultValue=”YES” Name=”EXPIRATION_CONTACT” Type=”String” /> <asp:parameter Name=”EXP_BEGIN” Type=”String”/> <asp:parameter Name=”EXP_END” Type=”String” /> </selectparameters> Code behind default value ‘ *current months date parameter PolExpCurrentMo.SelectParameters(“EXP_BEGIN”).DefaultValue = _DateTime.Now.Month.ToString() + […]