C# : Filtering data of data table using select method

Question

I have data table containing one column as FilePath.

FilePath
D:\New folder\link.txt
D:\New folder\SharepointMigration(Work Schedule).xls
D:\New folder\my2\link.txt
D:\New folder\my2\SharepointMigration(Work Schedule).xls
D:\New folder\my2\my3\New Text Document.txt
D:\New folder\Try.txt

I am filtering my data table by

DataRow[] dtRow = dataTable_FilesWithMetaData.Select("FilePath Like '" + sourcePath + "%'");

But it gives me all files and subfolder files. But i want only files not subfolders. How to write such type of filter expression..??

EDIT: I am using VS-2008 2.0 framework. The files are coming from some server in xml format and then i am populating my gridview.

João Angelo · Accepted Answer · 2010-03-23 12:45:19Z

2

If LINQ is available:

DataTable dt = new DataTable();

dt.Columns.Add("FilePath", typeof(string));

dt.Rows.Add(@"D:\New folder\link.txt");
dt.Rows.Add(@"D:\New folder\my2\link.txt");

string target = Path.GetDirectoryName(@"D:\New folder\");

DataRow[] rows = dt.Rows.Cast<DataRow>().Where(dr =>
    Path.GetDirectoryName(((string)dr["FilePath"])).Equals(target))
    .ToArray();

This will only return the row containing ("D:\New folder\link.txt").

In .NET 2.0 you can create a helper method, something like this:

public static DataRow[] GetRowsForDir(DataTable table, string targetDir)
{
    var result = new List<DataRow>();

    foreach (DataRow row in table.Rows)
    {
        if (Path.GetDirectoryName(((string)row["FilePath"])).Equals(targetDir))
        {
            result.Add(row);
        }
    }

    return result.ToArray();
}

edited Mar 23, 2010 at 12:45

answered Mar 23, 2010 at 12:34

João Angelo

58k13 gold badges149 silver badges149 bronze badges

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

1 Comment

Royson Over a year ago

Thanks João Angelo, Ur helper method works..Good way to do such thing.. Thanks 1s again ;)

Dan McClain · Accepted Answer · 2010-03-23 12:29:23Z

0

If the files are on the machine running the application, why not just do a

Directory.GetFiles(sourcePath)

for the path you want?

answered Mar 23, 2010 at 12:29

Dan McClain

12k9 gold badges51 silver badges68 bronze badges

1 Comment

Royson Over a year ago

The files are coming from some server in xml format and then i am populating gridview.

Collectives™ on Stack Overflow

C# : Filtering data of data table using select method

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related