Parent/Child Web Page Template
 
Template web page for displaying parent/child table records.
Features of this web page:
  • Combination parent/child web form. Records selected from drop-down list box.
  • Can be used as a template for other tables, forms. Usage specific code is identified with 'USE Specific' tags.
  • Built on SQL Server Northwind database using Customer and Orders tables.
  • Parent and child records may be added, edited, deleted.
  • For child, multiple records may be added, edited together (in the datagrid).
  • For child, multiple records may be deleted together (from the datagrid)..
  • Mix of stored procedures and SQL queries.
  • Server controls, Datagrid (databound)
  • Insert, delete rows from datagrid
  • ViewState, Session, StringBuilder
  • n-tier construction
  • Customized validation, validation summary (required because of datagrid)
  • Checks for 'dirty' input data before updating

ianlane@ianlane.com
June 6th 2002 12:02pm