use view as datasource for GridForm - DataForm.NET Samples

This example shows how GridForm uses View as datasource and uses DataForm to display detail. The one of differences between View and Table is that Table has one or more primary key fields which is/are used to locate a row in the database. However, View has none. So if you want to display a single row in the View by GridForm and DataForm, you have to specify one or more fields as primary key in both DataForm and GridForm. So GridForm can pass "Primary Key" value(s) to DataForm so that DataForm displays that single row.

Pick a Theme:

Invoices 
OrderID AscendingOrder DateCustomer IDCountry 
102497/5/1996TOMSPGermany
102507/8/1996HANARBrazil
102507/8/1996HANARBrazil
102517/8/1996VICTEFrance
102517/8/1996VICTEFrance
102527/9/1996SUPRDBelgium
102527/9/1996SUPRDBelgium
102527/9/1996SUPRDBelgium
102537/10/1996HANARBrazil
102537/10/1996HANARBrazil
1 - 10 / 2143 RecordsPage / 215 

  Design   Source  
  1. Open DataForm.NET Manager. In DataForm.NET List page, choose Invoices by clicking the link.
  2. Click OrderID link to open up DataForm Field Designer window. In DataForm Field Designer, check Primary Key checkbox.
  3. In the DataForm.NET Designer on the right hand side, switch to GridForm tab.
  4. Add a to GridForm and Specify Invoices for DataForm for Edit.
  5. Click OrderID hyperlink to open up a GridForm Field Designer window. In the opening window, double check if Primary Key checkbox is checked.
  • Click HERE to open up a READ ONLY DataForm.NET Manager.
  • Click HERE to try for yourself.
Send feedback to EasyDotNet
© 2002-2007 EasyDotNet Corporation. All rights reserved.