VsDvJA7f

1connection = new SQLiteConnection("Data Source=" + sz +";Version=3");
2command = new SQLiteCommand(connection);
3
4connection.Open();
5
6command.CommandText =
7   "CREATE TABLE if not exists miscInfo(key   TEXT, " +
8   "value TEXT, UNIQUE (key));";
9command.ExecuteNonQuery();
10	
11command.CommandText = 
12   "INSERT INTO discData(rootfolderID, time, volumeName, discLabel, " + 
13   "userTitle, userDesc) "+
14   "VALUES(@rootfolderID, @time, @volumeName, @discLabel, " + 
15   "@userTitle, @userDesc); " +
16   "SELECT last_insert_rowid() AS RecordID;";
17
18command.Parameters.Add("@rootfolderID", DbType.Int64).Value = d.rootfolderID;
19command.Parameters.Add("@time", DbType.Int64).Value = d.time;
20command.Parameters.Add("@volumeName", DbType.String).Value = d.volumeName;
21command.Parameters.Add("@discLabel", DbType.String).Value = d.discLabel;
22command.Parameters.Add("@userTitle", DbType.String).Value = d.userTitle;
23command.Parameters.Add("@userDesc", DbType.String).Value = d.userDesc;
24
25d.discID = (long)command.ExecuteScalar();
26	
27command.CommandText = 
28   "INSERT INTO discData(rootfolderID, time, volumeName, discLabel, " + 
29   "userTitle, userDesc) "+
30   "VALUES(?, ?, ?, ?, ?, ?);" +
31   "SELECT last_insert_rowid() AS RecordID;";
32
33command.Parameters.Add("@rootfolderID", DbType.Int64).Value = d.rootfolderID;
34command.Parameters.Add("@time", DbType.Int64).Value = d.time;
35command.Parameters.Add("@volumeName", DbType.String).Value = d.volumeName;
36command.Parameters.Add("@discLabel", DbType.String).Value = d.discLabel;
37command.Parameters.Add("@userTitle", DbType.String).Value = d.userTitle;
38command.Parameters.Add("@userDesc", DbType.String).Value = d.userDesc;
39
40d.discID = (long)command.ExecuteScalar();