DateTime binding in MVC Core

Shailesh Bist

Hello,

This is my first try at MVC Core.

I have a table with datetime data type. I have defined the model for this table.

When I declare the property in the model as datetime, the model does not show any records.

When I declare the property as string, the model shows data, but then then the context returns invalid cast from datetime to string error.

Kindly guide.

Thanks.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shailesh Bist3y ago
Hi Vishal,

Thanks for the response.

My context code is as below.

public class ApplicationDbContext : DbContext
{
public ApplicationDbContext(DbContextOptions options) : base(options)
{

}

  public DbSet RAJ_AAJ_KA_SHABDH { get; set; }
public DbSet RAJ_DAILY_SHABD { get; set; }
}

My controller code is as below.

public async Task Index()
{

List AAJ =await _db.RAJ_AAJ_KA_SHABDH.ToListAsync();

HomePageVM VM = new HomePageVM()
{
   DailyHindi = GetHindiText(_db.RAJ_AAJ_KA_SHABDH.Find(_db.RAJ_DAILY_SHABD.FirstOrDefault().Sr_No).Hindi_Description.ToString()),
DailyEnglish = _db.RAJ_AAJ_KA_SHABDH.Find(_db.RAJ_DAILY_SHABD.FirstOrDefault().Sr_No).English_Description.ToString(),
};
return View(VM);
}

When I declare the property as datetime, the code highlighted in red gives errror because the dbset is null.

When I declare the property as string, then I get string to datetime conversion error in the code highlighted in yellow.

Regards

Vishal Joshi3y ago

Hello Shailesh

Please try the below code to work with the date in MVC.

//Model
[Required(ErrorMessage = "Enter the issued date.")]
[DataType(DataType.Date)]
public DateTime IssueDate { get; set; }


// Razor Page Or View
@Html.ValueFor(model => model.RegistrationDate, "{0:dd/MM/yyyy}")


//Web.Config

Sachin Singh3y ago

On view page do this

@Convert.ToDateTime(Model.DateTimeField).ToString("dd MMM yyyy")

Pankajkumar Patel3y ago
Display DateTime value in dd/mm/yyyy format in Asp.NET MVC
- https://stackoverflow.com/questions/18288675/display-datetime-value-in-dd-mm-yyyy-format-in-asp-net-mvc
Hope this will help you!
Shailesh Bist3y ago
Hi Pankaj,

Thanks for the information. I checked the link. This is when we post data.

In my case, I am not posting anything. This is just a view page. Will it work for this view also?

Thanks.
Pankajkumar Patel3y ago
Hi Shailesh Bist,

This is one of the good link with practical example:
- CUSTOM DATETIME FORMAT IN ASP.NET CORE MVC 5
  
  https://learningprogramming.net/net/asp-net-core-mvc-5/custom-datetime-format-in-asp-net-core-mvc-5/
Hope this will help you!