Re: Search the Date Range Functionality in datatable

Question

Hi All Any one Working Data table Concept  i need Date Range Search  please Give me suggestion.

Abhay Shanker · Answer

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();

Abhay Shanker · Answer

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] select row; var filteredTable = table.Clone(); filteredRows.ToList().ForEach(r => filteredTable.ImportRow(r)); return filteredTable; }

Abubakar Dandoti · Answer

use this datatable dtbl=new datatable();dataview dv=new Dataview(dtblDatetime1>=#+passyorDate1+# And Datetime2