public MainPage() { this.InitializeComponent(); AdControl.ApplicationId = "9nc4zpfn97sc";//广告 AdControl.AdUnitId = "1100039452"; AdControl.ErrorOccurred += (s, e) => { Adstaus.Text = e.ErrorMessage; }; Window.Current.SetTitleBar(TitleTextBlock);//设置标题栏为TitleTextBlock BackButton.Visibility = Visibility.Collapsed; MyFrame.Navigate(typeof(IndexPage)); TitleTextBlock.Text = "4K专区"; Four_k.IsSelected = true; dbname = "MyDB.db";//数据库名 string fdlocal = ApplicationData.Current.LocalFolder.Path; string filename = dbname; string dbfullpath = Path.Combine(fdlocal, filename); ISQLitePlatform platform = new SQLitePlatformWinRT(); // 连接对象 SQLiteConnection conn = new SQLiteConnection(platform, dbfullpath); WriteLine("db pathe: " + conn.DatabasePath); // 创建表 int rn = conn.CreateTable <UserItem>(CreateFlags.None); WriteLine("create table res = {0}", rn); conn.Dispose(); }
public SQLiteConnection imDbconnection(string dbPath, string dbName) { var path = Path.Combine(dbPath, dbName); ISQLitePlatform platform = new SQLitePlatformWinRT(); return(new SQLiteConnection(platform, path)); }
public SQLiteConnection GetConnection() { const string sqliteFilename = "ScoreTracker.db3"; var path = Path.Combine(ApplicationData.Current.LocalFolder.Path, sqliteFilename); var platform = new SQLitePlatformWinRT(); return(new SQLiteConnection(platform, path)); }
public SQLiteConnection DbConnection() { var dbName = "CustomersDb.db3"; var path = Path.Combine(ApplicationData.Current.LocalFolder.Path, dbName); ISQLitePlatform platform = new SQLitePlatformWinRT(); return(new SQLiteConnection(platform, path)); }
public SQLiteConnection GetConnection() { var path = System.IO.Path.Combine(ApplicationData.Current.LocalFolder.Path, App2.App.dbName); var Platform = new SQLitePlatformWinRT(); var connection = new SQLiteConnection(Platform, path); return(connection); }
public SQLiteConnection DbConnection() { var dbName = "FDLiz.db3"; string path = Path.Combine(ApplicationData.Current.LocalFolder.Path, dbName); var platform = new SQLitePlatformWinRT(); return(new SQLiteConnection(platform, path)); }
public SQLiteConnection DbConnection() { var dbName = "EzraDatabase.db3"; string path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, dbName); var platform = new SQLitePlatformWinRT(); return(new SQLiteConnection(platform, path)); }
public SQLiteConnection GetConnection() { var filename = "Student.db"; var path = Path.Combine(ApplicationData.Current.LocalFolder.Path, filename); var platform = new SQLitePlatformWinRT(); var connection = new SQLiteConnection(platform, path); return(connection); }
public SQLiteConnection GetConnection() { //download SQLite for Universal Windows Platform from http://www.sqlite.org/download.html //add it and Visual C++ 2013 Runtime Package for Windows as references (Universal Windows > Extensions) SQLitePlatformWinRT platform = new SQLitePlatformWinRT(); string sqliteFilename = Configuration.DBname + ".db3"; string path = Path.Combine(ApplicationData.Current.LocalFolder.Path, sqliteFilename); return(new SQLiteConnection(platform, path)); }
public SQLiteConnection GetConnection() { string dbPath = ApplicationData.Current.LocalFolder.Path; var path = System.IO.Path.Combine(dbPath, GlobalDegisken.localDbName); var platform = new SQLitePlatformWinRT(); var connection = new SQLiteConnection(platform, path); return(connection); }
public void DbConnect() { string fdlocal = ApplicationData.Current.LocalFolder.Path; string filename = "Music.db"; string strConn = Path.Combine(fdlocal, filename); ISQLitePlatform platform = new SQLitePlatformWinRT(); _conn = new SQLiteConnection(platform, strConn); var dbExist = IsExistDb(filename); }
public SQLiteAsyncConnection GetConnection() { var sqliteFilename = "AAAAAAAAA.db3"; string documentsPath = Windows.Storage.ApplicationData.Current.LocalFolder.Path; var path = Path.Combine(documentsPath, sqliteFilename); var platform = new SQLitePlatformWinRT(); var param = new SQLiteConnectionString(path, false); var connection = new SQLiteAsyncConnection(() => new SQLiteConnectionWithLock(platform, param)); return(connection); }
public DataService() { var sqlitePlatform = new SQLitePlatformWinRT(); var connectionString = Path.Combine(ApplicationData.Current.LocalFolder.Path, FileName); var sqliteConnectionString = new SQLiteConnectionString(connectionString, false); baseConnection = new SQLiteConnectionWithLock(sqlitePlatform, sqliteConnectionString); connection = new SQLiteAsyncConnection(() => baseConnection); EnsureTableExists <FolderData>(); EnsureTableExists <NoteData>(); }
/// <summary> /// 获取SQL链接 /// </summary> /// <returns>SQL链接</returns> public SQLiteConnection GetSqLiteConnection() { ISQLitePlatform platform = new SQLitePlatformWinRT(); SQLiteConnection con = new SQLiteConnection(platform, DbFilePath); /* * if (connection != null) * return connection; * else return connection = new SQLiteConnection(platform, DbFilePath); */ return(con); }
//首次使用本软件,创建数据表 public bool createTables(string tablePath) { string localPath = ApplicationData.Current.LocalFolder.Path; string dbfullpath = Path.Combine(localPath, DB_NAME); ISQLitePlatform platform = new SQLitePlatformWinRT(); // 连接对象 SQLiteConnection conn = new SQLiteConnection(platform, dbfullpath); // 创建表 int rnSetting = conn.CreateTable <TaxSetting>(CreateFlags.None); int rnDetail = conn.CreateTable <TaxDetail>(CreateFlags.None); conn.Dispose(); return(rnSetting == 0 && rnDetail == 0); }
public SQLiteAsyncConnection GetConnection() { var sqliteFilename = AppSettings.SQLiteDatabaseName; var localPath = Windows.Storage.ApplicationData.Current.LocalFolder.Path; var path = Path.Combine(localPath, sqliteFilename); var platform = new SQLitePlatformWinRT(); var connectionWithLock = new SQLiteConnectionWithLock( platform, new SQLiteConnectionString(path, true)); var connection = new SQLiteAsyncConnection(() => connectionWithLock); return(connection); }
public static bool DatabaseConnect() { try { SQLitePlatformWinRT Platform = new SQLitePlatformWinRT(); string DatabasePath = Path.Combine(ApplicationData.Current.LocalFolder.Path, "Database.sqlite"); SQLConnectionLock = new SQLiteConnectionWithLock(Platform, new SQLiteConnectionString(DatabasePath, false)); SQLConnection = new SQLiteAsyncConnection(() => SQLConnectionLock); //connectionFactory.BusyTimeout = new TimeSpan(0, 0, 0, 1); Debug.WriteLine("Successfully connected to the database."); return(true); } catch { Debug.WriteLine("Failed to connect to the database."); return(false); } }
public async Task <ConnectionInfo <SQLiteAsyncConnection> > GetConnection() { ConnectionInfo <SQLiteAsyncConnection> connectionInfo = new ConnectionInfo <SQLiteAsyncConnection>(); connectionInfo.IsInitializedDbStructure = true; var sqliteFilename = XamarinSocialApp.UI.Common.Implementations.Constants.Constants.Configuration.csLocalDbFileName; string path = Path.Combine(ApplicationData.Current.LocalFolder.Path, sqliteFilename); if (!await FileExists(path)) { connectionInfo.IsInitializedDbStructure = false; } var plat = new SQLitePlatformWinRT(); var connectionFactory = new Func <SQLiteConnectionWithLock>(() => new SQLiteConnectionWithLock(plat, new SQLiteConnectionString(path, storeDateTimeAsTicks: false))); var asyncConnection = new SQLiteAsyncConnection(connectionFactory); connectionInfo.Connection = asyncConnection; return(connectionInfo); }