Hi everbody,
I am using Sqlite database in my windows store application. I have configure it and succeeded in inserting, reading, updating and deleting record from specific data. But the problem I am facing is I want to get sorted data in ascending order with respect
to column.
Below is the code I used to get complete table data
using (var db = new SQLite.SQLiteConnection(DatabasePath))
{
var found = db.Table<myTable>();
foreach (myTable records in found)
{
myTableDataList.Add(data);
}
}
This above code is working fine for getting data of whole table but I want sorted. Can anyone please suggest me that what would be added in this code to get sorted data from table or else I have to create logic for sorting data after getting in List by my
own.
Thanks
Mudassir