Please illustrate how to omit null field from a DB using a datalist.

Discussion in 'ASP .Net' started by Troy, Aug 26, 2003.

  1. Troy

    Troy Guest

    I am at the end of my rope here. Would someone mind showing me some code
    that would leave out all of the fields that are not null. In my Container I
    have blank lines all over the place becuase it is returning the null fields
    from the db.

    I would like to then take it one step further and run some other conditions
    as well, but this container crap has me very confused.

    Any help is greatly appreciated.

    Thanks,

    Troy
     
    Troy, Aug 26, 2003
    #1
    1. Advertising

  2. Troy,

    In your SQL statement add WHERE [FieldName] Is Not Null

    Sincerely,

    --
    S. Justin Gengo, MCP
    Web Developer

    Free code library at:
    www.aboutfortunate.com

    "Out of chaos comes order."
    Nietzche


    "Troy" <devteam.at.cyberwarehouse.com> wrote in message
    news:ev%23aha$...
    > I am at the end of my rope here. Would someone mind showing me some code
    > that would leave out all of the fields that are not null. In my Container

    I
    > have blank lines all over the place becuase it is returning the null

    fields
    > from the db.
    >
    > I would like to then take it one step further and run some other

    conditions
    > as well, but this container crap has me very confused.
    >
    > Any help is greatly appreciated.
    >
    > Thanks,
    >
    > Troy
    >
    >
    >
     
    S. Justin Gengo, Aug 26, 2003
    #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. Nevyn Twyll
    Replies:
    8
    Views:
    1,882
  2. Replies:
    5
    Views:
    26,702
    Mike Schilling
    Mar 29, 2006
  3. Replies:
    4
    Views:
    419
  4. Laphan
    Replies:
    2
    Views:
    172
    Laphan
    Feb 12, 2008
  5. Walt
    Replies:
    18
    Views:
    161
    Dr.Ruud
    Apr 29, 2006
Loading...

Share This Page