datetime? passing null in SQL when not entered

Question

HomeController.cs

AnketForm.cs

Index.cshtml

SQL Server

Opened Form

The user may or may not enter a Date.

The program runs when the user enters the date. But when it doesn't I get an error.

How can I leave the date field blank? So if the user doesn't want to enter Date, I want it to be Null or empty in SQL. ?????

Answer 1

Hi @Harun Ergün,

You can try this: DateTime? dt = string.IsNullOrEmpty(date) ? (DateTime?)null : DateTime.Parse(date);

It is not clear how you save the data to the database, you can refer to the following to add DBNull.Value.

cmd.Parameters.AddWithValue("@Date", (object)dt ?? DBNull.Value);

Best regards,
Lan Huang

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I found the solution. I practiced my every move

if (cnvrt["lisansBaslamaTarih"].Value<string>() != "")

af.LisansBaslangicTarih = cnvrt["lisansBaslamaTarih"].Value<DateTime?>();

Thanks for Helping