Blog: Posts from April, 2011

Labels
AJAX(112) App Studio(6) 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(178) 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) 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
Posts from April, 2011
Wednesday, April 27, 2011PrintSubscribe
Data Sheet Enhancements

The following enhancements and bug fixes were introduced in the latest update.

Miscellaneous Improvements

  • Search bar is correctly displayed if activated on start in browsers other than IE.
  • Firefox bug preventing creation of lookup items in-place has been fixed.
  • Core CSS enhancements to improve support for IE 9 and enhance quality of the data sheet rendering
  • Several new resource constants in Web.DataViewResources.js to support new functionality in the data sheet view.

Data Sheet

Summary of data sheet enhancements.

  • Menu “Actions” in the action bar will feature “Show in Data Sheet” or “Show in Standard View” option if your application has been produced by Premium or Unlimited edition. These new options are executing actions with Data Sheet and Grid command names, which causes switching between data sheet and standard grid view.   
     
    See the Data Sheet view in action at http://codeontime.com/demo.aspx.
     
    image
    image
     
  • Data Sheet view now display an arrow pointer in the gap column to indicate the row that is currently selected in the view. The focused cell may be positioned in any row. The selected row is designated by the arrow. Any linked child data views are filtered to match the primary key of the selected row.
     
    image
     
  • Several bugs related to keyboard handling were fixed. Pressing Enter key while working in the child data sheet with the master form would have caused erratic selection of buttons in the master form.
  • User can start creating a new row in the data sheet by pressing Insert key or navigating past the last row in the data sheet view.
  • User can end editing an existing or entering a new row by pressing Tab or Enter key while in the last column of the row. Tab key will cause automatic creation of a new row if the current row has been persisted successfully. Enter key will leave the selection focus on the last focused column.
  • Empty data sheet view offers a link to enable instant creation of new rows. Users can click on a link to start creating a new row.
     
    image
    image
  • User can press Ctrl+Delete keys to delete the row with the current focus in the data sheet.
  • User can press Ctrl+Space to select a a row if multiple-row selection is enabled in the data sheet.
  • Pressing Tab or Shift+Tab key in edit mode will skip the read-only cells.

Next Update

The upcoming update will introduce the long awaited enhanced file upload/download processing to allow capturing file name, size, and content type. 

Monday, April 25, 2011PrintSubscribe
Date and Time

Code On Time supports extended date and time shortcuts and allows independent entry of data and time components of a single database table column.

The following screen shot shows the Northwind.dbo.Orders table presented in a Web Site Factory applications generated with Code On Time database web application generator.

image

Three “date-time” columns Order Date, Required Date, and Shipped Date are configured with different Data Format String property.

Field Name Data Format String Description
Order Date

d

Standard format string applied to Date Time fields. This is the default value if no data format string is specified. The alternative format is {0:d}
Required Date

g

Date and short time format. The alternative value is {0:g}
Shipped Date

{0:G}

Date and long time format with hours, minutes, and seconds. The alternative value of the data format string is G.

Select any data row and click Edit button. You will see that the time component of the Date-Time fields with “g”, “{0:g}”, “G”, or “{0:G}” data format string is displayed in a separate box. The application in the screen shot is configured with culture and UI culture set to “en-GB”.

image

Date and time input boxes support various shortcuts that allow entering the data quickly.

For example, if you type the following value in the designated input then the value will be automatically converted in a legitimate data time format. The result values for “named” samples are calculated on April 25, 2011.

Sample Input Result
280273 Date 28/02/1973
2802 Date 28/02/2011
tuesday Date 26/04/2011
Fri Date 29/04/2011
su Date 01/05/2011
25-apr Date 25/04/2011
28022012 Date 28/02/2012
1:20 Time 01:20
1,15pm Time 13:15

The input conversion is done just-in-time. The conversion code will use the culture settings of the application and will handle shortcuts that work for the application locale.

The same behavior is exhibited in Grid and Data Sheet views.

image

End users will surely appreciate the handy shortcuts and a wide range of method of entering date and time field values.

Monday, April 25, 2011PrintSubscribe
Data Sheet View

Code On Time applications now offer a new exceptional feature that allows spreadsheet-style presentation and editing of multiple records.

You can enable the data sheet view if you change the type of your grid view from “Grid” to “Data Sheet”. Start the web application generator, select the name of your project, click “Design” button, select a data controller, and activate “Views” tab. Change the type of view grid1 to “Data Sheet”.

image

Generate your application and navigate to the page that presents the data controller views. Click once on any cell in the data sheet view. The header of the column will get highlighted. You can now start using the keyboard to navigate between cells.

image

Press Down key until you reach the last visible row on the page. Press Down key one more and observe how the rows shift.

Start typing in any cell to edit the data, press F2 key to start editing, or click Del to clear the contents of the cell. The row will switch in edit mode. Any business rules that work with grid views will continue to work with the data sheet view. Use Tab and Shit+Tab keys to navigate between cells in the edit row. Use mouse to click on arbitrary cell in the edit row to active the cell.

image

Hit Enter key to save the row. Enter and Shift+Enter keys will navigate down and up in the data sheet view when not in edit mode.

Press Insert key to create a new row or simply navigate beyond the last row in the data sheet view.

image

Press Esc to exit edit/new mode.

Press Esc if you want to stop using keyboard with the data sheet view. The cell focus will disappear.

Conclusion

Data Sheet view will offer a new rapid data entry method for your end users. We are planning to offer a code generator option that will make the Data Sheet view a default presentation for grids of data.

Excellent cross browser support will bring Microsoft Excel and Microsoft Access desktop experience of interacting with data to the web.

Data Sheet view is available only in Premium and Unlimited editions. View Code On Time product edition pricing at http://codeontime.com/buy.aspx.  The upcoming updates will include new additional view types such as tree view and calendar view.

Continue to Rounded Shadows