How to search C# DataTable

Question

0.00/5 (No votes)

See more:

I have a DataTable which has two columns, id and date (which is in DateTime format -> yyyy-dd-MMThh:mm:ss).
I have a requirement of showing data that corresponding to this month. How is it possible ?

Posted 27-Jul-14 4:37am

Gee Varghese

Updated 22-Mar-23 4:26am

Add a Solution

4 solutions

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)

OriginalGriff · Answer 1 · 2014-07-27T05:06:00

Solution 1

Generally, I don't search DataTables: I tend to filter DataViews instead.
Assuming you are using a DataGridView, create a class level DataView using the DataTable as it's source and use the DataView as the DataSource of the DGV:

C#

        private DataView dvBooks = new DataView();
...
            DataTable dt = myList.ToDataTable();
            dvBooks = new DataView(dt);
            dgvBooks.DataSource = dvBooks;

Then use the RowFilter property to filter the displayed rows:

C#

dgvBooks.RowFilter = "[date] LIKE '%-" + monthNumber.ToString("D2") + "T%'";

The system will only show matching records.

Posted 27-Jul-14 5:06am

OriginalGriff

Comments

Gee Varghese 27-Jul-14 11:13am

I don't use Gridviews.
I have loaded my Datatable with data from a List<class objects="">.
My requirement is to load data from List<Objects> to the Datatable which have date of this month. Or show data of this month from Datatable. I prefer to choose Linq.

OriginalGriff 27-Jul-14 11:28am

So why not just use Linq on the List? That's trivial, isn't it?
Then load the DT from that.

Gee Varghese 27-Jul-14 11:38am

How do we do that ?

OriginalGriff 27-Jul-14 11:57am

Which? Linq on the List or load the table?

Gee Varghese 27-Jul-14 11:58am

Whichever, either on the list or the Datatable.

PIEBALDconsult 27-Jul-14 11:33am

Whatever you use to display/process rows from the DataTable, get in the habit of using the DefaultView property of the DataTable rather than the DataTable itself.
Then set the RowFilter.
And I hope you're not storing date/time data as strings.

PIEBALDconsult 27-Jul-14 11:29am

A DataTable also has a DefaultView property, so you don't absolutely need to create a new one.

OriginalGriff 27-Jul-14 11:36am

:Doh: I'd forgotten that!

Gee Varghese 27-Jul-14 11:47am

Is it possible to do like : (SOHeader is a table)

var a= from p in SOHeader.AsEnumerable()
where p.Field<datetime>("SO_Date").Month==DateTime.Now.Month
select new
{
Year = p.Field<int>("Date")
};

hisham elmsry · Answer 2 · 2023-03-22T04:23:00

Solution 3

ADO.NET(DataTable.Select):

DataRow[] filteredRows = tb.Select("CREATOR LIKE '%" + searchstring + "%'");

ADO.NET(DataView.RowFilter):

 tb.DefaultView.RowFilter = "CREATOR LIKE '%" + searchstring + "%'";

Posted 22-Mar-23 4:23am

hisham elmsry

Updated 22-Mar-23 4:24am

v2

hisham elmsry · Answer 3 · 2023-03-22T04:26:00

Solution 4

LINQ-To-DataSet (which i prefer):

var filtered = tb.AsEnumerable()
    .Where(r => r.Field<String>("CREATOR").Contains(searchstring));
ADO.NET(DataTable.Select):

DataRow[] filteredRows = tb.Select("CREATOR LIKE '%" + searchstring + "%'");
ADO.NET(DataView.RowFilter):

 tb.DefaultView.RowFilter = "CREATOR LIKE '%" + searchstring + "%'";

Posted 22-Mar-23 4:26am

hisham elmsry

Comments

CHill60 22-Mar-23 11:30am

Please don't post multiple solutions to the same question - it is confusing. You can use the "Improve Solution" link to update your first solution post.
As an aside, I notice that all the solutions you are posting are to old questions that already have solutions. Be aware that some members will view this as "rep point hunting" and may start the process of disabling your account. It is better to stick to new posts where the OP still needs help

Dave Kreskowiak 22-Mar-23 13:50pm

And start explaining your answers. Just dumping code into an answer doesn't cut it.

Sharmanuj · Answer 4 · 2014-07-27T20:26:00

Solution 2

use Select method for Datatable to filter the record. This will return the array of DataRow.

Posted 27-Jul-14 20:26pm

Sharmanuj