void reLoadData() { var dt = QueryForSQLServer.GetPurchase(); allPurchase = new ObservableCollection <object>(); //purchase foreach (DataRow item in dt.Rows) { string formatted = ((DateTime)item["Created_At"]).ToString(); var _p = new { Purchase_ID = (int)item["Purchase_ID"], Customer_Name = item["Customer_Name"] as string, Tel = item["Tel"] as string, Total = (decimal)item["Total"], Created_At = formatted, Status = (PurchaseStatus)(item["Status"]) }; allPurchase.Add(_p); } purchaseDataGrid.ItemsSource = allPurchase; PagingPage(); //list_product.Clear(); }