As stated before this sample application is to be used as the basis to analyze Fantasy Football players for my Fantasy Footbal team. The first sample will show reports for Quarterback only. As the application progresses, I will add features for different statistics for the different positions.
Simple Architecture diagram of application
The Crystal .NET reports will display the data sliced and diced in the way I want. The reports will be the view into most of the data, rather than using an ASP.NET form to view the data.
There is also an administrative portion of the applicaiton that will allow the user to add players, teams, statistics and positions. This could eventually be extended to include other fantasy sports, except for Fantasy NASCAR ;-).
Eventually the data entry should be automated using screen scraping or RSS feeds from yahoo sports.
This application also utilizes some of the new data access controls included with VS 2005. I utilize mainly the SQLDataSource control for access on the pages. This gives a nice drag and drop utility, and it's like using a Data Access Layer. While I don't have it persisting across the different pages and user controls, the concept is the same for each administrative page. For those pages, it's very simple to set it up to do most of the CRUD functions using this control.