What's wrong with this filter?

[vvenk]

Hello:

I have the following code:

Dim lsFilter As String = Nothing
Select Case rblStatus.Selec tedItem.Value
Case "S"
lsFilter = String.Concat(" D_STAT_CD_C = '", "N'")
Case "R"
lsFilter = String.Concat(" D_STAT_CD_C <> '", "N'")
End Select
If Not lsFilter = Nothing Then
dsMain.Tables(0 ).Select(lsFilt er)
End If

When the value is 'R', it picks up the right filter expression, "D_STAT_CD_ C
<> '", "N'", but the Rowcount of dsMain.Tables(0 ) does not change.

What am I doing wrong?

Venki

[Ken Tucker [MVP]]

Hi,

dsMain.Tables(0 ).Select(lsFilt er) will return an array of
datarows. It will not change the count of the datatable.

Ken
------------------
"vvenk" <vv***@discussi ons.microsoft.c om> wrote in message
news:63******** *************** ***********@mic rosoft.com...

Hello:

I have the following code:

Dim lsFilter As String = Nothing
Select Case rblStatus.Selec tedItem.Value
Case "S"
lsFilter = String.Concat(" D_STAT_CD_C = '", "N'")
Case "R"
lsFilter = String.Concat(" D_STAT_CD_C <> '", "N'")
End Select
If Not lsFilter = Nothing Then
dsMain.Tables(0 ).Select(lsFilt er)
End If

When the value is 'R', it picks up the right filter expression,
"D_STAT_CD_ C
<> '", "N'", but the Rowcount of dsMain.Tables(0 ) does not change.

What am I doing wrong?

Venki

[Ross Presser]

On Tue, 11 Oct 2005 14:19:05 -0700, vvenk wrote:

When the value is 'R', it picks up the right filter expression, "D_STAT_CD_ C
<> '", "N'", but the Rowcount of dsMain.Tables(0 ) does not change.

What am I doing wrong?

Venki

What you're doing wrong is expecting the Rowcount of dsMain.Tables(0 ) to
change. dsMain.Tables(0 ).Select(lsFilt er) is a method call that will
return a collection of DataRows, and you are just throwing the return value
away.

You probably want to look into the DefaultView property of a DataTable at
this point. It is where you can set a persistent filter and then check the
rowcount.