Skip to main content
C# Filter DataSet by Date 01

C# Filter DataTable by Date

C# Filter DataTable by Date Several times, situation appears wherein we have already fetched data from database but we need it to filter by date. This post explains how we can filter C# datatable using date. Syntax : DataTable dt = datatableId.Select().Where(p => (Convert.ToDateTime(p[“YourDateColumnName”]) >= Convert.ToDateTime(FilterFromDate)) && (Convert.ToDateTime(p[“YourDateColumnName”]) <= Convert.ToDateTime(FilterToDate))).CopyToDataTable(); So, let’s try it on actual scenario. […]

Read More

C# Filter DataSet by Date 02

C# Filter DataSet by Date

C# Filter DataSet by Date Several times, situation appears wherein we have already fetched data from database but we need it to filter by date. This post explains how we can filter C# dataset using date. Syntax : DataTable dt = datasetId.Tables[0].Select().Where(p => (Convert.ToDateTime(p[“YourDateColumnName”]) >= Convert.ToDateTime(FilterFromDate)) && (Convert.ToDateTime(p[“YourDateColumnName”]) <= Convert.ToDateTime(FilterToDate))).CopyToDataTable(); So, let’s try it on actual […]

Read More