wrote in message news:unMqFV$$FHA.3372@TK2MSFTNGP12.phx.gbl...
> Hello there,
> I am stuck with somenthing that I can't get to work.  I am trying to color
> (again) the cell of myCalendar in yellow if those dates match what I ahve
> in my DB.
> This is what I have so far:
>
> Sub Calendar1_DayRender(sender As Object, e As DayRenderEventArgs)
>
>  ' Here I define my command
>    Dim strSQL as String = "SELECT dteDataArrivo, dteDataPartenza FROM
> tblPrenotazioni"
>
>  ' Creation of DataAdapter passing in the command and the objConnection
>    Dim objDA as New OleDbdataAdapter(strSQL, objConnessione)
>
> ' Creating the DS and filling it
>    Dim objDS as New DataSet()
>    objDA.Fill(objDS)
>
>
>    ' Now here I try to iterate through all the rows returning dates fields
> but ....it deosn't work
>    Dim row as DataRow
>    For each row in objDs.Tables(0).Rows
>    If row(0) = e.Day.Date Then
>    e.cell.BackColor = System.Drawing.Color.Yellow
>    End If
>    Next
> End Sub
>
> Thanks for any help you might provide me with...(VB possibly :))
> Lorenzo
>

"Christopher Reed" <carttu@nospam.nospam> ha scritto nel messaggio
news:%23ZV%23Uy$$FHA.2736@TK2MSFTNGP11.phx.gbl...
> Do you have an OnDayRender attribute within the Calendar element on the
> ASPX or an AddHandler statement in your code-behind?  Without the event
> handler, your method won't be called.
>
> --
> Christopher A. Reed
> "The oxen are slow, but the earth is patient."
>
> "Lorenzo"
> <CuTT-!thISoFfonlyLeAveMyNamelorenzoWithNoNuMBErS98776@LeaveMyCountry!!!ITALIANlodging.it.NOSPAM>
> wrote in message news:unMqFV$$FHA.3372@TK2MSFTNGP12.phx.gbl...
>> Hello there,
>> I am stuck with somenthing that I can't get to work.  I am trying to
>> color (again) the cell of myCalendar in yellow if those dates match what
>> I ahve in my DB.
>> This is what I have so far:
>>
>> Sub Calendar1_DayRender(sender As Object, e As DayRenderEventArgs)
>>
>>  ' Here I define my command
>>    Dim strSQL as String = "SELECT dteDataArrivo, dteDataPartenza FROM
>> tblPrenotazioni"
>>
>>  ' Creation of DataAdapter passing in the command and the objConnection
>>    Dim objDA as New OleDbdataAdapter(strSQL, objConnessione)
>>
>> ' Creating the DS and filling it
>>    Dim objDS as New DataSet()
>>    objDA.Fill(objDS)
>>
>>
>>    ' Now here I try to iterate through all the rows returning dates
>> fields but ....it deosn't work
>>    Dim row as DataRow
>>    For each row in objDs.Tables(0).Rows
>>    If row(0) = e.Day.Date Then
>>    e.cell.BackColor = System.Drawing.Color.Yellow
>>    End If
>>    Next
>> End Sub
>>
>> Thanks for any help you might provide me with...(VB possibly :))
>> Lorenzo
>>
>
>

wrote in message news:e9rHUAAAGHA.3140@TK2MSFTNGP14.phx.gbl...
> Hello Chris thanks for your reply.  It seems all fine I have the
> OnDayRender set on the control in the aspx page.
> I am doing all this with 'old & cute webMatrix so I don't have
> codebehind...
>
> The error thrown is the following:
> System.InvalidCastException: Operator is not valid for type 'DBNull' and
> type 'Date'.
>
> It seems that the row(0) I am walking through returns an Integer (even if
> in this case maybe has found a NULL value) and not a date so then when I
> compare it to the E.Day.Date throws the error...I tried converting the
> Integer to a Date but it gets awfully mad at me...:)
> If the problem is because I have one or more NULL values in my table how
> do I work around it?
>
> Also what If I want to show only the first record retrieved from the
> DataSet? I mean what if I don't want walking through all the rows but only
> display the 1st record of a particular column.  So far I am successfull
> counting the rows, finding the columns, but not yet retrieving the first
> record...
>
> Lorenzo
>
>
> "Christopher Reed" <carttu@nospam.nospam> ha scritto nel messaggio
> news:%23ZV%23Uy$$FHA.2736@TK2MSFTNGP11.phx.gbl...
>> Do you have an OnDayRender attribute within the Calendar element on the
>> ASPX or an AddHandler statement in your code-behind?  Without the event
>> handler, your method won't be called.
>>
>> --
>> Christopher A. Reed
>> "The oxen are slow, but the earth is patient."
>>
>> "Lorenzo"
>> <CuTT-!thISoFfonlyLeAveMyNamelorenzoWithNoNuMBErS98776@LeaveMyCountry!!!ITALIANlodging.it.NOSPAM>
>> wrote in message news:unMqFV$$FHA.3372@TK2MSFTNGP12.phx.gbl...
>>> Hello there,
>>> I am stuck with somenthing that I can't get to work.  I am trying to
>>> color (again) the cell of myCalendar in yellow if those dates match what
>>> I ahve in my DB.
>>> This is what I have so far:
>>>
>>> Sub Calendar1_DayRender(sender As Object, e As DayRenderEventArgs)
>>>
>>>  ' Here I define my command
>>>    Dim strSQL as String = "SELECT dteDataArrivo, dteDataPartenza FROM
>>> tblPrenotazioni"
>>>
>>>  ' Creation of DataAdapter passing in the command and the objConnection
>>>    Dim objDA as New OleDbdataAdapter(strSQL, objConnessione)
>>>
>>> ' Creating the DS and filling it
>>>    Dim objDS as New DataSet()
>>>    objDA.Fill(objDS)
>>>
>>>
>>>    ' Now here I try to iterate through all the rows returning dates
>>> fields but ....it deosn't work
>>>    Dim row as DataRow
>>>    For each row in objDs.Tables(0).Rows
>>>    If row(0) = e.Day.Date Then
>>>    e.cell.BackColor = System.Drawing.Color.Yellow
>>>    End If
>>>    Next
>>> End Sub
>>>
>>> Thanks for any help you might provide me with...(VB possibly :))
>>> Lorenzo
>>>
>>
>>
>
>