Chris;
Yes, that was one of the first things I "discovered". Just think of all the discoveries we have yet to master! :)
Tom
>I had a problem a couple weeks ago concerning DataViews that I meant to post, but forgot. I created a DataView from a DataTable in a DataSet and kept thinking that the DataView wasn't actually filtering the data. It was filtering the data, but I was using:
>
>myDataView.Table.Rows.Count
>
>to see how many records were in the DataView. It turns out this doesn't work. That property holds the count of the records as if a filter hadn't been applied. I had to use:
>
>myDataView.Count
>
>Has anyone else run into this?
>
>>I am trying to set a filter on a dataview to show all animals over 18 months. Here is the code I have tried.
>>
>>
>>this.AnimalsVw.RowFilter = "Dob < #" + DateTime.Today.AddMonths(-18) + "#" ;
>>
>>
>>and I have also tried
>>
>>
>>this.AnimalsVw.RowFilter = "Dob < '" + DateTime.Today.AddMonths(-18) + "'" ;
>>
>>
>>Neither on the filters works either causing an error or just not filtering any animals.
>>
>>I am using C# and the compact framework.
>>
>>Thanks for any pointers.
>>
>>John