求助,VS2015怎么连接SQLite数据库,大神来吧

发布网友 发布时间：2022-04-08 11:25

我来回答

共1个回答

热心网友 时间：2022-04-08 12:54

 找到C#下SQLite操作驱动dll并下载：System.Data.SQLite

在项目中添加dll的引用

创建数据库（文件）：

SQLiteConnection.CreateFile("MyDatabase.sqlite");

连接数据库：

SQLiteConnection m_dbConnection=new SQLiteConnection("Data Source=MyDatabase.sqlite;Version=3;");
           

m_dbConnection.Open();

插入数据：

String sql = "insert into highscores (name, score) values ('Me', 3000)";

       SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);

       command.ExecuteNonQuery();

       sql = "insert into highscores (name, score) values ('Myself', 6000)";             

       command = new SQLiteCommand(sql, m_dbConnection);           

       command.ExecuteNonQuery();   

       sql = "insert into highscores (name, score) values ('And I', 9001)";

       command = new SQLiteCommand(sql, m_dbConnection);    

       command.ExecuteNonQuery();

查询：

string sql = "select * from highscores order by score desc";
      

SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
  

SQLiteDataReader reader = command.ExecuteReader();
           

while (reader.Read())
              

    Console.WriteLine("Name: " + reader["name"] + "\tScore: " + reader["score"]);
Console.ReadLine();