Apurva Singh

Apurva Singh

  • NA
  • 268
  • 56.5k

Get Min time and Max time from datatable date in C#

Oct 9 2020 3:38 AM
I Have a datatable in which itwo column  Datetime and userid. 
 
I have to get maxtime and min thime with where condition date and userid  in C#
 
I am using this query
 
DateTime OutDateTime = Convert.ToDateTime(record.Compute("MAX(DateTime)", "UserId='" + enrNo + "' and Tdate='" + DateTimee + "'")); DateTime InDateTime = Convert.ToDateTime(record.Compute("MIN(Tdate)", "UserId='" + enrNo + "' and Tdate='" + DateTimee + "'")); 
 
Please help me

Answers (4)