DbNetSuite Sample

Example

Source

Grid, Edit and File controls can all be integrated with each other allowing for a huge range of possibilities. To integrate controls the ParentControlID and ForeignKey of the child control must be set. In this example an Edit control is linked to a Grid control.

Employees

Rows

Employee Details

EmployeeID

LastName

FirstName

Title

TitleOfCourtesy

BirthDate

HireDate

Address

City

Region

PostalCode

Country

HomePhone

Extension

Photo

Notes

ReportsTo

Register the component libraries

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

Server Control

    
    
    
    	<table>
		<tr>
			<td style="vertical-align:top;">
				<fieldset>
				<legend>Employees</legend>			
				<DNL:DbNetGrid ID="DbNetGrid1" runat="server" connectionstring="SamplesDatabase" Navigation="false" frompart="Employees">
				    <Columns>
                        <DNL:GridColumn ColumnExpression="LastName"/> 
                        <DNL:GridColumn ColumnExpression="FirstName"/>
                        <DNL:GridColumn ColumnExpression="ReportsTo" Lookup="select employeeid, lastname & ', ' & firstname from employees order by 2"/>   
				    </Columns>
				</DNL:DbNetGrid>
				</fieldset>		
				
			</td>
			
			<td style="vertical-align:top;">
				<fieldset>
				<legend>Employee Details</legend>
				<DNL:DbNetEdit 
					ID="DbNetEdit1" 
					runat="server" 
					ParentControlID="DbNetGrid1" 
					FromPart="Employees"
					Height="400px"
					>
					<Columns>
                    <DNL:EditColumn ColumnExpression="EmployeeID" ForeignKey="true" /> 
                    <DNL:EditColumn ColumnExpression="LastName"/> 
                    <DNL:EditColumn ColumnExpression="FirstName"/>
                    <DNL:EditColumn ColumnExpression="Title"/>
                    <DNL:EditColumn ColumnExpression="TitleOfCourtesy"/>
                    <DNL:EditColumn ColumnExpression="BirthDate"/>  
                    <DNL:EditColumn ColumnExpression="HireDate"/>  
                    <DNL:EditColumn ColumnExpression="Address"/>  
                    <DNL:EditColumn ColumnExpression="City"/>   
                    <DNL:EditColumn ColumnExpression="Region"/>   
                    <DNL:EditColumn ColumnExpression="PostalCode"/>   
                    <DNL:EditColumn ColumnExpression="Country"/>   
                    <DNL:EditColumn ColumnExpression="HomePhone"/>   
                    <DNL:EditColumn ColumnExpression="Extension"/>    
                    <DNL:EditColumn ColumnExpression="Photo"/>    
                    <DNL:EditColumn ColumnExpression="Notes"/>    
                    <DNL:EditColumn ColumnExpression="ReportsTo" Lookup="select employeeid, lastname & ', ' & firstname from employees order by 2"/>   
                 </Columns>
				</DNL:DbNetEdit>
				</fieldset>		
			</td>
		</tr>
    </table>