How can I find out the the rows filtered by the dataview.Rowfitler ?

Hello,

when I set a dataview with a Rowfilter, can I find out somehow what is the filtered data?

my table:

id.Name
1  mary
2 michael
3 hans
4 georg

my filter:

dataview.Rowfilter = " Name = ' michael ' ";

How can I retrieve the other 3 names without using the Rowfilter again like this:

dataview.Rowfilter = " Name <> 'michael';

HOpe the question is clear :)


MSFanboyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
wellholeConnect With a Mentor Commented:
foreach (DataRowView row in dataview)
{
  row[3]          <--------- thats the value in the 4th column
}

In your above sample, it'll be best if you don't mix up i and j......
0
 
wellholeCommented:
You can ..... Loop through the rows in dataview.Table and pick out the ones that aren't in your filtered dataview.

or

Create a second dataview and create the opposite filter on that instead.
0
 
MSFanboyAuthor Commented:
ah bad I told you crap...
requirements have changed actually again:

I want to enumerate through the dataview to get the each value in every row in the filtered dataview.

foreach (DataRowView row in dataview)
 {                     
    row.value doesnt work
    row.Row[3]. doesnt work // I want to get the value in the 4th column of the actual row of my dataview
 }

How can I enumerate through all Rows of the dataview and get a value of each row in a certain column?
I have to compare the one value in a dataview`s [row,column] with the value of a datareader...


0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
MSFanboyAuthor Commented:
I also tried this:

foreach (DataRowCollection row in dataview.Table.Rows)
{
    row. // no value or cell I get :/
}

0
 
MSFanboyAuthor Commented:
for (int j = 0; i < dataview.Count; i++)
               {
                          var articlenumber = dataview[j].Row[3].ToString();
}


found a sample in vb and changed it to c#, pretty stupid that there is no Row.Value or Cell.Value as someone could expect it.
0
 
MSFanboyAuthor Commented:
ah damn above I have a for loop with i or j, thx that you saw the error and for the snippet
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.