Re: ADO.net: 3 Data Set Questions (Issues)

From: Mr. B (User_at_NoWhere.com)
Date: 06/27/04 

Date: Sun, 27 Jun 2004 03:34:31 GMT

With Deft Fingers, "Earl" <brikshoe@newsgroups.nospam> wrote:

>If you are binding to a datasource that has the blanks within, the easiest
>way is to prevent the blanks from populating when you initially pull the
>data. A lot of different ways of writing your query to do that, but
>basically do not return the null cells. If you are using a stored procedure,
>one way is to write subqueries for each field to filter out the nulls/empty
>cells.

hmm... not 100% I'm sure what you mean... but I'll try playing with Filters
and see where I go/get. I don't recall seeing anything on this in my books...
but I'll look.

Thanks (again)!

Bruce

Relevant Pages

  • Re: ADO.net: 3 Data Set Questions (Issues)
    ... >way is to prevent the blanks from populating when you initially pull the ... A lot of different ways of writing your query to do that, ... >one way is to write subqueries for each field to filter out the nulls/empty ...
    (microsoft.public.dotnet.general)
  • Re: ADO.net: 3 Data Set Questions (Issues)
    ... >way is to prevent the blanks from populating when you initially pull the ... A lot of different ways of writing your query to do that, ... >one way is to write subqueries for each field to filter out the nulls/empty ...
    (microsoft.public.data.ado)
  • Re: Need transport stream sample code
    ... Your suggestion of pull ... There are a couple of sample parsers (aka splitters, ... source+parser filter, but writing a parser-only filter has ... // a dot angeli at psynet dot net ...
    (microsoft.public.win32.programmer.directx.video)
  • Re: Allowing access to social networking... securely?
    ... I'm not trying to jump down your throat, but I do have to pull out some points. ... I'll fess up to playing Devil's Advocate in my spare time. ... Security as an excuse to filter. ...
    (Security-Basics)
  • ASF File duration
    ... I have created a Filter that acts like asf writer but the difference is it ... The filter uses Windows Media Format for writing the ASF file. ... class and previous one I close previous sink and reopen a new sink. ...
    (microsoft.public.windowsmedia.sdk)