or
<
telerik:RadGrid
ID
=
"RadGridEmployeeCost"
runat
=
"server"
AllowSorting
=
"True"
AllowPaging
=
"true"
AllowFilteringByColumn
=
"true"
CellSpacing
=
"0"
GridLines
=
"None"
HeaderStyle-Font-Bold
=
"true"
Skin
=
"Web20"
OnNeedDataSource
=
"RadGridEmployeeCost_NeedDataSource"
ShowGroupPanel
=
"true"
OnColumnCreated
=
"RadGridEmployeeCost_ColumnCreated"
>
<
ClientSettings
AllowDragToGroup
=
"True"
/>
</
telerik:RadGrid
>
protected void RadGridEmployeeCost_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
ObjCon.Open();
SqlCommand ObjCmd = new SqlCommand("SELECT name,address,TelPhone,EmailId,Qualification FROM WorkSummary", ObjCon);
ObjCmd.ExecuteNonQuery();
SqlDataAdapter ObjDa = new SqlDataAdapter(ObjCmd);
DataSet ds = new DataSet();
ObjDa.Fill(ds);
RadGridEmployeeCost.DataSource = ds;
}
}
protected void RadGridEmployeeCost_ColumnCreated(object sender, GridColumnCreatedEventArgs e)
{
if ((e.Column is GridBoundColumn && e.Column.UniqueName == "TelPhone" || e.Column.UniqueName == "EmailId" || e.Column.UniqueName == "Qualification"))
{
GridBoundColumn column = e.Column as GridBoundColumn;
column.AllowFiltering = false;
}
}
Private
Sub
SetFilters(
ByVal
grid
As
RadGrid)
grid.MasterTableView.AllowFilteringByColumn = gridConfiguration.EnableHeaderFiltering
If
gridConfiguration.EnableHeaderFiltering
Then
grid.MasterTableView.CommandItemTemplate =
New
RadGridCommandItemFilterTemplate
End
If
End
Sub
Friend
Class
RadGridCommandItemFilterTemplate
Implements
ITemplate
Public
showHideFilter
As
RadButton
Public
Sub
New
()
MyBase
.
New
()
End
Sub
Public
Sub
InstantiateIn(
ByVal
container
As
Control)
Implements
ITemplate.InstantiateIn
showHideFilter =
New
RadButton
With
{.ID =
"showHideFilter"
, .Text =
"Show / Hide Filters"
,
.CommandName =
"ShowHideFilters"
, .OnClientCheckedChanged =
"showHideFilters()"
}
container.Controls.Add(showHideFilter)
End
Sub
End
Class
<
telerik:RadScriptManager
ID
=
"ScriptManager"
runat
=
"server"
>
</
telerik:RadScriptManager
>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"ConfigureGrid"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"ConfigureGrid"
LoadingPanelID
=
"AjaxLoadingPanel"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
telerik:RadGrid
runat
=
"server"
ID
=
"ConfigureGrid"
GridLines
=
"None"
AutoGenerateColumns
=
"false"
Skin
=
"WebBlue"
/>
<
telerik:RadAjaxLoadingPanel
ID
=
"AjaxLoadingPanel"
runat
=
"server"
/>
<
asp:SqlDataSource
ID
=
"PrimaryDataSource"
runat
=
"server"
/>
</
form
>
<
script
type
=
"text/javascript"
>
function showFilterItem() {
var grid = $find("<%=ConfigureGrid.ClientID%>");
if (grid) {
grid.get_masterTableView().showFilterItem();
}
}
function hideFilterItem() {
var grid = $find("<%=ConfigureGrid.ClientID%>");
if (grid) {
grid.get_masterTableView().hideFilterItem();
}
}
function showHideFilters() {
var radButton = document.getElementById("showHideFilter");
if (radButton) {
if (radButton.checked) {
showFilterItem();
}
else {
hideFilterItem();
}
}
}
</
script
>
<
telerik:PivotGridAggregateField
DataField
=
"StatusText"
Aggregate
=
"Count"
Caption
=
"Counts"
UniqueName
=
"Counts"
IsHidden
=
"false"
>
</
telerik:PivotGridAggregateField
>
<
telerik:RadPivotGrid
ID
=
"RadPivotGrid_DataView"
runat
=
"server"
ConfigurationPanelSettings-DefaultDeferedLayoutUpdate
=
"false"
Height
=
"100%"
AggregatesPosition
=
"Rows"
AllowSorting
=
"True"
OnItemCommand
=
"RadPivotGrid_DataView_ItemCommand"
OnCellCreated
=
"RadPivotGrid_DataView_CellCreated"
DataSourceID
=
"Sql_Contract_Details"
EnableToolTips
=
"True"
EnableZoneContextMenu
=
"True"
EnableConfigurationPanel
=
"True"
OnFieldCreated
=
"RadPivotGrid_DataView_FieldCreated"
Skin
=
"Metro"
OnCellDataBound
=
"RadPivotGrid_DataView_CellDataBound"
Culture
=
"en-GB"
OnItemNeedCalculation
=
"RadPivotGrid_DataView_ItemNeedCalculation"
AllowPaging
=
"True"
PageSize
=
"30"
>
<
PagerStyle
ChangePageSizeButtonToolTip
=
"Change Page Size"
PageSizeControlType
=
"RadComboBox"
AlwaysVisible
=
"True"
/>
<
Fields
>...</
Fields
>
<
ClientSettings
EnableFieldsDragDrop
=
"True"
>
<
Scrolling
AllowVerticalScroll
=
"True"
></
Scrolling
>
</
ClientSettings
>
<
ConfigurationPanelSettings
EnableOlapTreeViewLoadOnDemand
=
"True"
DefaultDeferedLayoutUpdate
=
"True"
LayoutType
=
"OneByFour"
></
ConfigurationPanelSettings
>
</
telerik:RadPivotGrid
>
<ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True" EnableRowHoverStyle="True" AllowColumnHide="False">
<Selecting AllowRowSelect="False" />
<Resizing AllowColumnResize="True" AllowResizeToFit="True" ResizeGridOnColumnResize="False" />
<Scrolling AllowScroll="True" UseStaticHeaders="True" />
<ClientMessages DragToGroupOrReorder="Click the Header to Sort; Drag to Reorder; Right Click for Context Menu" />
</ClientSettings>
...
<
ColumnGroups
>
<
telerik:GridColumnGroup
HeaderText
=
"MHO Portal Access"
Name
=
"User"
HeaderStyle-HorizontalAlign
=
"Center"
></
telerik:GridColumnGroup
>
<
telerik:GridColumnGroup
HeaderText
=
"Census Tract Exclusions"
Name
=
"CT"
HeaderStyle-HorizontalAlign
=
"Center"
></
telerik:GridColumnGroup
>
<
telerik:GridColumnGroup
HeaderText
=
"Rental Listings"
Name
=
"Rental"
HeaderStyle-HorizontalAlign
=
"Center"
></
telerik:GridColumnGroup
>
<
telerik:GridColumnGroup
HeaderText
=
"Real Estate Professionals"
Name
=
"REP"
HeaderStyle-HorizontalAlign
=
"Center"
></
telerik:GridColumnGroup
>
</
ColumnGroups
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"MHA"
HeaderText
=
"MHA"
SortExpression
=
"MHA"
UniqueName
=
"MHA"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
FilterControlWidth
=
"75px"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"MHA_MHO_ID"
HeaderText
=
"MHA_MHO_ID"
SortExpression
=
"MHA_MHO_ID"
UniqueName
=
"MHA_MHO_ID"
Visible
=
"false"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Service_Name"
FilterControlAltText
=
"Filter Service_Name column"
HeaderTooltip
=
"Service"
HeaderText
=
"Service"
SortExpression
=
"Service_Name"
UniqueName
=
"Service_Name"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
FilterControlWidth
=
"75px"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Is_Primary"
FilterControlAltText
=
"Filter Is_Primary column"
HeaderTooltip
=
"Role"
HeaderText
=
"Role"
SortExpression
=
"Is_Primary"
UniqueName
=
"Is_Primary"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
FilterControlWidth
=
"75px"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"MHO_Name"
FilterControlAltText
=
"Filter MHO_Name column"
HeaderTooltip
=
"MHO Name"
HeaderText
=
"MHO Name"
SortExpression
=
"MHO_Name"
UniqueName
=
"MHO_Name"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
FilterControlWidth
=
"75px"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"POC"
HeaderText
=
"POC"
SortExpression
=
"POC"
UniqueName
=
"POC"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
Display
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Title"
HeaderText
=
"Title"
SortExpression
=
"Title"
UniqueName
=
"Title"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
Display
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Phone_Number"
HeaderText
=
"Phone"
SortExpression
=
"Phone_Number"
UniqueName
=
"Phone_Number"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
Display
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Email"
HeaderText
=
"Email"
SortExpression
=
"Email"
UniqueName
=
"Email"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
Display
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"First_Login"
HeaderText
=
"First Login"
ColumnGroupName
=
"User"
SortExpression
=
"First_Login"
UniqueName
=
"First_Login"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Last_Login"
HeaderText
=
"Last Login"
ColumnGroupName
=
"User"
SortExpression
=
"Last_Login"
UniqueName
=
"Last_Login"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CT_Submission"
HeaderText
=
"Submit"
ColumnGroupName
=
"CT"
SortExpression
=
"CT_Submission"
UniqueName
=
"CT_Submission"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CT_Total"
HeaderText
=
"Total"
ColumnGroupName
=
"CT"
SortExpression
=
"CT_Total"
UniqueName
=
"CT_Total"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CT_Included"
HeaderText
=
"In."
ColumnGroupName
=
"CT"
SortExpression
=
"CT_Included"
UniqueName
=
"CT_Included"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CT_Excluded"
HeaderText
=
"Ex."
ColumnGroupName
=
"CT"
SortExpression
=
"CT_Excluded"
UniqueName
=
"CT_Excluded"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CT_Neutral"
HeaderText
=
"NA"
ColumnGroupName
=
"CT"
SortExpression
=
"CT_Neutral"
UniqueName
=
"CT_Neutral"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CT_Percent_Excluded"
HeaderText
=
"% Ex"
ColumnGroupName
=
"CT"
SortExpression
=
"CT_Percent_Excluded"
UniqueName
=
"CT_Percent_Excluded"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"CT_Percent_Updated"
HeaderText
=
"% Updated"
ColumnGroupName
=
"CT"
SortExpression
=
"CT_Percent_Updated"
UniqueName
=
"CT_Percent_Updated"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Rental_Submission"
HeaderText
=
"Submit"
ColumnGroupName
=
"Rental"
SortExpression
=
"Rental_Submission"
UniqueName
=
"Rental_Submission"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Rental_Total"
HeaderText
=
"Total"
ColumnGroupName
=
"Rental"
SortExpression
=
"Rental_Total"
UniqueName
=
"Rental_Total"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Rental_Current"
HeaderText
=
"Current"
ColumnGroupName
=
"Rental"
SortExpression
=
"Rental_Current"
UniqueName
=
"Rental_Current"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"REP_Submission"
HeaderText
=
"Submit"
ColumnGroupName
=
"REP"
SortExpression
=
"REP_Submission"
UniqueName
=
"REP_Submission"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"REP_Total"
HeaderText
=
"Total"
ColumnGroupName
=
"REP"
SortExpression
=
"REP_Total"
UniqueName
=
"REP_Total"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"REP_Current"
HeaderText
=
"Current"
ColumnGroupName
=
"REP"
SortExpression
=
"REP_Current"
UniqueName
=
"REP_Current"
Visible
=
"True"
FilterControlWidth
=
"75px"
AutoPostBackOnFilter
=
"true"
CurrentFilterFunction
=
"Contains"
ShowFilterIcon
=
"False"
></
telerik:GridBoundColumn
>
</
Columns
>