data table filter by date

Question

I have a data table in my webpage .The table contains Name IdDate columns respectively.I want to filter the data table by mean of a date.I have two calendars on my webpage from that am selecting from date and to date .How to show the data in a table that lie between the selected date range ? Suggest me how to do?

Midhun T P · Answer

Hi Dinesh You cannot use && operator here. You should write code like below - DataView dv = new DataView(myTable); dv.RowFilter = (( Name=' + ddllicense.SelectedItem.Text + ' and Date >= # + Calendar1.SelectedDate + # AND Date + Calendar2.SelectedDate + # ));

Dinesh Santhalingam · Answer

Mithun Thanks.

Dinesh Santhalingam · Answer

Mithun operator '&&' cannot be applied to operands of type string.

Midhun T P · Answer

Hi Please specify the error you are getting.

Dinesh Santhalingam · Answer

DataView dv = new DataView(myTable); dv.RowFilter = (( Name=' + ddllicense.SelectedItem.Text + ' ) && ( Date >= # + Calendar1.SelectedDate + # AND Date + Calendar2.SelectedDate + # )); I tried this but it showing error.

Midhun T P · Answer

Hi Please try below code - DataRow[] rows = dt.Select(date >= # + from_date + # AND date