spivonious said:turrican said:*snip*
If you can get two tables out of it, then you can add those tables to a dataset. But I agree with vesuvius. Modify the SQL to get what you're really after. Doing two select *s is horribly inefficient.
Also, there's no point to a Dataset unless the tables are related in some way, or you want to pass them around as one object.
For more on MVVM, check out Josh Smith's blog: http://joshsmithonwpf.wordpress.com/ Personally, I think the pattern is overkill since you end up duplicating your model in the viewmodel, but it definitely makes unit testing easier.
The biggest change (IMO) is moving from Click event handlers to Commands. It lets you ignore the details of the UI, like enabling/disabling all of the ways to save if there aren't any changes, and just focus on the action.
"...moving from Click event handlers to Commands..."
Yes, that is REALLY hard for me to understand right now. Trying to find good resource on it to learn more. It's a big shift for me but a necessity to learn it I guess.