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() + "/1/" + DateTime.Now.Year.ToString() 'month begins

PolExpCurrentMo.SelectParameters("EXP_END").DefaultValue = 
_NxMonthValue + "/1/" + DateTime.Now.Year.ToString() 'month ends



Resolution

<asp:SqlDataSource ID="PolExpCurrentMo" runat="server" 
  ConnectionString="< %$ ConnectionStrings:appConnectionString2 %>" 
  SelectCommand="SELECT * FROM [VendorList] WHERE 
              _([EXPIRATION_DATE] >= @EXP_BEGIN) AND 
              _((convert(varchar,[EXPIRATION_DATE],111)) < @EXP_END) AND 
              _((convert,[EXPIRATION_CONTACT],111)) = @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>

Month, day and year code behind format

November 11, 2011 - Posted in Applications, ASP.NET, Date and Time Format - Permalink
Day name and date format of Friday, 11/11/2011

Dim strDayName As String
Dim curTime As New DateTime
                        
curTime = DateTime.Now.ToShortDateString()
strDayName = curTime.DayOfWeek.ToString

Response.Write(strDayName & ", " & DateTime.Today)

Result: Friday, 11/11/2011

Day name and date format of Friday, 11/11/2011 using case funtion

Dim iDay As String
Dim strDayName As String
iDay = DatePart("w", DateTime.Now)

   Select Case iDay
          Case "1"
              strDayName = "Sunday"
          Case "2"
              strDayName = "Monday"
          Case "3"
              strDayName = "Tuesday"
          Case "4"
              strDayName = "Wednesday"
          Case "5"
              strDayName = "Thursday"
          Case "6"
              strDayName = "Friday"
          Case "7"
              strDayName = "Saturday"
   End Select

Response.Write(strDayName & ", " & DateTime.Today)


Month name, day and year format of November 11, 2011

Response.Write(MonthName(DateTime.Now.Month) & " " & DateTime.Now.Day & ", 
                                                _" & DateTime.Now.Year)

Result: November 11, 2011

View related posts:
– VB.NET – Date in code behind
– VB.NET date and time format

Flag image

November 2, 2011 - Posted in Images - Permalink

Very often I find reason for using flag in gridview to visually present different options to a user. So, to keep them handy and retrievable whenever I need flags, I decided to upload them on the website for personal and public use. Use them free as you need them and save the time to yourself from creating one.

« Older Entries
Newer Entries »