Blog

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(8) OAuth Scopes(1) OAuth2(11) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(10) PKCE(2) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(179) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(80) 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
Sunday, March 7, 2010PrintSubscribe
How do I display a path stored in a field as an image?

Question:

Do you have an example of how we can display the image by using the DataFormatString and HTMLEncode? Basically, our database has a field "photo_url" which store the path to the photo in the file system. Can it behave like an image field in terms of presentation?

Please try the following:

1. Start the code generator, click on the name of your project and press "Design" button, select the data controller name and add a new field to the data controller.

2. If the name of the image field is "PhotoPath" then name the new field "PhotoPathImage".

3. Set the type of the new field to "String".

4. Set "Allow null values." to true.

5. Check "The value of the field is computed at runtime" and enter the same snippet from the data controller's command command1 that selects the actual field "PhotoPath". For example, the Northwind's database Employees.PhotoPath will look as follows:

          "Employees"."PhotoPath".

6. Assign a label to the new field. For example, "Photo Path"

7. Uncheck HTML encoding.

8. Enter <img src="{0}"/> as a data format string.

9. Save the field.

10. Add a new data field to grid1 or editForm1 and set its FieldName to PhotoPathImage.

The field will be presented as an image.

Wednesday, March 3, 2010PrintSubscribe
Conditional CSS Styles

Learn to create conditional CSS styles to alter the presentation of grid view rows. We will customize the Web Site Factory application to highlight orders details that are too expensive or have a high discount.

 

You can see this tutorial on our YouTube channel at http://www.youtube.com/user/codeontime#p/u/2/uE7BzQW8mrw.

Conditional CSS Styling (626K)

Monday, March 1, 2010PrintSubscribe
Multi-Field Lookup, Code Formulas, Data Format String

The latest release of Web Site Factory premium project includes the following features:

  • Support for multi-field lookups that work in both, lookup field and master detail mode. Field lookups can now copy multiple field values from the selected parent record into the fields of the child record. The master-detail link will automatically assign parent record’s fields to the new child record if a parent lookup field defines the lookup copy settings.
    http://www.youtube.com/watch?v=rpWvIzBd-FA
  • Support for code formulas to allow just-in-time calculations when a new or existing record is being edited. You write the formula text and the Code OnTime Generator will automatically create a business rules class with the incorporated formula in it.  This feature requires Code OnTime Designer subscription.
    /blog/2010/02/declarative-code-formulas.html
  • Field definitions are now supporting Data Format String property in Code OnTime Designer. Previously, a data format string was supported in data fields only, which has required setting up the data format string for each view. If a data format string is defined on a data controller field level then the same data format string is being used in all views that have data fields based on the field definition.
Continue to Multi Field Lookup