Since I use datareader and not dataset your solution won't work for me. But I will save it for the times when I use dataset.
Thank you so much for your help.
>I think this is cause the VFPOLEDB return a vaue of 0 rather then NULL to support empty dates in VFP.
>
>Returning 0 causes .Net to store the beginning of time or "12/31/1899 12:00 00000" where NET actually store System.DbNull.value as an empty date.
>
>In my OleDbDataAdapter i will use a string like this to fill NULL data values into my dataset.
>
>"IIF(EMPTY( dCreated ), null, dCreated ) as DateCreated"
>
>I have used it on VFP6,7,8 using the VFPOLEDB 8 driver.
>
>- jim
>
>
>>I retrieve a row from a VFP table, as datareader, where a date field has not entry (in VFP). But when I look at it in ASP.NET the date is there and it is 12/30/1899. I know I didn't enter any data in 1899 <g>. Who did?
>>
>>TIA.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham