練習使用jQuery DataTable套件，資料庫內容是用北風資料庫

目前是已經成功將資料取出且呈現在datatable了，但日期格式卻想不出要怎麼處理 @@

已經有試過ToString("yyyy-MM-dd")、format日期格式，但還是會把時間的部分呈現在畫面上，請教各位要怎麼修改Code的部分，才只會顯示日期就好?

謝謝

程式碼

Models

public class OrdersList
    {
        public List<Orders> OdList(string OrderID)
        {
            List<Orders> itemS = new List<Orders>();

            string sql = string.Format(@"Select * From Orders", OrderID);

            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[""].ConnectionString);

            try
            {
                conn.Open();
                SqlDataAdapter adpt = new SqlDataAdapter();
                using (SqlCommand cmd = new SqlCommand())
                {
                    DataTable ds = new DataTable();
                    cmd.Connection = conn;
                    cmd.CommandText = sql;
                    adpt.SelectCommand = cmd;
                    adpt.Fill(ds);

                    foreach (DataRow row in ds.Rows)
                    {
                        Orders item = new Orders();
                        
        item.OrderID = Int32.Parse(row["OrderID"].ToString());
        item.CustomerID = row["CustomerID"].ToString();
        item.EmployeeID = Int32.Parse(row["EmployeeID"].ToString());
        item.OrderDate = DateTime.Parse(row["OrderDate"].ToString());
        item.RequiredDate = DateTime.Parse(row["RequiredDate"].ToString());
        item.ShippedDate = DateTime.Parse(row["ShippedDate"].ToString());
        item.ShipVia = Int32.Parse(row["ShipVia"].ToString());
        item.Freight = decimal.Parse(row["Freight"].ToString());
        item.ShipName = row["ShipName"].ToString();
        item.ShipAddress = row["ShipAddress"].ToString();
        item.ShipCity = row["ShipCity"].ToString();
        item.ShipRegion = row["ShipRegion"].ToString();
        item.ShipPostalCode = row["ShipPostalCode"].ToString();
        item.ShipCountry = row["ShipCountry"].ToString();

                        itemS.Add(item);
                    }
                }
            }
            catch (Exception ex)
            {
                var Error = ex.Message;
                Console.WriteLine(ex.ToString());
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }

            return itemS;
        }
    }

Controller

public ActionResult OrdersList()
        {
           
            return View();
        }
        [HttpPost]
        public string GetOrders(string OrderID)
        {
            using (NorthwindEntities db = new NorthwindEntities())
            {
                OrdersList con = new OrdersList();
                var result = con.OdList(OrderID);
                
                return JsonConvert.SerializeObject(result);
            }
        }

Views
View的部分就是使用jquery + ajax接後端資料