i use asp.net mvc and c# i have data table that have many column,one column has 'time' and sotred data like this format
14 16:30 17:05 ...
in view i have filter for time and user can select multiple time from check box, my filter check box is
4 - 8 8 - 11 11 - 14 14 - 17 17 - 21 21 - 24
now i want filter from datatable
var result = from r in myDataTable.AsEnumerable() where r.Field<string>("time") // between any passed time,like between 4-8 and 11-14 and 21-24 select r; DataTable dtResult = result.CopyToDataTable();
my problem is,i dont know user how many pass time , if just passed one time it's easy but i dont know how many time passed
how i can edit code for accept any time and any count of time?
thank you for your help