I am trying to automated the testing of a reporting website. I need to verify that the content of a datagridview is as expected for the reports. The datagridview will display column names and datarow results returned from an SQL database.
I am thinking that the meat of the application which is stable is behind a WCF facade, so I should really be trying to automate the verification of the dataset/datatable at this level. I have a proxy I can use at this level to send in dates and report identifier which will return a datatable.
The UI is less important to automate the testing of right now, as it is currently a quick prototype and will be changed in the near future.
I have experience with using a few automated testing tools such as NUnit, FIT, WatiN etc.
Are there any suggested best pratices for automating the testing of this scenario?