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";
}