mardi 3 novembre 2015

Updating table with SqliteDataAdapter

I have a bit of an issue when it comes to updating view in datagridview. My function successfully deletes selected row from database but DataAdapter does not fill datatable dt. Function with the same structure works perfectly when adding rows.

    private string ConString;

    private SQLiteCommand cmd;
    DataTable dt = new DataTable();
    SQLiteConnection sql_con;
    SQLiteDataAdapter DB;


    // Function to delete rows
    public void DeleteRow(string value)
    {
        string sqlStatement = "DELETE FROM Trades WHERE ID = " + value;
        try
        {
            sql_con = new SQLiteConnection(ConString);

            sql_con.Open();
            cmd = sql_con.CreateCommand();
            cmd.CommandText = sqlStatement;
            cmd.ExecuteNonQuery();
            DB = new SQLiteDataAdapter();
            dt.Clear();
            DB.Fill(dt);
        }
        finally
        {
            sql_con.Close();
        }
    }

Aucun commentaire:

Enregistrer un commentaire