|
<dataController name="Customers" conflictDetection="overwriteChanges" label="Customers" xmlns="urn:schemas-codeontime-com:data-aquarium">
<commands>
<command id="command1" type="Text">
<text>
<![CDATA[
select
"Customers"."CustomerID" "CustomerID"
,"Customers"."CompanyName" "CompanyName"
,"Customers"."ContactName" "ContactName"
,"Customers"."ContactTitle" "ContactTitle"
,"Customers"."Address" "Address"
,"Customers"."City" "City"
,"Customers"."Region" "Region"
,"Customers"."PostalCode" "PostalCode"
,"Customers"."Country" "Country"
,"Customers"."Phone" "Phone"
,"Customers"."Fax" "Fax"
from "dbo"."Customers" "Customers"
]]>
</text>
</command>
</commands>
<fields>
<field name="CustomerID" type="String" allowNulls="false" isPrimaryKey="true" label="Customer#" />
<field name="CompanyName" type="String" allowNulls="false" label="Company Name" />
<field name="ContactName" type="String" label="Contact Name" />
<field name="ContactTitle" type="String" label="Contact Title" />
<field name="Address" type="String" label="Address" />
<field name="City" type="String" label="City" />
<field name="Region" type="String" label="Region" />
<field name="PostalCode" type="String" label="Postal Code" />
<field name="Country" type="String" label="Country" />
<field name="Phone" type="String" label="Phone" />
<field name="Fax" type="String" label="Fax" />
</fields>
<views>
<view id="grid1" type="Grid" commandId="command1" label="Customers">
<headerText><![CDATA[This is a list of customers. <span style="color:green;font-weight:bold">Click on the customer code to view orders placed by customer.</span>]]></headerText>
<dataFields>
<dataField fieldName="CustomerID" columns="5" />
<dataField fieldName="CompanyName" columns="40" />
<dataField fieldName="ContactName" columns="30" />
<dataField fieldName="ContactTitle" columns="30" />
<dataField fieldName="Address" />
<dataField fieldName="City" columns="15" />
<dataField fieldName="Region" columns="15" />
<dataField fieldName="PostalCode" columns="10" />
<dataField fieldName="Country" columns="15" />
<dataField fieldName="Phone" columns="24" />
</dataFields>
</view>
<view id="editForm1" type="Form" commandId="command1" label="Review Customers">
<headerText>Please review customers 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="Customers">
<description>These are the fields of the customers record that can be edited.</description>
<dataFields>
<dataField fieldName="CustomerID" columns="5" />
<dataField fieldName="CompanyName" columns="40" />
<dataField fieldName="ContactName" columns="30" />
<dataField fieldName="ContactTitle" columns="30" />
<dataField fieldName="Address" />
<dataField fieldName="City" columns="15" />
<dataField fieldName="Region" columns="15" />
<dataField fieldName="PostalCode" columns="10" />
<dataField fieldName="Country" columns="15" />
<dataField fieldName="Phone" columns="24" />
<dataField fieldName="Fax" columns="24" />
</dataFields>
</category>
</categories>
</view>
<view id="createForm1" type="Form" commandId="command1" label="New Customers">
<headerText>Please fill this form and click OK button to create a new customers record. Click Cancel to return to the previous screen.</headerText>
<categories>
<category headerText="New Customers">
<description>Complete the form. Make sure to enter all required fields.</description>
<dataFields>
<dataField fieldName="CustomerID" columns="5" />
<dataField fieldName="CompanyName" columns="40" />
<dataField fieldName="ContactName" columns="30" />
<dataField fieldName="ContactTitle" columns="30" />
<dataField fieldName="Address" />
<dataField fieldName="City" columns="15" />
<dataField fieldName="Region" columns="15" />
<dataField fieldName="PostalCode" columns="10" />
<dataField fieldName="Country" columns="15" />
<dataField fieldName="Phone" columns="24" />
<dataField fieldName="Fax" columns="24" />
</dataFields>
</category>
</categories>
</view>
</views>
<actions>
<actionGroup scope="Grid">
<action commandName="Navigate" headerText="Show Orders" commandArgument="Orders.aspx?CustomerID={CustomerID}"/>
<action commandName="Select" commandArgument="editForm1" headerText="View Customer Information"/>
<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 Customers" description="Create a new Customers record." />
</actionGroup>
<actionGroup scope="ActionBar" headerText="Actions">
<action commandName="Custom" commandArgument="ExportCsv" headerText="Export to Spreadsheet" description="Analyze items with spreadsheet<br/> 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.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.