Windows UWP C# SQLite with Microsoft's version
// T i t l e G e t
public static List*ZTITLE* GetTitles(String catname)
{
List*ZTITLE* entries = new List*ZTITLE*();
string dbpath = Path.Combine(ApplicationData.Current.LocalFolder.Path, "FlutterMovieDb.sqlite");
using (SqliteConnection db = new SqliteConnection("Filename = " + dbpath))
{
db.Open();
SqliteCommand selectCommand = new SqliteCommand
("SELECT * from ZTITLE WHERE ZCATNAME ='" + catname + "' ORDER BY ZNAME", db);
SqliteDataReader query = selectCommand.ExecuteReader();
while (query.Read())
{
ZTITLE atitle = new ZTITLE();
atitle.Z_PK = query.GetInt32(0); //? Z_PK INTEGER, likely 64
atitle.ZID = query.GetInt32(1);
atitle.ZCATNAME = query.GetString(2);
atitle.ZPRODUCTION = query.GetString(3);
atitle.ZLEADARTISTS = query.GetString(4);
atitle.ZPOSTER = query.GetString(5);
atitle.ZNAME = query.GetString(6);
atitle.ZRATING = query.GetString(7);
atitle.ZUPDATE = query.GetString(8);
atitle.ZYEAR = query.GetString(9);
atitle.ZPLOT = query.GetString(10);
atitle.ZIMAGE = query.GetFieldValue byte[] (11);
entries.Add(atitle);
}
db.Close();
}
return entries;
}
// Notes: June 2020, Microsoft Update, may break some Apps
the default Pictures Folder, when assigned by an UWP app
StorageFolder appDataRootFolder = KnownFolders.PicturesLibrary;
return ONE-DRIVE path, if you are connected, only problem, used all your free spaces
if NOT Connected, may crash your App.
// =========================================
https://1drv.ms/u/s!ApN1U-GH6AeIn16-T...
Disclaimer:
Image and Text were used for educational purposes.
On this page of the site you can watch the video online Windows UWP C# SQLite with Microsoft's version with a duration of hours minute second in good quality, which was uploaded by the user Lawrence Tsang 02 July 2020, share the link with friends and acquaintances, this video has already been watched 62 times on youtube and it was liked by 0 viewers. Enjoy your viewing!
