spieleprogrammierer.de - Forum und Wiki zur Spieleprogrammierung und Spieleentwicklung

C#-Quelltext

 baseDir = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\skype\\" + tb_dirName.Text + "\\main.db";
            MessageBox.Show(baseDir);

            // Change sql query and table name

            string sql = "Select author,timestamp,body_xml from Messages";
            SqlConnection cnn = new SqlConnection(baseDir);
            cnn.Open();
            SqlCommand cmd = new SqlCommand(sql, cnn);
            SqlDataReader Reader = cmd.ExecuteReader();

            lw_messages.Items.Clear();

            while (Reader.Read())
            {

                ListViewItem lv = new ListViewItem(Reader.GetInt32(0).ToString());
                lv.SubItems.Add(Reader.GetString(1));
                lv.SubItems.Add(Reader.GetString(2));
                lw_messages.Items.Add(lv);


            }

            Reader.Close();
            cnn.Close();
        }

C#-Quelltext

baseDir = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\skype\\" + tb_dirName.Text + "\\main.db";

            SQLiteConnection connection = new SQLiteConnection();

            connection.ConnectionString = "Data Source=" + baseDir;
            connection.Open();

            SQLiteCommand command = new SQLiteCommand(connection);

            command = new SQLiteCommand(connection);

            // Auslesen des zuletzt eingefügten Datensatzes.
            command.CommandText = "SELECT author, timestamp, body_xml FROM Messages";

            SQLiteDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                Console.WriteLine("Dies ist der {0}. eingefügte Datensatz mit dem Wert: \"{1}\"", reader[0].ToString(), reader[1].ToString());
            }

            // Beenden des Readers und Freigabe aller Ressourcen.
            reader.Close();
            reader.Dispose();

            command.Dispose();

            connection.Close();
            connection.Dispose();