Datagrid Items Manipulation
I have a datagrid that displays certain columns of its underlying dataset and it is filled using Merge method at some point in my application. I want to automate data entry process in the datagrid by: 1)Setting the focus to the first editable cell (starting from first row and continuing row-wise) and change its back ground color 2)Waiting for user's response. If the entered value is valid, advance to next cell automatically, else prompt the user with appropriate message and do not advance until a valid data is entered.
I have not been able to control setting the focus to the right cell. Any help will greatly be appreciated.