Master/Detail

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Master/Detail
Saturday, November 13, 2010PrintSubscribe
Order Form Sample

In this tutorial we will detail the process of creating a custom Order Form with Code On Time generator and Web Site Factory project. We will customize the sample application generated straight from the Northwind database.

Customization includes creating a new page, adding data views to the page, configuring data controllers to calculate the extended priced of order detail records, the subtotal and total amounts of the order, and freight charges. We will also apply a custom template to alter the presentation of the form.

The screen shot below represents the final product of project customization.

image

Here is the same form rendered in “read-only” mode.

image

 Download this tutorial now! (6172K)

Watch the tutorial on our YouTube channel:

Part 1: http://www.youtube.com/watch?v=ekb8_S7YaRM

Part 2: http://www.youtube.com/watch?v=syGsUTuK2ZE

Part 3: http://www.youtube.com/watch?v=zImXeWos1U0

Friday, July 9, 2010PrintSubscribe
Accessing Filters in Business Rules

Q. Where can I get hold of the filter string that was built when the user applied a set of filters in the grid1 view?  If I can grab that then I can pass it to a SQL query to supply a list of multiple Customers for whom I want to pick up all the orders.

A.

The following screenshot shows the application with the selected master Suppliers record and filtered detail Products records.  This is the same application that was discussed at /blog/2010/06/refreshing-master-when-detail-changed.html

The user has just edited a detail Products record and pressed the Save button.

image

The following screenshot shows a breakpoint that was set in the project. The breakpoint is activated when user saves the record.

image

If you inspect Arguments property of the business rules class in Watch window of Visual Studio or Visual Web Developer then you can clearly see that a wealth of information about the context of the requested action is available to you, including the current filter that was applied by the application user.

Property Arguments.ExternalFilter provides access to the selected master Suppliers record.

Property Arguments.Filter provides access to the user-defined filter.

Property Arguments.SelectedValues providers access to the primary keys of selected detail Products records presented in the page.

You also have access to the SortExpression and physical values that were submitted from the client browser when Update action has been requested.

image

Wednesday, June 2, 2010PrintSubscribe
Three Level Master-Detail

Learn to create multi-level master-detail pages in ASP.NET+AJAX web applications created with Code OnTime Generator and Web Site Factory. In this example we will create a 3-level master-detail page layout that links customers, orders, and order details.

Three Level Master-Detail in ASP.NET/AJAX Web Applications

Watch this video tutorial on our Youtube channel at http://www.youtube.com/watch?v=9b3TKM0nFAM