update database questions with datagrid

[cpopham]

I have a small datagrid which my users will change data in (delete, add, or modify). I am going to update an Access database using a parameterized query. I have used parameterized queries before for updating, deleting and modifying Access tables. However, I have not used datagrids very many times and have not used them to update a database. Here is my question(s):

1)How do I check to see if a row in a datgrid has been added, deleted or modified and what was done to the row?

2)How do I use this information and the parameterized query to update the database? Ex if I have three modified rows, how do I use the Append query to update these three modified rows?

 

Thanks, Chester

[donnacha]

Can you use load the query data into a dataset and just bind the datagrid to the dataset and then this will lookafter updating your database for you.