بالاخره با این دستور جواب داد :
cmd.CommandText = "Select * from TblRejimDayes where (BakhshId = @BakhshId And Date= (SELECT MAX(Date) FROM TblRejimDayes ) And Vadeh= (SELECT MAX(Vadeh) FROM TblRejimDayes ) ) ";
بالاخره با این دستور جواب داد :
cmd.CommandText = "Select * from TblRejimDayes where (BakhshId = @BakhshId And Date= (SELECT MAX(Date) FROM TblRejimDayes ) And Vadeh= (SELECT MAX(Vadeh) FROM TblRejimDayes ) ) ";