-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Roopesh_finally_serious
Message 3 in Discussion
Hi Prasanth,
Modify the code like this
<%# GetBusinessDay(Container.DataItem("DateReceivedBOFA") &
"",Datetime.Now.ToString,5,0) %>
Best regards,
Roopesh Tayaloor
>From: "prasanth" <[EMAIL PROTECTED]>
>Reply-To: "BDOTNET" <[email protected]>
>To: "BDOTNET" <[email protected]>
>Subject: Please suggest me a solution
>Date: Wed, 18 Oct 2006 20:34:48 -0700
>
>
>
>
>
>
>
>
>
>
>
>
>
> New Message on BDOTNET
>
>
>
>
>
>
>
> Please suggest me a solution
>
>
>
>
> Reply
>
>
>
>
>
> Reply to Sender
> Recommend
>
> Message 1 in Discussion
>
>
>
>
>
>
>
> From:
> prasanth
>
>
>
>
>
> Hi, I am using this function below for finding the number of
>business days and am binding this data to Datalist control based on the id
>passed from other page ,Here is the sample code in aspx page
>
><tr>
> <td><b>Outstanding Days:</b></td>
> <td><font color="#0033ff">
> <%#
>GetBusinessDay(Container.DataItem("DateReceivedBOFA"),Datetime.Now.ToString,5,0)
>
>%>
> </font>
> </td>
></tr>
>
>Public Shared Function GetBusinessDay(ByVal startDate As DateTime, ByVal
>EndDate As DateTime, ByVal NoOfDayWeek As Integer, ByVal DayType As
>Integer) As Double
>Dim iWeek As Double
>Dim iDays As Double
>Dim isDays As Double
>Dim ieDays As Double
>Dim T As TimeSpan
>Dim strFDate, strEDate As SqlTypes.SqlDateTime
>If startDate.ToShortDateString = "" Then
>startDate = Convert.DBNull(SqlDateTime.Null)
>ElseIf EndDate.ToShortDateString = "" Then
>EndDate = Convert.DBNull(SqlDateTime.Null)
>End If
>iWeek = DateDiff("ww", startDate, EndDate) - 1
>iDays = iWeek * NoOfDayWeek
>If NoOfDayWeek = 5 Then
>If startDate.DayOfWeek = DayOfWeek.Saturday Then
>isDays = 7 - CType(startDate.DayOfWeek, Integer)
>Else
>isDays = 7 - CType(startDate.DayOfWeek, Integer) - 1
>End If
>Else
>isDays = 7 - CType(startDate.DayOfWeek, Integer)
>End If
>If NoOfDayWeek = 5 Then
>If EndDate.DayOfWeek = DayOfWeek.Saturday Then
>ieDays = CType(EndDate.DayOfWeek, Integer) - 2
>Else
>ieDays = CType(EndDate.DayOfWeek, Integer) - 1
>End If
>Else
>ieDays = CType(EndDate.DayOfWeek, Integer) - 1
>End If
>iDays = iDays + isDays + ieDays
>If DayType = 0 Then
>Return iDays
>Else
>Return T.Days - iDays
>End If
>End Function
>Now the problem is when i try to call the above function it works well,if
>the DateRecievedBOFA column is having some Date.Moreover this column is
>defined as Char(11) in SQLServer table.So when the column is empty or
>null,it displays the error message "Cast from Type DBNull to Type String is
>Not Valid " or "Cast from string "" to type 'Date' is not valid ".
>Please tell me how could i solve this issue.
>Thanks in advance,
>Vishnu
>
>
>
>
>
>
>
>
>
> View other groups in this category.
>
>
>
>
>
>
>
>
>
>
>
>
>
>Also on MSN:
>Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily
>Horoscopes
>
>
>
>
>
>
>
>
>
>
> To stop getting this e-mail, or change how often it
>arrives, go to your E-mail Settings.
>
>
> Need help? If you've forgotten your password,
> please go
>to Passport Member Services.
>
> For other questions or feedback, go to our
> Contact Us
>page.
>
>
> If you do not want to receive future e-mail
> from this
>MSN group, or if you received this message by mistake, please click the
>"Remove" link below. On the pre-addressed e-mail message that opens, simply
>click "Send". Your e-mail address will be deleted from this group's mailing
>list.
>
>
> Remove my e-mail address from BDOTNET.
>
>
>
>
>
>
>
_________________________________________________________________
The next best thing! Messenger Video Conversation. Click here!
http://join.msn.com/messenger/overview2000
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
