Tags and page properties
<%@ Page Language="C#" MasterPageFile="~/Demo.master" AutoEventWireup="true" CodeFile="FilterRow.aspx.cs" Inherits="Filtering_FilterRow" %>
<%@ Register Assembly="DevExpress.Web.ASPxEditors.v8.1" Namespace="DevExpress.Web.ASPxEditors"
TagPrefix="dxe" %>
<%@ Register Assembly="DevExpress.Web.ASPxGridView.v8.1" Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dxwgv" %>
<asp:Content ID="Content1" ContentPlaceHolderID="phContent" Runat="Server">
<dxwgv:ASPxGridView ID="grid" ClientInstanceName="grid" runat="server" DataSourceID="AccessDataSource1" KeyFieldName="CustomerID" Width="100%">
<Columns>
<dxwgv:GridViewCommandColumn VisibleIndex="0">
<ClearFilterButton Visible="True">
</ClearFilterButton>
</dxwgv:GridViewCommandColumn>
<dxwgv:GridViewDataColumn FieldName="ContactName" VisibleIndex="1">
</dxwgv:GridViewDataColumn>
<dxwgv:GridViewDataColumn FieldName="CompanyName" VisibleIndex="2">
</dxwgv:GridViewDataColumn>
<dxwgv:GridViewDataColumn FieldName="City" VisibleIndex="3">
</dxwgv:GridViewDataColumn>
<dxwgv:GridViewDataColumn FieldName="Region" VisibleIndex="4">
</dxwgv:GridViewDataColumn>
<dxwgv:GridViewDataColumn FieldName="Country" VisibleIndex="5">
</dxwgv:GridViewDataColumn>
</Columns>
<Settings ShowFilterRow="True" ShowGroupPanel="True"/>
</dxwgv:ASPxGridView>
DataSource
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/nwind.mdb"
SelectCommand="SELECT * FROM [Customers]" DeleteCommand="DELETE FROM [Customers] WHERE [CustomerID] = ?" InsertCommand="INSERT INTO [Customers] ([CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" UpdateCommand="UPDATE [Customers] SET [CompanyName] = ?, [ContactName] = ?, [ContactTitle] = ?, [Address] = ?, [City] = ?, [Region] = ?, [PostalCode] = ?, [Country] = ?, [Phone] = ?, [Fax] = ? WHERE [CustomerID] = ?">
</asp:AccessDataSource>
</asp:Content>
|
Loading… |