Register the component libraries
<%@ Register TagPrefix="DNL" Assembly="DbNetLink.DbNetSuiteVS" Namespace="DbNetLink.DbNetSuiteVS" %>
Server Control
<DNL:DbNetEdit
id="DbNetEdit1"
runat="server"
ConnectionString="SamplesDatabase"
FromPart="customers">
<Columns>
<DNL:EditColumn ColumnExpression="CustomerID"/>
<DNL:EditColumn ColumnExpression="CompanyName"/>
<DNL:EditColumn ColumnExpression="ContactName"/>
<DNL:EditColumn ColumnExpression="ContactTitle"/>
<DNL:EditColumn ColumnExpression="Address"/>
<DNL:EditColumn ColumnExpression="City"/>
<DNL:EditColumn ColumnExpression="Region" Lookup="[['AK','Arkensas'],['CA','California'],['ID','Idaho'],['MT','Massachusetts'],['NM','New Mexico'],['OR','Oregon'],['WA','Washington'],['WY','Wyoming']]"/>
<DNL:EditColumn ColumnExpression="PostalCode"/>
<DNL:EditColumn ColumnExpression="Country"/>
<DNL:EditColumn ColumnExpression="Phone"/>
<DNL:EditColumn ColumnExpression="Fax"/>
</Columns>
</DNL:DbNetEdit>
Server-side script
///////////////////////////////////////////////////////////////
protected override void OnPreRender(EventArgs e)
///////////////////////////////////////////////////////////////
{
base.OnPreRender(e);
DbNetEdit1.FixedFilter = "country = @country";
DbNetEdit1.FixedFilterParameters["@country"] = "USA";
}