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

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

Date: Sun, 27 Jun 2004 21:26:57 GMT

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

>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

Easier said than done (:

I looked at your example from above... but I dont' see how I can apply it :(

I've spent the last many hours searching the web on filtering... but they all
give great fitering information... except how to get Rid of Null values :(

One that looked promising was:

If you want to filter rows with null values, you must first convert the null
values to something such as a string:

dv.RowFilter = "Isnull(Col1,'Null') = 'Null'"

But that too didn't do too much... oh well.. might as well fall back and throw
the info into a Listbox, delete the blanks and then fire the info to my
Comboboxes... A crappy way to do it, but at least I know how to do that.

This just seems way over my head (which is hurting now) (:

Thanks anyways...

Bruce

Relevant Pages