vendredi 20 février 2015

Insert values into sqlite

i'm trying to insert some values into sqlite database in c#.all the values are label.text,but it doesn't work,i think something is going wrong:



SQLiteConnection con = new SQLiteConnection("Data Source=Data/questions.sqlite;");

SQLiteCommand cmd = new SQLiteCommand("insert into finaltest(id,true,false,white,percent) values(3,'" + label1.Text + "','" + label2.Text + "','" + label3.Text + "','" + label4.Text + "')", con);

con.Open();
cmd.ExecuteNonQuery();
con.Close();


i also tried using addwithvalue,but again it didn't work.



SQLiteConnection con = new SQLiteConnection("Data Source=Data/questions.sqlite;");

SQLiteCommand cmd = new SQLiteCommand("insert into finaltest(id,true,false,white,percent) values(3,@b,@c,@d,@e)", con);


cmd.Parameters.AddWithValue("@b", label2.Text);
cmd.Parameters.AddWithValue("@c", label3.Text);
cmd.Parameters.AddWithValue("@d", label4.Text);
cmd.Parameters.AddWithValue("@e", label5.Text);
con.Open();
cmd.ExecuteNonQuery();

con.Close();

Aucun commentaire:

Enregistrer un commentaire