BoldDeskWe are launching BoldDesk on Product Hunt soon.
Learn more & follow us.
I need to populate the grid with the data in the database. Since the grid is bound to a item source I am unable to perform a proper retrieval.
Following is the code that I Tried:
"mat.cs" is the file which is bound to the grid.
var dbpath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "Test2.db");
using (var db = new SQLite.SQLiteConnection(dbpath))
foreach (ExpandoObject ep in (this.DataContext as mat).DynamicOrder)
//db = new SQLite.SQLiteConnection(dbpath);
dynamic epObj = ep;
var line = string.Empty;
line = epObj.Name;
Material conobj = new Material();
conobj.Name = epObj.Name;
conobj.Type = epObj.Type;
conobj.Quantity = epObj.Quantity;
List<Material> lstMats = db.Table<Material>().ToList();
//var bline = new MessageDialog("Data Inserted");
you for using Syncfusion Products.
We have created a sample to achieve your requirement to retrieve data from
database and setting this data to the ItemSource of grid.
can find the sample under the following location:
let us know if this solution helps you.