I'm working on an WPF application. It has a couple of TextBox fields and an DataGrid. To create the SQLite database (with only one table) I have have done this...
SQLiteCommand command = new SQLiteCommand(connection);
command.CommandText = "CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,name VARCHAR(100)...
And so on... Now The query to create view is:
command.CommandText = "CREATE VIEW IF NOT EXISTS users_details AS SELECT name,adress...
And so on again. This works flawless, but... I'm stuck on one problem. I want to connect that view "user_details" with my DataGrid. Any guidance or part of solution would be appreciated...
Aucun commentaire:
Enregistrer un commentaire