Get Records from DataTable

Question

0.00/5 (No votes)

See more:

.NET3.0

.NET3.5

I have DataTable having DataTime type column, i want to select records from table on hour basic from Datetime column field.

want same result of Sql Query " select ColumnName from TableName where datepart(HOUR,ColumName)=09"

09 is hour value.

If have any idea please share.

Posted 4-Jun-14 19:45pm

SachinSutar

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 5-Jun-14 1:51am

Have you tried anything for that?

SachinSutar 5-Jun-14 2:19am

I tried but it works only for date not for time part.

var rows = ObjTargetRange.RangeDataTable.Select(ObjFromRange.DataSource + ">= #" + StartVal + "# AND " + ObjFromRange.DataSource + " <= #" + EndVal + "#");

2 solutions

Solution 1

That query works perfectly well for me when I use 9 as the value.

09 seems to indicate you are storing the data as text and not datetime in which case you are screwed until you change the format to datetime.

Posted 4-Jun-14 19:52pm

Mycroft Holmes

Comments

SachinSutar 5-Jun-14 2:10am

In sql 09 is also ok it works perfectly but i want to execute it in c# on the datatable (may be using some Linq) not in datatbase table.

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)

DamithSL · Accepted Answer · 2014-06-04T20:18:00

You need to reference the System.Data.DataSetExtensions assembly and use the System.Data namespace.

C#

dt =dt.AsEnumerable()
       .Where(r=>r.Field<datetime>("DateCol").Month ==9)
       .CopyToDataTable();

And read the documentation for .NET Framework 3.5
Creating a DataTable From a Query (LINQ to DataSet)[^]

C#

below is sample code from above reference 
// Bind the System.Windows.Forms.DataGridView object 
// to the System.Windows.Forms.BindingSource object.
dataGridView.DataSource = bindingSource;

// Fill the DataSet.
DataSet ds = new DataSet();
ds.Locale = CultureInfo.InvariantCulture;
FillDataSet(ds);

DataTable orders = ds.Tables["SalesOrderHeader"];

// Query the SalesOrderHeader table for orders placed  
// after August 8, 2001.
IEnumerable<DataRow> query =
    from order in orders.AsEnumerable()
    where order.Field<DateTime>("OrderDate") > new DateTime(2001, 8, 1)
    select order;

// Create a table from the query.
DataTable boundTable = query.CopyToDataTable<DataRow>();

// Bind the table to a System.Windows.Forms.BindingSource object,  
// which acts as a proxy for a System.Windows.Forms.DataGridView object.
bindingSource.DataSource = boundTable;