I have a data table where I would like to filter all rows which do not have
0 in QTY field. At least one record has this field set to a number which is
different form 0 (and not null of course). When I create data view:

testDV = new DataView( this.dataSet.Tables["PRODUCTS"], "QTY <> 0", "",
DataViewRowState.CurrentRows ) ;

No records are returned in data view.

What am I doing wrong?

Regards

Simon

Simon,

Could you please post XML file with data and schema of this dataset so I
could reproduce the problem? Thanks.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
>From: "Simon" <(E-Mail Removed)>
>Subject: Bug in DataVew?
>Date: Thu, 18 Sep 2003 14:11:12 +0200
>Lines: 16
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Message-ID: <(E-Mail Removed)>
>Newsgroups: microsoft.public.dotnet.framework.compactframework
>NNTP-Posting-Host: 195.250.204.222
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
>Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:33837
>X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework
>
>I have a data table where I would like to filter all rows which do not have
>0 in QTY field. At least one record has this field set to a number which is
>different form 0 (and not null of course). When I create data view:
>
>testDV = new DataView( this.dataSet.Tables["PRODUCTS"], "QTY <> 0", "",
>DataViewRowState.CurrentRows ) ;
>
>No records are returned in data view.
>
>What am I doing wrong?
>
>Regards
>
>Simon
>
>
>