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)
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

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
Integrating ELMAH in Code OnTime Projects

Q. I have another question. I just implemented ELMAH into my solution and
am having some difficulty because every time I use the designer and
regenerate the solution the Elmah configuration entries get
overwritten in Web.Config. I'm sure others have run into this before.
How would you suggest I remediate this issue?

Arthur Djavairian

A. You can configure the project to execute custom Web.Config modification instructions as described at /blog/2010/03/customizing-webconfig.html.

ELMAH (Error Logging Modules and Handlers) is an application-wide error logging facility that is completely pluggable. It can be dynamically added to a running ASP.NET web application, or even all ASP.NET web applications on a machine, without any need for re-compilation or re-deployment.

Arthur has shared with us his configuration settings.

The following is the markup to add ELMAH error logging to a Code OnTime project.  Make sure to copy the instructions including the text in bold.

AppendChild: /configuration/configSections

              <sectionGroup name="elmah">
                       <!-- NOTE! If you are using ASP.NET 1.x then remove the
                requirePermission="false" attribute from the section
                elements below as those are only needed for
                partially trusted applications in ASP.NET 2.0 -->
                       <section name="security" requirePermission="false" type="Elmah.SecuritySectionHandler, Elmah"/>
                       <section name="errorLog" requirePermission="false" type="Elmah.ErrorLogSectionHandler, Elmah"/>
                       <section name="errorMail" requirePermission="false" type="Elmah.ErrorMailSectionHandler, Elmah"/>
                       <section name="errorFilter" requirePermission="false" type="Elmah.ErrorFilterSectionHandler, Elmah"/>
                       <section name="errorTweet" requirePermission="false" type="Elmah.ErrorTweetSectionHandler, Elmah"/>

InsertAfter: /configuration/connectionStrings

               <security allowRemoteAccess="1"/>
           Use to log errors to Microsoft SQL Server 2000 or 2005
           using ASP.NET 2.0. Set value of connectionStringName attribute
           to the name of the connection string settings to use from
           the <connectionStrings> section.
               <errorLog type="Elmah.SqlErrorLog, Elmah" connectionStringName="SimplePaymentPlans"/>

AppendChild: /configuration/system.web/httpHandlers

<add verb="POST,GET,HEAD" path="elmah.axd" type="Elmah.ErrorLogPageFactory, Elmah"/>

AppendChild: /configuration/system.web/httpModules

<add name="ErrorLog" type="Elmah.ErrorLogModule, Elmah"/>

AppendChild: /configuration

   <location path="elmah.axd">
               <allow roles="Administrators"/>
               <deny users="*" />

Sunday, March 21, 2010PrintSubscribe
Custom Search Bar With Auto-Complete

Learn to create custom search bars in Web Site Factory and Web Site Builder projects. The search bars are typically displayed above the grid views. Use any standard and commercial ASP.NET controls to capture the search parameters. We will show you how to implement a predictive input in your search fields without writing any code.

Custom Search Bar With Auto-Complete in ASP.NET/AJAX Web Apps

Watch this tutorial on our YouTube channel at

Here is the custom search bar of the sample application discussed in the tutorial when displayed in Google Chrome.


The markup of the ASP.NET user control from the example is presented below.

<%@ Control Language="VB" AutoEventWireup="false" CodeFile="SearchControl.ascx.vb"
    Inherits="Controls_SearchControl" %>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <div class="SettingsPanel">
                        Product:<br />
                        <aquarium:DataViewTextBox ID="ProductNameText" runat="server" 
                            DataController="Products" DistinctValueFieldName="ProductName" />
                        Supplier:<br />
                        <aquarium:DataViewTextBox ID="SupplierCompanyNameText" runat="server" 
                            DataController="Products" DistinctValueFieldName="SupplierCompanyName" />
                        Category:<br />
                        <aquarium:DataViewTextBox ID="CategoryCategoryNameText" runat="server" 
                            DataController="Products" DistinctValueFieldName="CategoryCategoryName" />
                        <br />
                        <asp:Button ID="SearchButton" runat="server" Text="Search" />
<div id="ProductList" runat="server">
<aquarium:DataViewExtender ID="ProductListExtender" runat="server" TargetControlID="ProductList"
    Controller="Products" ShowDescription="false" ShowQuickFind="false" />

Here is the code-behind class written in Visual Basic that uses DataViewExtender.AssignFilter method to execute the search operation in the client browser in response to the button pressed on the custom search bar.

Imports System
Imports System.Collections.Generic
Imports System.Linq
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports MyCompany.Data
Imports MyCompany.Web

Partial Public Class Controls_SearchControl
    Inherits System.Web.UI.UserControl
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
        If Not IsPostBack Then
            ProductNameText.Text = Session("ProductName")
            SupplierCompanyNameText.Text = Session("SupplierCompanyName")
            CategoryCategoryNameText.Text = Session("CategoryCategoryName")
        End If
    End Sub

    Protected Sub SearchButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles SearchButton.Click
        Dim filter As List(Of FieldFilter) = New List(Of FieldFilter)
        If String.IsNullOrEmpty(ProductNameText.Text) Then
            filter.Add(New FieldFilter("ProductName", RowFilterOperation.None))
            filter.Add(New FieldFilter("ProductName", RowFilterOperation.Like, ProductNameText.Text))
        End If
        If String.IsNullOrEmpty(SupplierCompanyNameText.Text) Then
            filter.Add(New FieldFilter("SupplierCompanyName", RowFilterOperation.None))
            filter.Add(New FieldFilter("SupplierCompanyName", RowFilterOperation.Like, SupplierCompanyNameText.Text))
        End If
        If String.IsNullOrEmpty(CategoryCategoryNameText.Text) Then
            filter.Add(New FieldFilter("CategoryCategoryName", RowFilterOperation.None))
            filter.Add(New FieldFilter("CategoryCategoryName", RowFilterOperation.Like, CategoryCategoryNameText.Text))
        End If
        Session("ProductName") = ProductNameText.Text
        Session("SupplierCompanyName") = SupplierCompanyNameText.Text
        Session("CategoryCategoryName") = CategoryCategoryNameText.Text
    End Sub
End Class
Continue to Custom Form Templates