Solved

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

Posted on 2009-05-13
6
295 Views
Last Modified: 2012-05-06
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 :)


0
Comment
Question by:MSFanboy
  • 4
  • 2
6 Comments
 
LVL 9

Expert Comment

by:wellhole
Comment Utility
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
 

Author Comment

by:MSFanboy
Comment Utility
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
 

Author Comment

by:MSFanboy
Comment Utility
I also tried this:

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

0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

by:MSFanboy
Comment Utility
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
 
LVL 9

Accepted Solution

by:
wellhole earned 500 total points
Comment Utility
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
 

Author Comment

by:MSFanboy
Comment Utility
ah damn above I have a for loop with i or j, thx that you saw the error and for the snippet
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Extention Methods in C# 3.0 by Ivo Stoykov C# 3.0 offers extension methods. They allow extending existing classes without changing the class's source code or relying on inheritance. These are static methods invoked as instance method. This…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This video discusses moving either the default database or any database to a new volume.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now