Inserting into a link table when inserting using a grid
-
I have this application from several years ago that I am modifying. I created a new form where I have an Xceed grid tied to a DataSet-DataAdapter. When the Add button (or a blank area on the grid) is clicked, it creates a new row. The user types information there and clicks "Save". Or the user edits an existing row and clicks "Save". The data adapter calls the Update() method that invokes the corresponding SQL Insert/Update/Delete commands. It works fine. But I have a link table where I want to Insert when a new row is saved in the previous table mentioned above. How do I know a new row has been created and "Save" button is clicked or an existing row is edited and the "Save" button is clicked? I need some help please. Thanks.
-
I have this application from several years ago that I am modifying. I created a new form where I have an Xceed grid tied to a DataSet-DataAdapter. When the Add button (or a blank area on the grid) is clicked, it creates a new row. The user types information there and clicks "Save". Or the user edits an existing row and clicks "Save". The data adapter calls the Update() method that invokes the corresponding SQL Insert/Update/Delete commands. It works fine. But I have a link table where I want to Insert when a new row is saved in the previous table mentioned above. How do I know a new row has been created and "Save" button is clicked or an existing row is edited and the "Save" button is clicked? I need some help please. Thanks.