Filtering datatable using dataview

Question

0.00/5 (No votes)

See more:

I have a datatable it contains 3 rows and i want to query for one value

<pre lang="c#">DataView dv=new DataView(_dtrecomendationData);
 if (dv.RowFilter=="Priority=2")
                    {
                        _dtrecomendationData.Rows[0][0] = "--";
                    }

The problem is even though priority value is 2 it is not working.

Posted 13-Jul-14 23:47pm

chandra sekhar

Updated 13-Jul-14 23:50pm

v2

Add a Solution

Comments

ashok rathod 14-Jul-14 5:54am

what is type of priority column ?

chandra sekhar 14-Jul-14 5:56am

Integer

ashok rathod 14-Jul-14 5:57am

try out

dv.RowFilter-"Priority='2'"

ashok rathod 14-Jul-14 6:07am

here dv.RowFilter will not return boolean type so it wont get into if loop. can you check is it going into if loop and second thing here is that as u had taken two things DataView and datatable so they both will work as differently. So Try out (dv.DefaultView as DataTable).Rows[0][0] does it making any difference ?

2 solutions

Solution 2

you can try like this
Filtered value requires 'value' pattern

dataView.RowFilter = "Price = '1199.90'"

http://www.csharp-examples.net/dataview-rowfilter/[^]

Posted 14-Jul-14 0:30am

Thakkar Vipul

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)

PrakashCs.net · Accepted Answer · 2014-07-14T00:08:00

Solution 1

use following code

C#

DataView dv=new DataView(_dtrecomendationData);
 dv.RowFilter = "Priority = 2";
 if (dv.ToTable().Rows.Count > 0)
       {
            _dtrecomendationData.Rows[0][0] = "--";
        }

Posted 14-Jul-14 0:08am

PrakashCs.net

Updated 14-Jul-14 0:21am

v2

Comments

chandra sekhar 14-Jul-14 6:18am

Edit the post i am unable to see dv.Rowfilter==??

PrakashCs.net 14-Jul-14 6:26am

if you want to update same row which is filter use following code

if (_dtrecomendationData.Select("Priority = 2").Length > 0)
{
DataRow[] dr = _dtrecomendationData.Select("Priority = 2");

foreach (DataRow dre in dr)
{
dre["Priority"] = "--";
}

_dtrecomendationData.AcceptChanges();
}

chandra sekhar 14-Jul-14 6:27am

But what if i have more rows with the priority=2?? I have to makes them as --

PrakashCs.net 14-Jul-14 6:36am

use this solution

if you want to update same row which is filter use following code

if (_dtrecomendationData.Select("Priority = 2").Length > 0)
{
DataRow[] dr = _dtrecomendationData.Select("Priority = 2");

foreach (DataRow dre in dr)
{
dre["Priority"] = "--";
}

_dtrecomendationData.AcceptChanges();
}