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

From: Earl (brikshoe_at_newsgroups.nospam)
Date: 06/27/04 

Date: Sun, 27 Jun 2004 00:45:27 -0500

The datasource contains the "blanks" (empty string). The easiest way to deal
with that is to prevent it at the time you read in the data from the
database. Alternatively, you have to filter that out of your dataview. Take
a look at this post:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=udVnkBvTEHA.504%40TK2MSFTNGP11.phx.gbl&rnum=2&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26scoring%3Dd%26q%3Ddataview%252Bfilter%252Bempty%26meta%3Dgroup%253Dmicrosoft.public.dotnet.framework.adonet

"Mr. B" <User@NoWhere.com> wrote in message
news:kvfsd0lainkaeilrm5ku5krjs1vg566r3b@4ax.com...
> 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)
    ... The datasource contains the "blanks" (empty string). ... you have to filter that out of your dataview. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.net: 3 Data Set Questions (Issues)
    ... The datasource contains the "blanks" (empty string). ... you have to filter that out of your dataview. ...
    (microsoft.public.dotnet.general)
  • Re: Filtered cells return after saving
    ... and select Blanks from the bottom of the filter pull-down. ... post that you have started with a .csv file, ...
    (microsoft.public.excel.misc)
  • Re: Filtered cells return after saving
    ... I was unchecking just the blanks on the pull down. ... and delete rows (takes a long time waiting on Vista or Excel to process that) ... and then go back to the filter and select all...... ... for the advice on how to save the csv file. ...
    (microsoft.public.excel.misc)
  • Re: copy / paste without skipping blanks
    ... Todd, a filter won't filter numbers or characters and keep the blanks ... Then in cell C1 put the formula =IF,A1,"") and fill-down. ...
    (microsoft.public.excel.programming)