原目的:从一个老的SQLite里读出数据,存到DataTable里,然后保存到一个新的SQLite数据库中。
需要引用System.Data.SQLite.dll
try
{
SQLiteConnection Conn = new SQLiteConnection();
DataTable dt = new DataTable();
Conn.ConnectionString = <span style="font-family: Arial, Helvetica, sans-serif;">"Data Source=.\\OldData.db";</span>
Conn.Open(); //打开旧数据库
string sql = "SELECT tbl_name, sql FROM sqlite_master WHERE type='table' ORDER BY name";
SQLiteDataAdapter oldadapter = new SQLiteDataAdapter(sql, Conn);
oldadapter.Fill(dt);//获得旧数据库里所有表的名字和CREATE命令
string output = "NewData.db";
SQLiteConnection.CreateFile(output);//创建新的数据库
SQLiteConnection conn = new SQLiteConnection();
SQLi