Re: Search the Date Range Functionality in datatable

You can also try as below

 DataTable dt2 = new DataTable();

    dt2 = ds.Tables[0].Select().Where(p => (Convert.ToDateTime(p["DOB"]) >= Convert.ToDateTime("12/12/1996")) && (Convert.ToDateTime(p["DOB"]) >= Convert.ToDateTime("12/12/1996"))).CopyToDataTable();

0

Abhay Shanker10y ago

You can try as below

private DataTable FilterTable(DataTable table, DateTime startDate, DateTime endDate)

{

var filteredRows =

from row in table.Rows.OfType()

where (DateTime) row[0] >= startDate

where (DateTime) row[0] <= endDate

select row;

var filteredTable = table.Clone();

filteredRows.ToList().ForEach(r => filteredTable.ImportRow(r));

return filteredTable;

}

0

Abubakar Dandoti10y ago

use this

datatable dtbl=new datatable();dataview dv=new Dataview(dtbl,"Datetime1>=#"+passyorDate1+"# And Datetime2<=#"+passyorDate2);

0