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

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

Date: Mon, 28 Jun 2004 20:33:23 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:

Well... I think I got it...

I found this posting:

http://www.akadia.com/services/dotnet_filter_sort.html

It said: To return only those columns with null values, use the following
expression:

"Isnull(Col1,'Null Column') = 'Null Column'"

... So I just turned the Equal sign to Inequal (<>)... and it looks like it
solved my problem!

All the references to NULL's are no longer there in my pulldows! Just the
hard data!!!

My full code for one combo (cmbUserID) is as follows (where 'Employee' is the
column in the Table TSUpdate):

    Dim usr1 As DataView = New DataView(DsTSUpdate.Tables("TSUpdate"))
    usr1.RowFilter = "Isnull(Employee,'Null Column') <> 'Null Column'"
    cmbUserID.DataSource = usr1
    cmbUserID.DisplayMember = "Employee"

Regards,

Bruce

Relevant Pages