Tornado API Library - V12.30.08

z.dbEmbeddedGridNameMap Property

Apply NameMap to embedded grid.

Product Version

EP,Gold
[VisualBasic]
PublicPropertydbEmbeddedGridNameMapAsString
[C#]
publicstringdbEmbeddedGridNameMap{set;}

Property Value

Obj.dbEmbeddedGridNameMap="(;,)Field |Alias | Tag=HeaderTags | Formula=CalcExp, ...repeat"

KeywordDescription
FieldField name or ordinal number of Grid or Form to be mapped. Field=CustomerID , Field=0
AliasThe mapped name. Alias=My Name
TagClass=?? COLSPAN=?? Align=??. Due to the new structure of being able to replace the entire header with GH1 and header=false. Tag use is not effective here. Selecting a new class will change the appearance of the cell.
FormulaThis optional parameter defines the calculated expression of the field. This parameter is required for sort, filtering and editing criteria. See following case study examples. Note that the formula field must provide the appropriate wrappers for alias fields of SQL, ORACLE etc..

QuickProp Keyword Abbreviation

egnm

Remarks

This NameMapping property applies to the Embedded Grid. An embedded grid is one that resides in the cell of a grid. Only one level of embedding is supported The embedded gris usually have a different header then the regular grid and this property allows the mame mapping which makes the customization more perfect.

Example

<script language="VB" runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
   Dim E64 As New Tornado.Z()
   With E64
    .dbUnit = 60
    .dbSkin= 11
    .dbMode = "Grid"
    .dbGridDisplayFlds = "CustomerID, CompanyName, ContactName"
    .dbDSN = "Nwind.mdb"
    .dbGridMagicCell = "(;![]#|~/+{})field=CompanyName|Macro=#1#<br>#4#<br>#5#," _
            & "#7#<p>#2#<br>#4#<br>#9#!field=ContactName|" _
            & "Macro=SQL0:SELECT OrderID,OrderDate,RequiredDate,ShippedDate " _
            & "from orders where customerID= '#0#'"
    .dbNameMap = "field=CustomerID|alias=ID,field=CompanyName|" _
         & "alias=Customer,field=ContactName|alias=Orders"
    .dbEmbeddedGridNameMap = "field=OrderID|alias=ID,field=OrderDate|alias=Ordered," _
         & "field=RequiredDate|alias=Required,field=ShippedDate|alias=Shipped"
    .dbSQL = "SELECT CustomerID,CompanyName,ContactName,ContactTitle,Address,City," _
         & "Region,PostalCode,Country,Phone,Fax FROM Customers"
    .dbTextHolder = "Title=Tornado Demo - MagicCell - Master with embedded Details|" _
         & "subtitle=Can you image you can do this with 17 lines of code?"
    .ASPdbNET()
   End With
End Sub
</script>

See Also

z Class | Tornado Namespace | dbNameMap | dbFormNameMap | Special Topic - NameMap