SQLite query not executing on C#

Question

The code doesn't produce an exception and seemingly runs fine. But after running it and checking the table i see that the row is not inserted. I use navicat for cheking and that's not the problem. I've double-checked the table name and field names which all correct. What's wrong?

try
{
    SQLiteConnection conn = new SQLiteConnection("Data Source=path;Version=3;FailIfMissing=True");

    conn.Open();
    String sql = "INSERT INTO sales (cust_id, date, cost, price) VALUES ('0', '" + String.Format("{0:u}", DateTime.Now.Date).Split(' ')[0] + "', '" + cost.ToString() + "', '12')";
    SQLiteCommand command = new SQLiteCommand(sql, conn);

    conn.Close();
}
catch (Exception err)
{
    MessageBox.Show(err.Message.ToString());
}

because its never executed?

user2140173
– user2140173

2015-02-12 09:41:10 +00:00
Commented Feb 12, 2015 at 9:41 — user2140173
– user2140173, Commented Feb 12, 2015 at 9:41

apomene · Accepted Answer · 2015-02-12 09:42:31Z

1

add:

command.ExecuteNonQuery();

on your code:

...
SQLiteCommand command = new SQLiteCommand(sql, conn);
command.ExecuteNonQuery();

Also it is always better to use parameters on your query

answered Feb 12, 2015 at 9:42

apomene

14.4k10 gold badges51 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLite query not executing on C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related