<telerik:GridBoundColumn DataField="Status_Field" UniqueName="Status_Field" HeaderText="Status" FilterControlWidth="83px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="false"> <ColumnValidationSettings EnableRequiredFieldValidation="true"> <RequiredFieldValidator ErrorMessage="This field is required!" Display="Dynamic" ValidationGroup="NewRecordValidation"></RequiredFieldValidator> </ColumnValidationSettings></telerik:GridBoundColumn><telerik:RadGrid ID="RadGridActionItem" runat="server" AllowSorting="True" AllowPaging="true" AllowFilteringByColumn="True" OnNeedDataSource="RadGridActionItem_NeedDataSource" OnPageIndexChanged="RadGridActionItem_PageIndexChanged" OnItemCreated="RadGridAction_ItemCreated" OnDeleteCommand="RadGridActionItem_DeleteCommand" OnInsertCommand="RadGridActionItem_InsertCommand" OnBatchEditCommand="RadGrid1_BatchEditCommand" AllowAutomaticUpdates="True" AllowMultiRowEdit="True" OnItemDataBound="RadGridActionItem_ItemDataBound" Width="80%" HorizontalAlign="Center" PageSize="15" EnableViewState="true" Skin="Windows7"> <GroupingSettings CaseSensitive="false" /> <MasterTableView AutoGenerateColumns="false" ShowFooter="true" DataKeyNames="Action_Item_Id" ClientDataKeyNames="Action_Item_Id" CommandItemDisplay="Top" Width="100%" HorizontalAlign="Center" EditMode="Batch"> <BatchEditingSettings OpenEditingEvent="None" EditType="Row" /> <Columns> <telerik:GridNumericColumn DataField="Action_Item_Id" UniqueName="Action_Item_Id" HeaderText="Action Item ID" ForceExtractValue="Always" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridNumericColumn> <telerik:GridNumericColumn DataField="Result_Id" UniqueName="Result_Id" HeaderText="Result ID" FilterControlWidth="65px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridNumericColumn> <telerik:GridBoundColumn DataField="Related_Result_Id" UniqueName="Related_Result_Id" HeaderText="Related Result ID" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Status_Field" UniqueName="Status_Field" HeaderText="Status" FilterControlWidth="83px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="false"> <ColumnValidationSettings EnableRequiredFieldValidation="true"> <RequiredFieldValidator ErrorMessage="This field is required!" Display="Dynamic" ValidationGroup="NewRecordValidation"></RequiredFieldValidator> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Assigned_To" UniqueName="Assigned_To" HeaderText="Assigned To" FilterControlWidth="70px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn DataField="Open_Date" UniqueName="Open_Date" HeaderText="Open Date" FilterControlWidth="80px" AutoPostBackOnFilter="true" PickerType="DatePicker" EnableTimeIndependentFiltering="true" ShowFilterIcon="true" DataFormatString="{0:M/d/yyyy}"> </telerik:GridDateTimeColumn> <telerik:GridDateTimeColumn DataField="Due_Date" UniqueName="Due_Date" HeaderText="Due Date" FilterControlWidth="80px" AutoPostBackOnFilter="true" PickerType="DatePicker" EnableTimeIndependentFiltering="true" ShowFilterIcon="true" DataFormatString="{0:M/d/yyyy}"> </telerik:GridDateTimeColumn> <telerik:GridBoundColumn DataField="Title" UniqueName="Title" HeaderText="Title" FilterControlWidth="70px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> <ColumnValidationSettings EnableRequiredFieldValidation="true"> <RequiredFieldValidator ErrorMessage="This field is required!" Display="Dynamic" ValidationGroup="NewRecordValidation"></RequiredFieldValidator> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Source" UniqueName="Source" HeaderText="Source" FilterControlWidth="70px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> <ColumnValidationSettings EnableRequiredFieldValidation="true"> <RequiredFieldValidator ErrorMessage="Required!" Display="Dynamic" ValidationGroup="NewRecordValidation"></RequiredFieldValidator> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Employee_Id" UniqueName="Employee_Id" HeaderText="Employee ID" FilterControlWidth="70px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> <ColumnValidationSettings EnableRequiredFieldValidation="true"> <RequiredFieldValidator ErrorMessage="Required!" Display="Dynamic" ValidationGroup="NewRecordValidation"></RequiredFieldValidator> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="User_System_Id" UniqueName="User_System_Id" HeaderText="User System ID" FilterControlWidth="70px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> <ColumnValidationSettings EnableRequiredFieldValidation="true"> <RequiredFieldValidator ErrorMessage="Required!" Display="Dynamic" ValidationGroup="NewRecordValidation"></RequiredFieldValidator> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="System" UniqueName="System" HeaderText="System" FilterControlWidth="70px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> <ColumnValidationSettings EnableRequiredFieldValidation="true"> <RequiredFieldValidator ErrorMessage="Required!" Display="Dynamic" ValidationGroup="NewRecordValidation"></RequiredFieldValidator> </ColumnValidationSettings> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Comparison_Type" UniqueName="Comparison_Type" HeaderText="Comparison Type" FilterControlWidth="80px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Actual_Access_Level" UniqueName="Actual_Access_Level" HeaderText="Actual Access Level" FilterControlWidth="90px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Auth_Access_Level" UniqueName="Auth_Access_Level" HeaderText=" Auth Access Level" FilterControlWidth="90px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Investigation_Results" UniqueName="Investigation_Results" HeaderText="Investigation Results" FilterControlWidth="150px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Historical_Authorization_Ticket" UniqueName="Historical_Authorization_Ticket" HeaderText="Historical Auth Ticket" FilterControlWidth="100px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Historical_Provisioning_Ticket" UniqueName="Historical_Provisioning_Ticket" HeaderText="Historical Prov Ticket" FilterControlWidth="100px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Resolution_Steps" UniqueName="Resolution_Steps" HeaderText="Resolution Steps" FilterControlWidth="150px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Resolution_Authorization_Ticket" UniqueName="Resolution_Authorization_Ticket" HeaderText="Resolution Auth Ticket" FilterControlWidth="100px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Resolution_Provisioning_Ticket" UniqueName="Resolution_Provisioning_Ticket" HeaderText="Resolution Prov Ticket" FilterControlWidth="100px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Batch_Name" UniqueName="Batch_Name" HeaderText="Batch Name" FilterControlWidth="70px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="QC_Review" UniqueName="QC_Review" HeaderText="QC/Review" DataType="System.Boolean" AllowFiltering="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Reviewed_By" UniqueName="Reviewed_By" HeaderText="Reviewed_By" FilterControlWidth="80px" AutoPostBackOnFilter="true" CurrentFilterFunction="EqualTo" ShowFilterIcon="false"> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn DataField="Review_Date" UniqueName="Review_Date" HeaderText="Review Date" FilterControlWidth="80px" AutoPostBackOnFilter="true" PickerType="DatePicker" EnableTimeIndependentFiltering="true" ShowFilterIcon="true" EmptyDataText=" " DataFormatString="{0:M/d/yyyy}"> </telerik:GridDateTimeColumn> <telerik:GridDateTimeColumn DataField="Resolved_Date" UniqueName="Resolved_Date" HeaderText="Resolved Date" FilterControlWidth="80px" AutoPostBackOnFilter="true" PickerType="DatePicker" EnableTimeIndependentFiltering="true" ShowFilterIcon="true" DataFormatString="{0:M/d/yyyy}"> </telerik:GridDateTimeColumn> <telerik:GridButtonColumn Text="Delete" CommandName="Delete" ButtonType="ImageButton" ConfirmDialogType="RadWindow" ConfirmText="Are you sure you want to delete this action item?" /> </Columns> <SortExpressions> <telerik:GridSortExpression FieldName="Action_Item_Id" SortOrder="Descending" /> </SortExpressions> </MasterTableView> <ClientSettings> <ClientEvents OnRowContextMenu="RowContextMenu" /> <Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="true" FrozenColumnsCount="2"> </Scrolling> <Selecting AllowRowSelect="True"></Selecting> <ClientEvents OnRowDblClick="RowDblClick" /> </ClientSettings></telerik:RadGrid><telerik:RadDockLayout runat="server" ID="RadDockLayout1" OnSaveDockLayout="RadDockLayout1_SaveDockLayout" EnableViewState="false"> <div id="mainContainer" style="width: 100%; float:left; height:100%"> <div style="width:100%;"> <asp:Table ID="Table1" runat="server" Width="100%"> <asp:TableRow> <asp:TableCell Width="50%" Height="95%"> <telerik:RadDockZone ID="RadDockZone1" runat="server" CssClass="zone" Height="540px" BorderColor="#d7d7d7"> </telerik:RadDockZone> </asp:TableCell> <asp:TableCell Width="50%" Height="95%"> <telerik:RadDockZone ID="RadDockZone2" runat="server" CssClass="zone" Height="540px" BorderColor="#d7d7d7"> </telerik:RadDockZone> </asp:TableCell> </asp:TableRow> </asp:Table> </div> </div> </telerik:RadDockLayout>
<%
@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%
@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>
<!
DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html xmlns="http://www.w3.org/1999/xhtml">
<
head runat="server">
<title></title>
</
head>
<
body>
<form id="form1" runat="server">
<asp:ScriptManager ID="aspScript" runat="server">
</asp:ScriptManager>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [ProductID], [ProductName], [SupplierID], [CategoryID], [UnitsInStock], [UnitPrice] FROM [Products]">
</asp:SqlDataSource>
<telerik:RadGrid ID="grdTemplate" runat="server" DataSourceID="SqlDataSource1"
AutoGenerateColumns="true" ShowGroupPanel="True" Skin="Office2007" Height="500" Width="100%"
OnColumnCreated="grdTemplate_ColumnCreated">
<ClientSettings AllowColumnsReorder="False" AllowDragToGroup="True">
<Scrolling AllowScroll="True" UseStaticHeaders="True" />
</ClientSettings>
<MasterTableView AutoGenerateColumns="true" TableLayout="Fixed" ShowFooter="true" ShowGroupFooter="true" />
</telerik:RadGrid>
</form>
</
body>
</
html>
Code Behind
using
System;
using
System.Collections.Generic;
using
System.Web;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
Telerik.Web.UI;
public
partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
// Add the expression
grdTemplate.MasterTableView.GroupByExpressions.Add(
GridGroupByExpression.Parse("SupplierID Group By SupplierID"));
}
protected void grdTemplate_ColumnCreated(object sender, GridColumnCreatedEventArgs e)
{
// Determine the column type
if (e.Column is GridBoundColumn && e.Column.UniqueName == "UnitPrice")
{
// Set the column aggreagate
(e.Column
as GridBoundColumn).Aggregate = GridAggregateFunction.Sum;
}
}
}
<SortExpressions> <telerik:GridSortExpression FieldName="EventID" SortOrder="Descending" /> </SortExpressions>RadAjaxManager manager = RadAjaxManager.GetCurrent(this.Page);manager.ResponseScripts.Add("CloseWindowReload('" + gridReloadCommand + "','" + ((itemID == null) ? "-1" : itemID.ToString()) + "');");