level 14
772807886
楼主
SQLiteConnection conn = new SQLiteConnection("Data Source=" + App.启动目录 + "\\PlayList.db");
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(conn);
Console.WriteLine(conn.State);
cmd.CommandText = "insert into PlayList (Title,Singer,Album,Path,Length) values(*" + tit + "*,*" + sin + "*,*" + alb + "*,*" + fn + "*,*" + tim + "*)";
Console.WriteLine(cmd.CommandText);
Console.WriteLine(cmd.ExecuteNonQuery());
那三个Console.WriteLine分别输出:
Open
insert into PlayList (Title,Singer,Album,Path,Length) values(*1*,*Babyface*,*Grown & Sexy*,*E:\1.mp3*,*04:29*)
1
2014年08月22日 07点08分
1
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(conn);
Console.WriteLine(conn.State);
cmd.CommandText = "insert into PlayList (Title,Singer,Album,Path,Length) values(*" + tit + "*,*" + sin + "*,*" + alb + "*,*" + fn + "*,*" + tim + "*)";
Console.WriteLine(cmd.CommandText);
Console.WriteLine(cmd.ExecuteNonQuery());
那三个Console.WriteLine分别输出:
Open
insert into PlayList (Title,Singer,Album,Path,Length) values(*1*,*Babyface*,*Grown & Sexy*,*E:\1.mp3*,*04:29*)
1