Ok, here's a bit of an odd situation. I have a datagridview which contains all sorts of information relating to investment bonds. When a bond is intiially created, I populate a table with the bond ID and the dates on which it'll pay interest. so far so good.
In my datagridview, I want the user to be able to correct errors made when the bond was first input. If they change the interest payment frequency or maturity date, I want to fire two stored procs. one which deletes the entries for the interest payment dates and the other to recreate these entries with the correct data. both these stored procedures work just fine.
The problem is a) how do i detect that a specified field in the datagridview has changed and b) how do I retrieve the new value the user has entered into the datagridview. (I'll need to pass the new values into my stored procs as input parameters)