Click here to Skip to main content
15,886,857 members
Articles / Web Development / ASP.NET

ASP.NET/AJAX 3.5 With Aquarium Express

Rate me:
Please Sign up or sign in to vote.
3.60/5 (7 votes)
18 Sep 2008Ms-PL12 min read 35.7K   954   29  
Learn to build modern AJAX and ASP.NET 3.5 applications with free Aquarium Express Framework
<dataController name="EmployeeTerritories" conflictDetection="overwriteChanges" label="Employee Territories" xmlns="urn:schemas-codeontime-com:data-aquarium">
  <commands>
    <command id="command1" type="Text">
      <text><![CDATA[
select
	"EmployeeTerritories"."EmployeeID" "EmployeeID"
	,"Employee"."LastName" "EmployeeLastName"
	,"EmployeeTerritories"."TerritoryID" "TerritoryID"
	,"Territory"."TerritoryDescription" "TerritoryTerritoryDescription"
	,"TerritoryRegion"."RegionDescription" "TerritoryRegionRegionDescription"
from "dbo"."EmployeeTerritories" "EmployeeTerritories"
	left join "dbo"."Employees" "Employee" on "EmployeeTerritories"."EmployeeID" = "Employee"."EmployeeID"
	left join "dbo"."Territories" "Territory" on "EmployeeTerritories"."TerritoryID" = "Territory"."TerritoryID"
	left join "dbo"."Region" "TerritoryRegion" on "Territory"."RegionID" = "TerritoryRegion"."RegionID"
]]></text>
    </command>
  </commands>
  <fields>
    <field name="EmployeeID" type="Int32" allowNulls="false" isPrimaryKey="true" label="Employee#">
      <items style="Lookup" dataController="Employees" newDataView="createForm1" />
    </field>
    <field name="EmployeeLastName" type="String" readOnly="true" label="Employee Last Name" />
    <field name="TerritoryID" type="String" allowNulls="false" isPrimaryKey="true" label="Territory#">
      <items style="Lookup" dataController="Territories" newDataView="createForm1" />
    </field>
    <field name="TerritoryTerritoryDescription" type="String" readOnly="true" label="Territory Description" />
    <field name="TerritoryRegionRegionDescription" type="String" readOnly="true" label="Territory Region Description" />
  </fields>
  <views>
    <view id="grid1" type="Grid" commandId="command1" label="Employee Territories">
      <headerText>This is a list of employee territories. </headerText>
      <dataFields>
        <dataField fieldName="EmployeeID" aliasFieldName="EmployeeLastName" />
        <dataField fieldName="TerritoryID" aliasFieldName="TerritoryTerritoryDescription" />
        <dataField fieldName="TerritoryRegionRegionDescription" columns="50" />
      </dataFields>
    </view>
    <view id="editForm1" type="Form" commandId="command1" label="Review Employee Territories">
      <headerText>Please review employee territories information below. Click Edit to change this record, click Delete to delete the record, or click Cancel/Close to return back.</headerText>
      <categories>
        <category headerText="Employee Territories">
          <description>These are the fields of the employee territories record that can be edited.</description>
          <dataFields>
            <dataField fieldName="EmployeeID" aliasFieldName="EmployeeLastName" />
            <dataField fieldName="TerritoryID" aliasFieldName="TerritoryTerritoryDescription" />
          </dataFields>
        </category>
        <category headerText="Reference Information">
          <description>Additional details about employee territories are provided in the reference information section.</description>
          <dataFields>
            <dataField fieldName="TerritoryRegionRegionDescription" columns="50" />
          </dataFields>
        </category>
      </categories>
    </view>
    <view id="createForm1" type="Form" commandId="command1" label="New Employee Territories">
      <headerText>Please fill this form and click OK button to create a new employee territories record. Click Cancel to return to the previous screen.</headerText>
      <categories>
        <category headerText="New Employee Territories">
          <description>Complete the form. Make sure to enter all required fields.</description>
          <dataFields>
            <dataField fieldName="EmployeeID" aliasFieldName="EmployeeLastName" />
            <dataField fieldName="TerritoryID" aliasFieldName="TerritoryTerritoryDescription" />
          </dataFields>
        </category>
      </categories>
    </view>
  </views>
  <actions>
    <actionGroup scope="Grid">
      <action commandName="Select" commandArgument="editForm1" />
      <action commandName="Edit" />
      <action commandName="Delete" confirmation="Delete?" />
      <action whenLastCommandName="Edit" commandName="Update" headerText="Save" />
      <action whenLastCommandName="Edit" commandName="Cancel" />
    </actionGroup>
    <actionGroup scope="Form">
      <action commandName="Edit" />
      <action commandName="Delete" confirmation="Delete?" />
      <action commandName="Cancel" headerText="Close" />
      <action whenLastCommandName="Edit" commandName="Update" headerText="OK" />
      <action whenLastCommandName="Edit" commandName="Delete" confirmation="Delete?" />
      <action whenLastCommandName="Edit" commandName="Cancel" />
      <action whenLastCommandName="New" commandName="Insert" headerText="OK" />
      <action whenLastCommandName="New" commandName="Cancel" />
    </actionGroup>
    <actionGroup scope="ActionBar" headerText="New">
      <action commandName="New" commandArgument="createForm1" headerText="New Employee Territories" description="Create a new Employee Territories record." />
    </actionGroup>
    <actionGroup scope="ActionBar" headerText="Actions">
      <action commandName="Custom" commandArgument="ExportCsv" headerText="Export to Spreadsheet" description="Analyze items with spreadsheet&lt;br/&gt; application." cssClass="ExportCsv" />
      <action commandName="Custom" commandArgument="ExportRss" headerText="View RSS Feed" description="Syndicate items with an RSS reader." cssClass="ExportRss" />
      <action />
      <action commandName="Custom" commandArgument="MyCommand" headerText="My Command" description="Execute my custom command" />
    </actionGroup>
    <actionGroup scope="ActionBar" headerText="Record">
      <action whenLastCommandName="Edit" commandName="Update" headerText="Save" description="Save changes to the database." />
      <action whenLastCommandName="Edit" commandName="Cancel" description="Cancel all record changes." />
    </actionGroup>
  </actions>
</dataController>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Microsoft Public License (Ms-PL)


Written By
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.
This is a Organisation

1 members

Comments and Discussions