Insert/Delete in Datagrid

I have a form with a datagrid, which is sourced from a dataset. I would like to add buttons to this for to Insert, Delete and Undo (if possible). I am not sure how to do this using datagrids/dataset functionality. Can someone give me pointers on how this may be done. I do have the update scripts written and they work fine, just wanting to add additional functionality to the form.

Thanks in advance



Answer this question

Insert/Delete in Datagrid

  • joy2007

    Insert is available for detailsView not datagrid.

    AutogenerateDeleteButton = True
    AutogenerateUpdateButton = True

    You'll also have to code a query for each and add the parameters.

    Adamus



  • Blue_Cali

    Ok. This is all new to me, but now I am really confused. I have until this point had on my forms datagrids to manipulate my data (view, update, insert, delete). I have not used dataviews for anything. The code I have now is fine, but I want the ability to create or delete a row at the click of a button if needed. The default method now (adding a row to the bottom for inserting or pressing the Delete button on the keyboard for deleting) works ok, but not very intuitive. So I want to create a button for each function so the user can simply click on the button to do so.

    If I am using the wrong method (datagrid) to do this, the I will change it, but I would rather not.

    Please advise.


  • forumscontractor

    Forgot to mention. I am using VS 2003
  • Insert/Delete in Datagrid