I am using VB.Net and ADO.Net to create a database application. I need help to create an alternate method to edit or add data rows on a datagrid that was filled from a dataset. I don’t want the users to edit the datagrid directly. I basically want an 'edit form' to appear when the user double clicks on a row. This form must automatically be filled with the values from the datagrid row that was clicked. This form must allow the user to edit the row values and when done the user will click on a save button on the form which must then close the form and then update the datagrid with the changes. Similarly I need an add button on the datagrid’s form that will open a blank 'edit form' and allow the user to input a new row that will update the datagrid.
Any suggests would be appreciated.