|
|||||
|
|||||
<%@ Register TagPrefix="DNL" Assembly="DbNetLink.DbNetSuiteVS" Namespace="DbNetLink.DbNetSuiteVS" %>
FilterType
<asp:DropDownList ID="FilterType" runat="server" AutoPostBack="True">
<asp:ListItem Value="Simple" />
<asp:ListItem Value="Composite" />
</asp:DropDownList>
<DNL:DbNetGrid
ID="DbNetGrid1"
runat="server"
ConnectionString="SamplesDatabase"
FromPart="Orders" >
<Columns>
<DNL:GridColumn ColumnExpression="CustomerID" Label="Customer" Lookup="select customerid, companyname from customers" Filter="true" />
<DNL:GridColumn ColumnExpression="EmployeeID" Label="Employee" Lookup="select employeeid, lastname from employees" Filter="true" />
<DNL:GridColumn ColumnExpression="OrderDate" Label="Order Date" Filter="true" EditFormat="g" />
<DNL:GridColumn ColumnExpression="ShipVia" Label="Ship Via" Lookup="select shipperid, companyname from shippers" Filter="true" />
<DNL:GridColumn ColumnExpression="ShipCountry" Label="Ship Country" Filter="true" />
</Columns>
</DNL:DbNetGrid>
///////////////////////////////////////////////////////////////
protected override void OnLoad(EventArgs e)
///////////////////////////////////////////////////////////////
{
base.OnLoad(e);
DbNetGrid1.FilterColumnMode = (DbNetGrid.FilterColumnModeValues)Enum.Parse(typeof(DbNetGrid.FilterColumnModeValues), FilterType.SelectedValue, true);
}