public void LoadList() { this.LvStudent.Items.Clear(); // [snip] - As C# is purely object-oriented the following lines must be put into a class: // We use these three SQLite objects: SQLiteConnection sqlite_conn; SQLiteCommand sqlite_cmd; SQLiteDataReader sqlite_datareader; // create a new database connection: sqlite_conn = new SQLiteConnection(ConnectSQLite.GetConnect()); try { // open the connection: sqlite_conn.Open(); // create a new SQL command: sqlite_cmd = sqlite_conn.CreateCommand(); sqlite_cmd.CommandText = "SELECT student_id, name FROM Student"; // Now the SQLiteCommand object can give us a DataReader-Object: sqlite_datareader = sqlite_cmd.ExecuteReader(); int id; ListViewItem lvi = null; string[] colText = new string[3]; // The SQLiteDataReader allows us to run through the result lines: while (sqlite_datareader.Read()) // Read() returns true if there is still a result line to read { colText[0] = sqlite_datareader.GetString(0); id = Int32.Parse(colText[0]); colText[1] = sqlite_datareader.GetString(1); lvi = new ListViewItem(colText, 0, Color.Black, Color.White, this.Font); lvi.Tag = id; LvStudent.Items.Add(lvi); } } catch (SQLiteException ex) { MessageBox.Show(this, ex.Message, "Error"); this.Text = ex.Message; } finally { // We are ready, now lets cleanup and close our connection: sqlite_conn.Close(); } }
private void button1_Click(object sender, EventArgs e) { if (txtName.TextLength <= 2) { MessageBox.Show("Invalid Name"); return; } // [snip] - As C# is purely object-oriented the following lines must be put into a class: // We use these three SQLite objects: SQLiteConnection sqlite_conn; SQLiteCommand sqlite_cmd; // create a new database connection: sqlite_conn = new SQLiteConnection(ConnectSQLite.GetConnect()); try { // open the connection: sqlite_conn.Open(); // create a new SQL command: sqlite_cmd = sqlite_conn.CreateCommand(); string text; text = "INSERT INTO Student(name) VALUES('"; text += txtName.Text + "');"; sqlite_cmd = sqlite_conn.CreateCommand(); sqlite_cmd.CommandText = text; sqlite_cmd.ExecuteNonQuery(); } catch (SQLiteException ex) { MessageBox.Show(this, ex.Message, "Error"); this.Text = ex.Message; } finally { // We are ready, now lets cleanup and close our connection: sqlite_conn.Close(); } this.Close(); }