The expression contains undefined function call isdate()

Discussion in 'ASP .Net' started by nlulla, Apr 23, 2008.

  1. nlulla

    nlulla Guest

    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
     
    nlulla, Apr 23, 2008
    #1
    1. Advertising

  2. nlulla

    sloan Guest

    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" <> wrote in message
    news:...
    > 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
     
    sloan, Apr 23, 2008
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. James Dyer
    Replies:
    5
    Views:
    651
  2. Veeresh

    ISDate function.....

    Veeresh, Jul 2, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    485
    Veeresh
    Jul 2, 2004
  3. John

    Using the isDate function

    John, Sep 13, 2004, in forum: ASP .Net
    Replies:
    2
    Views:
    2,793
    Cor Ligthert
    Sep 13, 2004
  4. Nita Raju

    Isdate() not working properly

    Nita Raju, Nov 30, 2004, in forum: ASP .Net
    Replies:
    5
    Views:
    4,326
    Peter Blum
    Dec 1, 2004
  5. Mantorok Redgormor
    Replies:
    70
    Views:
    1,776
    Dan Pop
    Feb 17, 2004
Loading...

Share This Page