DbNetSuite Sample

Example

Source

Instances of DbNetEdit can be linked together by simply specifying the ID of the parent control in the ParentControlID property. Child controls also need to identify the ForeignKey column which is matched with the PrimaryKey column in the parent control.

Customers

CustomerID

CompanyName

Address

City

Record

Orders

CustomerID

OrderID

OrderDate

RequiredDate

Record

Order Details

OrderID

ProductID

UnitPrice

Quantity

Record

Register the component libraries

<%@ Register TagPrefix="DNL" Assembly="DbNetLink.DbNetSuiteVS" Namespace="DbNetLink.DbNetSuiteVS" %>

Server Control

    <table>
        <tr>
            <td style="vertical-align: top">
                <fieldset>   
                <legend>Customers</legend>   
                <DNL:DbNetEdit 
                    runat="server" 
                    id="CustomersForm" 
                    ConnectionString="SamplesDatabase" 
                    FromPart="Customers" >
                    <Columns>
                        <DNL:EditColumn ColumnExpression="CustomerID" PrimaryKey="true" />
                        <DNL:EditColumn ColumnExpression="CompanyName" />
                        <DNL:EditColumn ColumnExpression="Address" />
                        <DNL:EditColumn ColumnExpression="City" />
                    </Columns>
                </DNL:DbNetEdit>
                </fieldset>
            </td>
        </tr>
        <tr>
            <td style="vertical-align: top">
                <fieldset>   
                <legend>Orders</legend>   
                <DNL:DbNetEdit 
                    runat="server" 
                    id="OrdersForm" 
                    ConnectionString="SamplesDatabase" 
                    FromPart="Orders" 
                    ParentControlID="CustomersForm" >
                    <Columns>
                        <DNL:EditColumn ColumnExpression="CustomerID" ForeignKey="true" />
                        <DNL:EditColumn ColumnExpression="OrderID" PrimaryKey="true" />
                        <DNL:EditColumn ColumnExpression="OrderDate" />
                        <DNL:EditColumn ColumnExpression="RequiredDate" />
                    </Columns>
                </DNL:DbNetEdit>
                </fieldset>
            </td>
        </tr>
        <tr>
            <td style="vertical-align: top">
                <fieldset>   
                <legend>Order Details</legend>   
                <DNL:DbNetEdit 
                    runat="server" 
                    id="OrdersDetailsForm" 
                    ConnectionString="SamplesDatabase" 
                    FromPart="[Order Details]" 
                    ParentControlID="OrdersForm" >
                    <Columns>
                        <DNL:EditColumn ColumnExpression="OrderID" ForeignKey="true" />
                        <DNL:EditColumn ColumnExpression="ProductID" EditControlType="TextBoxLookup" Lookup="select productid, productname from products" />
                        <DNL:EditColumn ColumnExpression="UnitPrice" />
                        <DNL:EditColumn ColumnExpression="Quantity" />
                    </Columns>
                </DNL:DbNetEdit>
                </fieldset>
            </td>
        </tr>
    </table>