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();
}