첨부 실행 코드는 나눔고딕코딩 폰트를 사용합니다.
본 블로그는 광고를 포함하고 있습니다.
광고 클릭에서 발생하는 수익금은 모두 블로그 콘텐츠 향상을 위해 쓰여집니다.

728x90
반응형
728x170
using System;
using System.Data.SQLite;

string connectionString = "URI=file:c:\\test.db";

using(SQLiteConnection sqliteConnection = new SQLiteConnection(connectionString))
{
    sqliteConnection.Open();

    using(SQLiteCommand sqliteCommand = new SQLiteCommand(sqliteConnection))
    {
        sqliteCommand.CommandText = "INSERT INTO Cars VALUES(1,'Audi',52642)";

        sqliteCommand.ExecuteNonQuery();

        sqliteCommand.CommandText = "INSERT INTO Cars VALUES(2,'Mercedes',57127)";

        sqliteCommand.ExecuteNonQuery();

        sqliteCommand.CommandText = "INSERT INTO Cars VALUES(3,'Skoda',9000)";

        sqliteCommand.ExecuteNonQuery();

        sqliteCommand.CommandText = "INSERT INTO Cars VALUES(4,'Volvo',29000)";

        sqliteCommand.ExecuteNonQuery();

        sqliteCommand.CommandText = "INSERT INTO Cars VALUES(5,'Bentley',350000)";

        sqliteCommand.ExecuteNonQuery();

        sqliteCommand.CommandText = "INSERT INTO Cars VALUES(6,'Citroen',21000)";

        sqliteCommand.ExecuteNonQuery();

        sqliteCommand.CommandText = "INSERT INTO Cars VALUES(7,'Hummer',41400)";

        sqliteCommand.ExecuteNonQuery();

        sqliteCommand.CommandText = "INSERT INTO Cars VALUES(8,'Volkswagen',21600)";

        sqliteCommand.ExecuteNonQuery();
    }

    sqliteConnection.Close();
}
728x90
반응형
그리드형
Posted by 사용자 icodebroker

댓글을 달아 주세요