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

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

Date: Sat, 26 Jun 2004 20:45:00 -0500

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.

"Mr. B" <User@NoWhere.com> wrote in message
news:16vrd0ddliruqv2envnr4kmv9dqthp2pk8@4ax.com...
> With Deft Fingers, "Earl" <brikshoe@newsgroups.nospam> wrote:
>
> > IsDbNull and use a DataView for each combo
>
> Well... that solved all but Issue Two:
>
> > Issue Two:
> >
> > For the above, How can I get rid of any blank lines when I bind the
> >Datasource to a ComboBox pull down? Column 3 will have 50 lines of
blank. So if I
> >sort a ComboBox, the first 50 lines are blank! :(
>

Relevant Pages

  • Re: Global Delete - two questions
    ... I check the Analyses Toolpak and click OK ... Therefore I cannot attempt to execute the rest of your instructions. ... Would there be blanks in other cells as well as just entire rows? ... If a row has some blanks but not the entire row, you could use a macro to find ...
    (microsoft.public.excel.misc)
  • Re: Help combining multiple columns into one
    ... but doing that little bit extra allows me to select all blanks ... The source sheet (the one that contains all the data spread out over ... even though the cells LOOK blank... ... Vlookup returned a 'false'. ...
    (microsoft.public.excel.misc)
  • RE: Removing blank rows in a worksheet
    ... It won't work if the first & third DATA rows each have 5 contingous cells ... "Louise" wrote: ... > blanks in a data row'. ... >>> A colleague of mine has a report in Excel but somebody else has created it ...
    (microsoft.public.excel.worksheet.functions)
  • Re: ADO.net: 3 Data Set Questions (Issues)
    ... If you are binding to a datasource that has the blanks within, ... way is to prevent the blanks from populating when you initially pull the ... basically do not return the null cells. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.net: 3 Data Set Questions (Issues)
    ... If you are binding to a datasource that has the blanks within, ... way is to prevent the blanks from populating when you initially pull the ... basically do not return the null cells. ...
    (microsoft.public.dotnet.general)