can not vaildate date in asp.net

Question

can not vaildate date in asp.net

mush 181

I'm trying to validate date where if the date in the database is equal or greater than the current date it shows some message otherwise it shows another message.
I tried this but it always skips the first message even though there is entry in the database where the date is greater than the current date:

(for some reason the system here wouldn't allow me to post my code so I put this screenshot instead. )

Yijing Sun-MSFT 7,106 Reputation points

2022-03-23T08:40:48.95+00:00

Hi @mush ,
Are you sure you get the date which is greater then the current date in the code-behind? What's the value of closedate now?
Best regards,
Yijing Sun
AgaveJoe 30,406 Reputation points

2022-03-23T10:46:41.327+00:00
The design checks the first record in a result set which is unusual. The fact that there several joins indicates there are multiple records returns. Plus the error message indicates multiple records are returns.

I think you need to fix the design. Rather than checking the date in C# add the filter to the WHERE clause.

AND cod >= GETDATE()

The user has assignments if records are returned.
mush 181 Reputation points

2022-03-24T03:58:35.153+00:00

I actually rechecked my table and discovered some issues with it and solved the problem. thank you anyway.
mush 181 Reputation points

2022-03-24T04:00:54.23+00:00

Thank you

Answer accepted by question author

0 additional answers

Your answer

Yijing Sun-MSFT 7,106 Reputation points

2022-03-23T08:40:48.95+00:00

Hi @mush ,
Are you sure you get the date which is greater then the current date in the code-behind? What's the value of closedate now?
Best regards,
Yijing Sun
AgaveJoe 30,406 Reputation points

2022-03-23T10:46:41.327+00:00

The design checks the first record in a result set which is unusual. The fact that there several joins indicates there are multiple records returns. Plus the error message indicates multiple records are returns.

I think you need to fix the design. Rather than checking the date in C# add the filter to the WHERE clause.

AND cod >= GETDATE()

The user has assignments if records are returned.
mush 181 Reputation points

2022-03-24T03:58:35.153+00:00

I actually rechecked my table and discovered some issues with it and solved the problem. thank you anyway.
mush 181 Reputation points

2022-03-24T04:00:54.23+00:00

Thank you

Answer 1

Bruce (SqlWork.com) 81,976 Volunteer Moderator

also your sql code allows sql injection. you should change to parameters.

mush 181 Reputation points

2022-03-24T04:00:02.027+00:00

This is not real project I'm just learning. but thank you for your advice I will consider it in the future.

Share via

can not vaildate date in asp.net

0 additional answers

Your answer