Donate

How To Insert Date Object In MySQL Using C#.NET

Hello,

To insert date object using C#.net in MySQL db,use the code below:
  string query = String.Format("Insert into tbllistings(DateRegistered)"  
   + "values(DATE_FORMAT({0}, '%Y-%m-%d %h:%m:%s'))",objJobs.DateRegistered); 

The key to the solution is using the MySQL Date format function.

Comments

Donate

Popular Posts From This Blog

WPF CRUD Application Using DataGrid, MVVM Pattern, Entity Framework, And C#.NET

How To Insert Or Add Emojis In Microsoft Teams Status Message

Bootstrap Modal In ASP.NET MVC With CRUD Operations