ASP.NET Code Generator

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
ASP.NET Code Generator
Monday, May 2, 2011PrintSubscribe
SQL Anywhere Membership Configuration

You can find detailed instructions about development of applications with SQL Anywhere 12 and ASP.NET at http://www.sybase.com/detail?id=1080238.

This tutorial outlines the steps required to configure ASP.NET Membership features in a database that will become a part of web application created with Code On Time web application code generator.

Start Windows Explorer and navigate to “C:\Program Files\SQL Anywhere 12\Assembly\V2” folder.

image_thumb[13][5]

Start SASetupAspNet.exe configuration utility.

Select the language for the ASP.NET security schema configuration.

image_thumb[6]

Connect to the database. The screen shot below shows how to connect to a default demo database created by SQL Anywhere installation program. Enter dsn=SQL Anywhere 12 Demo and test the connection.

image_thumb[5]

Add Membership and Roles to the configuration. Select other options if you are planning to use profiles, web part personalization, and health monitoring.

image_thumb[9]

Finish configuration of your database.

image_thumb[16]

If you are performing configuration on Windows 7 then you may see the following dialog at the end of the configuration process. Ignore the warning and select “This program installed correctly”.

image_thumb[19]

Sunday, May 1, 2011PrintSubscribe
Deploying Generated Applications to Winhost

Learn how to deploy your Web Site Factory and Web App Factory applications to the popular hosting provider http://www.winhost.com.

Includes instructions for web applications working with Microsoft SQL Server and MySQL databases.

/Documents/CB-Deploying_Your_App_To_WinHost.pdf

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.

Continue to Data Sheet View