DataView.RowFil ter IsNull: DBNull in column of boolean datatype

[=?iso-8859-2?Q?Marcin_Dzi=F3bek?=]

Hi All:

I need to get (filter in) some dataview's rows with DBNULLs in column of boolean type:
Actually to get the only rows with DBNULL, I use code like this:

DV.RowFilter = "(IsNull(MyBool eanColumnName, True) = True) AND (IsNull(MyBoole anColumnName, False) = False)"

or ex.
DV.RowFilter = "(IsNull(MyInte gerColumnName, 1) = 1) AND (IsNull(MyInteg erColumnName, 0) = 0)"
for columns of Integer...

I know - looks strange, but it seems to work.
However I'm not sure if it's correct...

Is there any better way to get only dbnulls from boolean column?

Thanks
Marcin Dzióbek

[Rich P]

Your method seems OK except if you are trying to fix a data table on a
server DB where a boolean column contains null values -- I would fix
that at the server - set a default value of 0 for false and everywhere
that is null -- set to false. Then make that boolean column to not
allow null values (will be a bit column).

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[=?iso-8859-1?Q?Marcin_Dzi=F3bek?=]

Hi Rich:

Thaks for replay:

.... except if you are trying to fix a data table on a
server DB where a boolean column contains null values -- I would fix
that at the server - set a default value of 0 for false and everywhere
that is null -- set to false. Then make that boolean column to not
allow null values (will be a bit column).

1. I can't use RDBMS to "fix" table... I'm just trying to develop user control: another custom datagridview with
filter's tools.
It has a property - datasource - where the consumer will assign reference to "his own" datatable. What if consumer will
use ReadXml to create dataset and datatable?

2. IMHO: table "where a boolean column contains null values" is OK - I wouldn't change that. If we eliminated null
values by changing table/database project in RDBMS, we still cannot avoid null values in System.Data.Dat aTable object.
I'm not sure even if datadapter.fill method sets DataColumn.Allo wDBNull and DataColumn.Defa ultValue properties; it may
depend MissingSchemaAc tion property and kind of RDBMS... but ofcourse I may be wrong.

--
Marcin Dzióbek

[Rich P]

Hello again,

my explanation pertains primarily to MS Sql Server. I am fairly certain
that if a table on the backend DB contains a bit column to be used as a
boolean column -- it would be counter intuitive to have 3 values -
True/Null/False. The field should either be true or false if it is a
boolean column. Thus, if your project is using this column as a boolean
and the Null value cannot be eliminated - then the suggestion that I
offer is that I wish you well. My question is this: why compensate for
something down the road instead of fixing it at the source?

IF there is no possibility of fixing your problem at the source, then it
appears that the method you are asking about is the only way for you to
continue with your project.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Steve Gerrard]

Marcin Dzióbek wrote:

Hi All:

I need to get (filter in) some dataview's rows with DBNULLs in column
of boolean type: Actually to get the only rows with DBNULL, I use code like
this:

DV.RowFilter = "(IsNull(MyBool eanColumnName, True) = True) AND
(IsNull(MyBoole anColumnName, False) = False)"
or ex.
DV.RowFilter = "(IsNull(MyInte gerColumnName, 1) = 1) AND
(IsNull(MyInteg erColumnName, 0) = 0)" for columns of Integer...

I know - looks strange, but it seems to work.
However I'm not sure if it's correct...

Is there any better way to get only dbnulls from boolean column?

It is so simple, you will kick yourself:

DV.RowFilter = "MyColumnNa me Is Null"

[=?iso-8859-2?Q?Marcin_Dzi=F3bek?=]

Hi Steve:

It is so simple, you will kick yourself:

DV.RowFilter = "MyColumnNa me Is Null"

You're absolutely right! How could I live without that...
Now I kick myself :)

THANKS!

--
Marcin Dzióbek

[=?iso-8859-1?Q?Marcin_Dzi=F3bek?=]

>... My question is this: why compensate for

something down the road instead of fixing it at the source?

IMHO there is nothing to fix. I just don't agree that null values are wrong.

IF there is no possibility of fixing your problem at the source, then it
appears that the method you are asking about is the only way for you to
continue with your project.

Steve opened my eyes... there is better method (should be mentioned in MSDN DataView.RowFil ter's help page).

Thanks
--
Marcin Dzióbek