Results 1 to 10 of 10

Thread: [RESOLVED] Can't save from datagridview to database

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Oct 2013
    Posts
    200

    Resolved [RESOLVED] Can't save from datagridview to database

    Hello, I have a database and after I delete a row I cannot update database, I'm getting error: (edit: please ignore this)

    update requires a valid updatecommand when passed datarow collection with deleted rows
    ... indicating line: sqliteDataAdapter.Update(dataTable);
    Here's my code:

    VB.NET Code:
    1. private void SaveChanges(bool keepControlsDisabled)
    2. {
    3.     disableControls();
    4.  
    5.     Validate();
    6.     programs_dgv.CommitEdit(DataGridViewDataErrorContexts.Commit);
    7.     programs_dgv.EndEdit();
    8.  
    9.     programs_dgv.DataSource = null;
    10.     programs_dgv.DataSource = bindingSource;
    11.     programs_dgv.Update();
    12.  
    13.     sqliteDataAdapter = new SQLiteDataAdapter();
    14.     sqliteDataAdapter.Update(dataTable);
    15.     dataTable.AcceptChanges();
    16.  
    17.     if (keepControlsDisabled == false)
    18.     {
    19.         enableControls();
    20.     }
    21. }

    Here's the delete code:

    VB.NET Code:
    1. private void contextMenuStrip_tsmi_Click(object sender, EventArgs e)
    2. {
    3.     Int32 rowToDelete = programs_dgv.Rows.GetFirstRow(DataGridViewElementStates.Selected);
    4.     programs_dgv.Rows.RemoveAt(programs_dgv.CurrentCell.RowIndex);
    5.     programs_dgv.ClearSelection();
    6. }

    Is there a universal save function to pass records from datagridview to database?

    EDIT: Am on the right way? Do I have to deal with database and display results on datagridview? Or firstly datagridview must be handled? I'm so confused with that. Which one is right for performance?
    Last edited by nikel; Aug 24th, 2017 at 02:00 AM. Reason: I edited post

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width