public void WordBookLoader() { DatabaseConnector.Alphabet_Surf_db_DataReader_wordbook(); this.wordbook_grid.ItemsSource = DatabaseConnector.WordBook; this.SearchedDataGrid = CollectionViewSource.GetDefaultView(DatabaseConnector.WordBook); }
public static void Alphabet_Surf_db_Initializar() { SQLiteConnection.CreateFile("Alphabet_Surf_DB.sqlite"); DatabaseConnector.DatabaseConnectorHandler().alphabet_Surf_db_connector.Open(); SQLiteCommand command_alphabet_picture = new SQLiteCommand("create table alphabet_picture (alphabet varchar(5), upperOrLower varchar(10), pic_path_1 varchar(100), pic_path_2 varchar(1000), description varchar(2000))", DatabaseConnector.DatabaseConnectorHandler().alphabet_Surf_db_connector); command_alphabet_picture.ExecuteNonQuery(); SQLiteCommand command_wordbook = new SQLiteCommand("create table wordbook (word varchar(5), short_description varchar(2000), long_description varchar(4000))", DatabaseConnector.DatabaseConnectorHandler().alphabet_Surf_db_connector); command_wordbook.ExecuteNonQuery(); DatabaseConnector.DatabaseConnectorHandler().alphabet_Surf_db_connector.Close(); }