Like keyword

Discussion in 'ASP .Net' started by Patrick, Jan 25, 2005.

  1. Patrick

    Patrick Guest

    Hi Group

    I have one column which can be either Null or with some value.

    I have one filter criteria in From End with
    "All", 'RTF Yes' and 'RTF No'.
    Depending on the filter selected by user i have to select the pertaining
    rows as below
    If Filter "All" select all rows from table
    if Filter = 'RTF yes' select only rows where 'RTF yes' in rows ( where
    columns in not null )
    if Filter = 'RTF No' select only rows where column is null

    how can i put this into where clause.
    Please advice.
    Thanks
    Pat....
     
    Patrick, Jan 25, 2005
    #1
    1. Advertising

  2. I guess you are talking about client side on the data table? You can use an
    Expression colum and the Like method
    http://msdn.microsoft.com/library/d.../html/frlrfsystemdatadatacolumnclasstopic.asp



    --
    W.G. Ryan MVP (Windows Embedded)

    TiBA Solutions
    www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
    "Patrick" <> wrote in message
    news:...
    > Hi Group
    >
    > I have one column which can be either Null or with some value.
    >
    > I have one filter criteria in From End with
    > "All", 'RTF Yes' and 'RTF No'.
    > Depending on the filter selected by user i have to select the pertaining
    > rows as below
    > If Filter "All" select all rows from table
    > if Filter = 'RTF yes' select only rows where 'RTF yes' in rows ( where
    > columns in not null )
    > if Filter = 'RTF No' select only rows where column is null
    >
    > how can i put this into where clause.
    > Please advice.
    > Thanks
    > Pat....
    >
    >
     
    W.G. Ryan eMVP, Jan 26, 2005
    #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. Patrick Kowalzick
    Replies:
    5
    Views:
    512
    Patrick Kowalzick
    Mar 14, 2006
  2. Replies:
    25
    Views:
    839
    Alex Martelli
    Apr 17, 2007
  3. Replies:
    6
    Views:
    491
    Peter Otten
    May 10, 2007
  4. Hamilton, William

    RE: keyword checker - keyword.kwlist

    Hamilton, William, May 10, 2007, in forum: Python
    Replies:
    4
    Views:
    379
  5. Trans
    Replies:
    12
    Views:
    232
    Trans
    Nov 18, 2005
Loading...

Share This Page