Hi @ppr ,
Thanks for quick response.
I tried this logic its working fine for filtering data. But there is problem while uploading the same data to DB as 3rd column(variable type - DateTime) has null values, so i was considering it as an object while build datatable in my for loop logic and with that approach i was not facing any issue for upload datatime with null values which basically shown as “” in debug mode. Could you suggest me the additional logic for the same linq query.
please find attached screenshot for the error i am recieving now.
please find screenshots in topic for logic i implemented earlier.
Thanks in Advance