vs2010里调用SQlite问题
我下载了一个SQLite Developer工具,可以建库建表,还下载了System.Data.SQLite.DLL并且在项目里添加了引用,写了几行测试代码,如下:
string liteConnection = @"Data Source = E:\小研究\AccessTest\SQLiteTest;"; string sql = "Select * From Student"; SQLiteConnection conn = new SQLiteConnection(liteConnection); DataTable dt = new DataTable(); SQLiteDataAdapter da = new SQLiteDataAdapter(sql, liteConnection); da.Fill(dt); if (dt.Rows.Count > 0) { MessageBox.Show("成功~"); }