CODEWITHSUNDEEP
c#datatable
Chicharito
Chicharito

Reputation: 1440

How to make C# DataTable filter

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 ?

Upvotes: 16

Views: 100004

Answers (6)

Juan Carlos Guerra
Juan Carlos Guerra

Reputation: 21

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;

Upvotes: 2

Edwin O.
Edwin O.

Reputation: 5276

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

make sure dt has rows in it

Upvotes: 4

user3681298
user3681298

Reputation: 17

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' ");

Upvotes: 0

qlayer
qlayer

Reputation: 454

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();

Upvotes: 6

MDV2000
MDV2000

Reputation: 812

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

Upvotes: 13

Kieren Johnstone
Kieren Johnstone

Reputation: 41983

Do you mean like this?:

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

Upvotes: 33

Related Questions