I want to work on a sqlite3 database using SQL from C#. I have installed SQLitewrapper and I have the code below, which runs without error (but without any real action). I want help to get started, examples on how to scan through a table and eventually retrieve and manipulate values, and also how to run and display sql statements. Code examples can be in C#, VB6 or Foxpro.
TIA, your help is much appreciated!
private void button1_Click(object sender, EventArgs e)
SQLiteBase db = new SQLiteBase("d:\\projects\\sqlite\\test.db");
DataTable table = db.ExecuteQuery("SELECT * FROM fields;");
dataGridView1.DataSource = table.TableName ;