cannot update with parameter
Posted: Mon 14 Mar 2011 13:30
I use dotConnect for SQLite 3.10.121.0 in vs2010.
when I use this code to update some value, it's return 0
but when I direct use sql to update value, it's return 1
why this? help
when I use this code to update some value, it's return 0
Code: Select all
SQLiteConnection sc = new SQLiteConnection(dataConnStr);
var cmd = sc.CreateCommand();
cmd.CommandText = "UPDATE test SET p2 = @value WHERE p1 = @name";
cmd.Parameters.AddWithValue("@name", "10");
cmd.Parameters.AddWithValue("@value", "List~~~");
sc.Open();
Console.WriteLine(cmd.ExecuteNonQuery());
Code: Select all
SQLiteConnection sc = new SQLiteConnection(dataConnStr);
var cmd = sc.CreateCommand();
cmd.CommandText = "UPDATE test SET p2 = 'List~~~' WHERE p1 = '10'";
sc.Open();
Console.WriteLine(cmd.ExecuteNonQuery());