chopperfield
chopperfield

Reputation: 577

datatable select filter where column timespan

i want to ask, how do i set condition or expression where the column table is type of timespan. when i use this code

private void button1_Click(object sender, EventArgs e)
    {
        string expression2;
        expression2 = "timeOnlyStart < '" + TimeSpan.Parse("10:00:00") + "'";
        DataTable yyy = dt_Main.Select(expression2).CopyToDataTable();
        gridControl3.DataSource = yyy;
    }

it gives me error enter image description here.

EDITED : timeOnlyStart is a column start

enter image description here

Upvotes: 0

Views: 1876

Answers (1)

Damith
Damith

Reputation: 63105

You can use Linq to filter rows

var results = from myRow in dt_Main.AsEnumerable()
              where myRow.Field<TimeSpan>("timeOnlyStart") < TimeSpan.Parse("10:00:00")
              select myRow;
gridControl3.DataSource  = results.AsDataView();

if you need datatable

 var resultsdt = results.CopyToDataTable() 

Upvotes: 2

Related Questions