How to make C# DataTable filter

Question

my datatable;

    dtData

    ID | ID2
    --------
    1  |  2
    1  |  3


dtData.Select("ID = 1"); one more rows;

i want row "ID = 1 And ID2 = 3" how to make ?

Kieren Johnstone · Accepted Answer · 2010-07-29 12:11:25Z

32

Do you mean like this?:

dtData.Select("ID=1 AND ID2=3");

answered Jul 29, 2010 at 12:11

Kieren Johnstone

42.1k16 gold badges100 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MDV2000 · Accepted Answer · 2010-07-29 12:31:55Z

Okay, here is how I do such things...

    GridFieldDAO dao = new GridFieldDAO();
    //Load My DataTable
    DataTable dt = dao.getDT();
    //Get My rows based off selection criteria
    DataRow[] drs = dt.Select("(detailID = 1) AND (detailTypeID = 2)");
    //make a new "results" datatable via clone to keep structure
    DataTable dt2 = dt.Clone();
    //Import the Rows
    foreach (DataRow d in drs)
    {
        dt2.ImportRow(d);
    }
    //Bind to my new DataTable and it will only show rows based off selection 
    //criteria
    myGrid.DataSource = dt2;
    myGrid.DataBind();

Notice in my Select() I put the criteria in Parens between AND and OR

Hope this helps! Mike V

This is a better solution than throwing a DataRow[] around. If your filter happens to return no rows, and you need the schema somewhere deep in your code, you're not going to get it from an empty array!
Which namespace has GridFieldDAO? or isn't this available to winforms?

qlayer · Accepted Answer · 2012-12-10 09:14:00Z

6

Better use this :

GridFieldDAO dao = new GridFieldDAO();
//Load My DataTable
DataTable dt = dao.getDT();
//Get My rows based off selection criteria and copy them directly to datatable
DataTable dt2 = dt.Select("(detailID = 1) AND (detailTypeID = 2)").CopyToDataTable();

answered Dec 10, 2012 at 9:14

qlayer

4545 silver badges7 bronze badges

2 Comments

Ciupaz Over a year ago

CopyToDataTable is not defined. I've missed something?

qlayer Over a year ago

It is an extension method. You have to add a reference to System.Data.DataSetExtensions msdn.microsoft.com/en-us/library/bb396189(v=vs.110).aspx

Edwin O. · Accepted Answer · 2015-11-08 21:08:56Z

4

DataTable dt2 = dt.Select("ID = 1").CopyToDataTable;

make sure dt has rows in it

answered Nov 8, 2015 at 21:08

Edwin O.

5,32646 silver badges45 bronze badges

Comments

Rohan Rao · Accepted Answer · 2019-10-22 10:37:45Z

2

Here you can copy your contents to another DataTable by using CopyToDataTable method of Linq while selecting the specific rows by filtering.

DataTable dt2 = dt.Select("state = 'FL' ").CopyToDataTable;

edited Oct 22, 2019 at 10:37

Rohan Rao

2,6413 gold badges24 silver badges40 bronze badges

answered Oct 27, 2016 at 16:39

Juan Carlos Guerra

211 bronze badge

1 Comment

pix Over a year ago

You should add more detail to you answer, explain to the others why this is working.

brasofilo · Accepted Answer · 2014-05-27 20:28:14Z

0

Great example and very helpful. Wanted to add one thing - if you need to select on a string use something like:

DataTable dt2 = dt.Select("state = 'FL' ");

edited May 27, 2014 at 20:28

brasofilo

26.2k15 gold badges96 silver badges188 bronze badges

answered May 27, 2014 at 20:18

user3681298

171 bronze badge

1 Comment

kleineg Over a year ago

Error: Cannot implicitly convert type 'System.Data.DataRow[]' to 'System.Data.DataTable'

Collectives™ on Stack Overflow

How to make C# DataTable filter

6 Answers 6

Comments

2 Comments

2 Comments

Comments

1 Comment

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

2 Comments

2 Comments

Comments

1 Comment

1 Comment

Linked

Related