It may be beneficial to grab a copy of Microsoft's Northwind or Adventureworks databases (SQL Server) and play around with them. They are full of dummy data that would allow you to do dozens of different database scenarios. Try to create forms that mine the data showing purchases (order summaries) by customer in the last 6 months, allow for the further mining of the data by clicking on the order number to see the actual products purchased. Try creating invoices, etc (think of other business type information that businesses use on a regular basis) with the data Microsoft provides in the databases. This will show you more of the typical database scenarios.
On Jul 8, 12:58 pm, Lothar Behrens <[email protected]> wrote: > Hi, > > I have read the book about programming Visual Studio 2008 (C#) and > followed the sample for an address book database. > The book (ISBN: 978-3-86645-207-7) does also discuss sub forms (as a > table), but not any more. > > What other 'typical' database scenarios are documented using Visual > Studio? > > Some samples would be > > lookup tables, > table showing content of a join of two or more tables > a form (not table) showing content of a join of two or more tables > > Any help? > > I need patterns for typical problems (and how they implemented in > Visual Studio C#), or a place where those use cases are documented. > > Thanks > > Lothar
