How to retrieve a new dataview

Question

0.00/5 (No votes)

See more:

Could you please help me in finding a solution. I don't want to loop through each datarow in the result data returned from dataview.rowfilter. I have a datatable and I use this to filter for the desired rows:

datatable.defaultview.rowfilter = "selective condition"

I want to retrieve the result into a new dataview( call it newview) and then I can filter for another collection of rows with another condition like this newview.rowfilter = "..."

Hope you understand my problem. I don't want to use combined conditions (to pass to the rowfilter of the original defaultview).

Any help is greatly appreciated.

Thank you very much!

Posted 25-Oct-11 0:47am

King Boy

Updated 25-Oct-11 0:52am

Slacker007

v2

Add a Solution

Comments

Slacker007 25-Oct-11 6:53am

Edit: readability and formatting.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

BobJanova · Accepted Answer · 2011-10-25T01:29:00

Solution 1

Use DataView.ToTable[^]:

DataTable dt = (some query expression);
dt.DefaultView.RowFilter = " ... ";
DataTable dt2 = dt.DefaultView.ToTable();

Note that this will copy the data. But I think that that has to happen for any solution to your problem, because you want to leave the initial table intact and not use a combined filter expression (which would be how you would create a double-filtered view without copying data).

Posted 25-Oct-11 1:29am

BobJanova

Comments

[no name] 26-Oct-11 18:13pm

Thank you very much!
That's exactly I wanted, but now I don't know how to assign the new dataview the the datatable.defaultview (because this is readonly), I have to choose the solution using combined conditions. If you know how to assign the new dataview to the defaultview, please let me know. Anyway, thank you very much!