| private DateTime? displayDate; public DateTime? DisplayDate { get { return displayDate; } set { displayDate = value; } } |
| public int ID { get; set; } public string Name { get; set; } public DateTime? SomeDate { get; set; } ViewModel = new ViewModel(); dataForm.DataObject = ViewModel.OrderItemCollection[0]; public class ViewModel { SQLiteConnection database; ObservableCollection<OrderItem> orderItemCollection; ObservableCollection<OrderItem> OrderList; public ObservableCollection<OrderItem> OrderItemCollection { get { if (orderItemCollection == null) { GetItems(); orderItemCollection = OrderList; } return orderItemCollection; } } public ViewModel() { database = DependencyService.Get<ISQLite>().GetConnection(); // Create the table database.CreateTable<OrderItem>(); database.Query<OrderItem>("INSERT INTO OrderItem (ID,Name,SomeDate)values (1002,'Blake',null)"); database.Query<OrderItem>("INSERT INTO OrderItem (ID,Name,SomeDate)values (1003,'Catherine',null)"); database.Query<OrderItem>("INSERT INTO OrderItem (ID,Name,SomeDate)values (1004,'Jude',null)"); } public async void GetItems() { // Changing the database table items as ObservableCollection var table = (from i in database.Table<OrderItem>() select i); OrderList = new ObservableCollection<OrderItem>(); foreach (var order in table) { OrderList.Add(new OrderItem() { ID = order.ID, Name = order.Name }); } await Task.Delay(2000); } } |