Hi I am trying to get all rows from a datatable where the first column
F1 is a date, as this datatable is created of excel, i only want to
deal with rows where the first column is having a date in it.

For Each drow As DataRow In dt.Select("isdate(F1)")
.....code here stripped off , but was to loop through all columns
NEXT

but i get following error when i run the above code
"The expression contains undefined function call isdate()"

So the datatables select method cannot recognize isdate function, but
then what is the other way to do the same?

Any help greatly appreciated
Regards

DataSet .Select does not contain the full gammit of functions like in Sql
Server or even Access.


http://msdn2.microsoft.com/en-us/magazine/cc188790.aspx
might help a little with what is available.


You'll need to go to LINQ if you want more advanced control like that.





"nlulla" <nirav.lulla [at] gmail.com> wrote in message
news:2c976696-8799-4a97-a36e-83715a76d53c [at] x35g2000hsb.google groups.com...
> Hi I am trying to get all rows from a datatable where the first column
> F1 is a date, as this datatable is created of excel, i only want to
> deal with rows where the first column is having a date in it.
>
> For Each drow As DataRow In dt.Select("isdate(F1)")
> .....code here stripped off , but was to loop through all columns
> NEXT
>
> but i get following error when i run the above code
> "The expression contains undefined function call isdate()"
>
> So the datatables select method cannot recognize isdate function, but
> then what is the other way to do the same?
>
> Any help greatly appreciated
> Regards