neel k

neel k

  • NA
  • 143
  • 132.5k

Data table date validation

Apr 28 2016 4:38 PM
Hi, 
 
I have 2 data tables
 
DataTable dt1 = ds.Tables[0];
DataTable dt2 = ds.Tables[1];
one is
 
start date                                            end date                                             
 2016-06-20 00:00:00.000               2016-06-22 00:00:00.000                
2016-06-23 00:00:00.000                 2016-07-25 00:00:00.000                
2016-07-26 00:00:00.000                 2016-07-27 00:00:00.000               
 
second datatable
 
 Date                                
2016-06-20 00:00:00
2016-06-21 00:00:00
2016-06-22 00:00:00
2016-06-23 00:00:00
2016-06-24 00:00:00
2016-06-25 00:00:00
2016-06-26 00:00:00
2016-06-27 00:00:00
2016-06-28 00:00:00
2016-06-29 00:00:00
2016-06-30 00:00:00
2016-07-01 00:00:00
2016-07-02 00:00:00
2016-07-03 00:00:00
2016-07-04 00:00:00
2016-07-05 00:00:00
2016-07-06 00:00:00
2016-07-07 00:00:00
2016-07-08 00:00:00
2016-07-09 00:00:00
2016-07-10 00:00:00
2016-07-11 00:00:00
2016-07-12 00:00:00
2016-07-13 00:00:00
2016-07-14 00:00:00
2016-07-15 00:00:00
2016-07-16 00:00:00
2016-07-17 00:00:00
2016-07-18 00:00:00
2016-07-19 00:00:00
2016-07-20 00:00:00
2016-07-21 00:00:00
2016-07-22 00:00:00
2016-07-23 00:00:00
2016-07-24 00:00:00
2016-07-25 00:00:00
2016-07-26 00:00:00
2016-07-27 00:00:00
 
 
 How to validate 2nd table date is exist  in 1st table date range or not
 
I am using c#. 

Answers (1)