Why doesn't my SQLite database table update? (datatable update)

Question

I have a c# application with an SQLite database. It has a table called "Results_to_Risks" which I am trying to update. I first remove some rows in my local datatable, after which I use my update table function to update the table in the database.

foreach(var row in temp)
{
    allResToRisks.Rows.Remove(row);
}

_databaseController.UpdateTable(allResToRisks, "Results_to_Risks");

My database controller update table method:

// Updates an entire database table.
    public void UpdateTable(DataTable datatable, string table, string condition = "")
    {
        using (SQLiteConnection dbConnection = new SQLiteConnection(conString))
        {
            using (var sqliteAdapter = new SQLiteDataAdapter("SELECT * FROM '" + @table + "'" + @condition, dbConnection))
            {
                dbConnection.Open();
                using(var builder = new SQLiteCommandBuilder(sqliteAdapter))
                {
                    sqliteAdapter.Update(datatable);
                }
            }
        }
    }

In this particular case, I remove just one row. The datatable ends up empty (Rows.Count == 0), because this was the only row in that datatable. So nothing goes wrong there. However my table in the database still has the one row inside it.

What am I doing wrong?

I saw this on the MDSN website:

It is important to understand the difference between deleting a row in a DataTable and removing the row. When you call the Remove or RemoveAt method, the row is removed immediately. Any corresponding rows in the back end data source will not be affected if you then pass the DataTable or DataSet to a DataAdapter and call Update. When you use the Delete method, the row remains in the DataTable and is marked for deletion. If you then pass the DataTable or DataSet to a DataAdapter and call Update, the corresponding row in the back end data source is deleted.

So i tried to use Delete() instead of Remove(). However, this made no difference.

Have you looked at http://stackoverflow.com/questions/29483704/sqldataadapter-update-not-updating-database ? Looks similar — Jakub Wisniewski, Dec 16 '16 at 09:35
@JakubWisniewski yea I have seen it, but it does not provide any information I can apply. — Marthe Veldhuis, Dec 16 '16 at 09:40
Check if you are updating database in your solution folder or the one in bin\debug. This looks like you're working with a copy of fatabase — Nino, Dec 16 '16 at 09:42
@Nino It has worked before with just adding new values to the table. So the connection is not the issue. — Marthe Veldhuis, Dec 16 '16 at 09:45
@Nino My database has always been inside my bin\debug file. Is this bad? — Marthe Veldhuis, Dec 16 '16 at 10:16
it's not bad. If insert is working, then problem is not with database file location. — Nino, Dec 16 '16 at 10:24

Why doesn't my SQLite database table update? (datatable update)

0 Answers0