Web 2.0

Labels
AJAX(112) App Studio(9) 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(178) 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(184) 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(3) 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
Web 2.0
Monday, March 8, 2010PrintSubscribe
Many-To-Many Fields, Code Defaults, Code Filters

The latest release of the Web Site Factory and Data Aquarium premium projects support many-to-many fields, code defaults, and code filters.

Many-To-Many Fields

Learn to define many-to-many fields in ASP.NET AJAX applications without writing a single line of code with Code OnTime Generator. We will show you how to use the Check Box List lookup style with Target Controller property to create many-to-many fields. Automatic insertion and deletion of records in the junction table is supported and explained in the code walkthrough.

Many-To-Many Fields in ASP.NET AJAX Web Apps

Watch the video tutorial on our YouTube channel at http://www.youtube.com/watch?v=Uv7aczHORmc.

Many-to-Many Fields (1409K)

Here is a screen shot of a many-to-many field in action. The five-column list of the territories is displayed at the bottom of the Employee form. The territories that are assigned to the employee are checked.

image

Code Defaults

Learn to assign default values to fields displayed in views of new records in ASP.NET AJAX web applications.

Default Values in Forms in ASP.NET AJAX Web Apps

Watch the video tutorial on our YouTube channel at http://www.youtube.com/watch?v=hdq6I1EVybE.

The screen shot shows the Order Date field of a new order set to a default value.

image

This is how the default value is specified in Code OnTime Designer.

image

Code Filters

Code filters allow to specify a filtering expression automatically embedded into the auto-generated business rule class to programmatically filter out the records in data views.  Learn to create shared programmatic filters to control data access in Web Site Factory applications.  We will explain creation of code filters and provide a C# and VB.NET examples.

Shared Programmatic Filters in ASP.NET AJAX Web Apps

Watch the video tutorial on our YouTube channel at http://www.youtube.com/watch?v=ndaj4ydsiiM.

Thursday, November 5, 2009PrintSubscribe
Side-by-Side With SharePoint

If you are developing line-of-business applications with Microsoft SharePoint Business Data Catalog then you are well aware of complexities and limitations that it brings to your everyday development tasks.

Now you have a wonderful alternative to have “true” native ASP.NET/AJAX applications run side-by-side with your MOSS or Microsoft SharePoint Services. Data Aquarium Framework has been enhanced to offer a companion Web Site Factory premium code generation project that allows quickly producing ASP.NET/AJAX web sites that look remarkably like Microsoft SharePoint in a matter of minutes.

image

Is goes well beyond the SharePoint styling and provides ASP.NET/AJAX programming model that requires very little development experience and delivers amazing features, such as automatic adaptive filtering, smooth and responsive user interface, and cutting-edge business rules development to promote code reusability.

image

Code OnTime Designer allows point-and-click configuration of the application pages and data controllers further speeding up the delivery of final products that you are working on.

SharePoint Business Data Catalog plays an important role in bringing your business data into the familiar SharePoint web site presentation model. Building business applications with it is especially gratifying when you accomplish any meaningful results since the challenge is quite significant.

You can feel total satisfaction while meeting little challenge all day long with Data Aquarium Framework and Web Site Factory. Web Site Factory code generator project automatically creates ASP.NET/AJAX applications that have zero dependency on Microsoft SharePoint, can be developed with free tools such as Microsoft Web Developer Express, and still look as good if not better then Microsoft SharePoint sites. Just select you programming language and point to your database. In a few clicks a perfect SharePoint-style application is ready.

Be prepared to answer questions of your customers about that new version of SharePoint that looks so smooth and responsive!

Once again, applications produced with Web Site Factory are not SharePoint applications. These are standard ASP.NET/AJAX web sites that can be developed with standard development tools and require the skill set that you already possess.

The look and feel of these applications is controlled 100% by CSS style sheets. A typical Web Site Factory application looks virtually identical in major modern browsers. Here is the page of an application with the style sheets disabled.

image

Here is the same page with the standard style sheets applied to it.

image

You have a choice of all security models supported by ASP.NET. It can be based on standard Windows Authentication. You can also Internet-enable your application and use built-in Membership Manager. This feature is working in conjunction with the standard ASP.NET Membership API.

image

Please take a look at the live preview of Web Site Factory at /blog/2009/11/web-site-factory-preview-3.html.

You could standard building  “Business Data Catalog 2.0” applications in minutes instead of days and weeks and get all the credit you deserve. Simply run Web Site Factory applications side-by-side with your SharePoint or MOSS instance and enjoy simplified development, zero external dependencies and complete source of every single bit of your projects.

No mysteries any more, no wasted time. Business Data Catalog of the future is delivered in Data Aquarium Framework.

Visit us at http://codeontime.com/subscriptions.aspx and subscribe to Premium Projects and Code OnTime Designer.

Friday, October 16, 2009PrintSubscribe
Conditional Visibility in Forms

Data Aquarium Framework supports declarative conditional visibility of fields and field categories in form views.

Conditional Visibility of Fields

Here is a snippet of the data field controller used in Code OnTime Designer that controls visibility of the Formula field if the field is marked as computed.

<category headerText="General" >
    <description><![CDATA[ Specify field name, type, and data properties of the field.]]></description>
    <dataFields>
. . . . .
<dataField fieldName="Computed"> <headerText>The value of this field is computed at run-time.</headerText> </dataField> <dataField fieldName="Formula" columns="50" rows="5"> <visibility> <expression type="ClientScript" test="[Computed]==true"/> </visibility> </dataField> <dataField fieldName="OnDemand"/> </dataFields> </category>

The visibility expression test is written in JavaScript. The expression test can refer to the names of the fields defined in the view. The field referenced must be incased in square brackets.

The expression test is evaluated on the client whenever the field values are changed. Evaluation does not cause the server post-back.

The following screenshots show the form before and after the computed field checked.

image

image

Conditional Visibility of Categories

The following snippet from the the same data controller shows visibility expression for a field category.

<category headerText="Lookup">
    <dataFields>
        <dataField fieldName="ItemsStyle"/>
        <dataField fieldName="ItemsDataController"/>
        <dataField fieldName="ItemsDataValueField"/>
        <dataField fieldName="ItemsDataTextField"/>
        <dataField fieldName="ItemsNewDataView"/>
        <dataField fieldName="ContextFields"/>
    </dataFields>
    <visibility>
        <expression type="ClientScript" test="[Type] != 'Byte[]' &amp;&amp; [Type] != 'Object' &amp;&amp; [OnDemand] != true" />
    </visibility>
</category>

The JavaScript expression reads as follows:

[Type] != 'Byte[]'  &&  [Type] != 'Object' && [OnDemand] != true

If the value of field Type is not equal to Byte[] or Object and the field is not OnDemand then the category of fields is visible.

The next screenshot shows the visible Lookup field category.

image

Conclusion

The visibility expressions can be defined directly in the data controller files. The upcoming update to Code OnTime Designer will allow easy modifications of the visibility expressions.