Data Aquarium Framework

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
Data Aquarium Framework
Wednesday, April 28, 2010PrintSubscribe
Globalization, Localization, Multi-Select, Batch Editing…

The latest release of Code OnTime Generator, Web Site Builder,  and Web Site Factory features several enhancements.

Multi-Select Everywhere

You can now enable globally the multi-select feature in your ASP.NET web applications. The code generation control option is available on the Features page of the project wizard under Grid Layout section.

image

The next screen shot shows a page with multi-select enabled.

image

A row selection check box becomes visible if you hover over a row. A check box becomes permanently visible  when checked to make the page look less busy. The number of selected records is displayed in the pager area.

The feature allows multiple row selection on multiple pages. Only Delete operation is supported with multiple selected rows out-of-the-box.

Batch Editing Everywhere

Batch Edit is another command that works with multiple row selection. You can enable batch editing in all data controllers by selecting the “Enable batch editing…” feature in Grid Layout section of the application Features page in the project wizard.

Batch editing is activated by selecting Batch Edit or Batch Edit (Form) popup menu option from the row context menu when you hover over a link in the first column of any grid view. You can edit multiple records inline and in a form view. Each field is automatically displaying update check box that must be checked to indicate the fields that must be updated in the selected rows.

Here is the screen shot of the feature in action when activated inline in a grid view.

image

Globalization and Localization

Now you can explicitly define the globalization options in the code generator project wizard and create your own localized resources.

Read about it at /blog/2010/05/globalization-and-localization.html.

Thursday, April 15, 2010PrintSubscribe
Many-to-Many Virtual Field in 3 Minutes

We will show you how to set up a many-to-many field derived from a junction table and lookup in under three minutes without writing a single line of code in ASP.NET+AJAX web application generated with Code OnTime Generator and Web Site Factory premium project.

Many-to-Many Virtual Field in 3 Minutes in ASP.NET/AJAX Web App

Watch this tutorial on our YouTube channel at http://www.youtube.com/watch?v=mv44qXO-3fQ.

You can also see a more detailed description of many-to-many functionality at /blog/2010/03/many-to-many-fields-code-defaults-code.html.

Saturday, March 27, 2010PrintSubscribe
Standalone ASP.NET Membership Database

Web Site Factory and other premium projects integrate ASP.NET Membership, a built-in way to store and validate user credentials. You can enable ASP.NET Membership by selecting the membership option in the code generator project wizard. This will enable numerous membership features including a fly-over sign-in window, self-service membership enrollment, membership bar, and membership manager.

image

The configuration of your project will be automatically changed to support the default membership provider available in ASP.NET. This provider defines a connection string that points to a local instance of Microsoft SQL Server Express. The provider will automatically connect to the server and dynamically create a database to maintain users, roles, and other membership features. The database will be created under ~/App_Data folder of your project.

This works great on a development machine with installed SQL Server  Express. There are many situations when you want to use a standalone membership database or store ASP.NET membership data structures directly in your own database.

Project wizard offers an option that will enable a standalone membership database configuration. Here is the screen shot of the project wizard with the the standalone membership database enabled. 

image

The connection string in the screen shot looks as follows:

Data Source=.;Initial Catalog=aspnetdb;Integrated Security=True;

We have configured the standalone membership database with the name aspnetdb.

You can read more about the configuration process at http://msdn.microsoft.com/en-us/library/ms229862(VS.80).aspx.

These are the steps that we have taken to create the aspnetdb database:

  1. We have started aspnet_regsql.exe from Windows Explorer as shown in picture.
    image
    The path to your instance of aspnet_regsql.exe:
    C:\%windir%\Microsoft.NET\Framework\<versionNumber>\aspnet_regsql.exe

  2. We have clicked Next button in ASP.NET SQL Server Setup Wizard:
    image

  3. We have continued to the next step to configure SQL Server for application services:
    image 

  4. We have entered “.” as a server name and “aspnetdb” as database name.
    image 
    A few more clicks on the Next button have done the job for us. The database has been created. We have returned to the project wizard of our code generation project and configure the provider name and connection string of the newly created membership database.