DbNetSuite Sample

Example

Source

Menu

The grid rows can be filtered using the FixedFilter and FixedFilterParameters properties. In this example only customers in the USA are selected.

M	T	W	T	F	S	S

File Upload

HTML Editor

Text Editor

Lookup

File Preview

Search

CustomerID

and

CompanyName

and

ContactName

and

ContactTitle

and

Address

and

City

and

Region

and

PostalCode

and

Country

and

Phone

and

Fax

and

Edit

File Preview

CustomerID

CompanyName

ContactName

ContactTitle

Address

City

Region

PostalCode

Country

Phone

Fax

Page

of

Rows

Output current page only

Register the component libraries

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

Server Control

    <DNL:DbNetGrid 
        ID="DbNetGrid1" 
        runat="server" 
        ConnectionString="SamplesDatabase" 
        EditDialogHeight="200px"
        SearchDialogHeight="200px"
        FromPart="Customers" >
	<Columns>
		<DNL:GridColumn ColumnExpression="CustomerID"/>
		<DNL:GridColumn ColumnExpression="CompanyName"/>
		<DNL:GridColumn ColumnExpression="ContactName"/>
		<DNL:GridColumn ColumnExpression="ContactTitle"/>
		<DNL:GridColumn ColumnExpression="Address"/>
		<DNL:GridColumn ColumnExpression="City"/>
		<DNL:GridColumn ColumnExpression="Region" Lookup="[['AK','Arkensas'],['CA','California'],['ID','Idaho'],['MT','Massachusetts'],['NM','New Mexico'],['OR','Oregon'],['WA','Washington'],['WY','Wyoming']]"/>
		<DNL:GridColumn ColumnExpression="PostalCode"/>
		<DNL:GridColumn ColumnExpression="Country"/>
		<DNL:GridColumn ColumnExpression="Phone"/>
		<DNL:GridColumn ColumnExpression="Fax"/>
	</Columns>
    </DNL:DbNetGrid>

Server-side script

///////////////////////////////////////////////////////////////
protected override void OnPreRender(EventArgs e)
///////////////////////////////////////////////////////////////
{
	base.OnPreRender(e);
	DbNetGrid1.FixedFilter = "country = @country";
	DbNetGrid1.FixedFilterParameters["@country"] = "USA";
}