I have a RadGrid:
<
telerik:RadGrid
ID
=
"radgridMachines"
runat
=
"server"
AllowSorting
=
"True"
AllowMultiRowSelection
=
"true"
AutoGenerateColumns
=
"False"
OnNeedDataSource
=
"radgridMachines_NeedDataSource"
OnItemDataBound
=
"radgridMachines_ItemDataBound"
EnableViewState
=
"false"
>
<
ClientSettings
EnablePostBackOnRowClick
=
"false"
>
<
Selecting
AllowRowSelect
=
"true"
UseClientSelectColumnOnly
=
"true"
/>
<
Scrolling
AllowScroll
=
"true"
UseStaticHeaders
=
"true"
/>
<
Resizing
AllowColumnResize
=
"true"
ResizeGridOnColumnResize
=
"true"
AllowResizeToFit
=
"true"
/>
<
ClientEvents
OnGridCreated
=
"SelectAndResizeAllRows"
OnRowSelected
=
"TogglePrintControls"
OnRowDeselected
=
"TogglePrintControls"
/>
</
ClientSettings
>
<
GroupingSettings
CaseSensitive
=
"false"
/>
<
SortingSettings
/>
<
MasterTableView
DataKeyNames
=
"CustomerID, CustomerName, PlantNumber, Route, MachineNumber, PlantName, MachineName, CustomerEquipmentID, TestPackage, PointID, Lubricant"
ClientDataKeyNames
=
""
AllowMultiColumnSorting
=
"true"
>
<
Columns
>
<%--Fit to Contents--%>
<
telerik:GridBoundColumn
UniqueName
=
"CustomerNumber"
DataField
=
"CustomerID"
DataType
=
"System.Int32"
HeaderText
=
"Cust #"
HeaderStyle-Width
=
"60px"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"PlantNumber"
DataField
=
"PlantNumber"
DataType
=
"System.Int32"
HeaderText
=
"Plant #"
HeaderStyle-Width
=
"60px"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"MachineNumber"
DataField
=
"MachineNumber"
DataType
=
"System.Int32"
HeaderText
=
"Mach #"
HeaderStyle-Width
=
"60px"
></
telerik:GridBoundColumn
>
<
telerik:GridClientSelectColumn
UniqueName
=
"SelectColumn"
ItemStyle-HorizontalAlign
=
"Center"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderStyle-Width
=
"60px"
/>
<%--Fit to Contents--%>
<
telerik:GridBoundColumn
UniqueName
=
"RouteNumber"
DataField
=
"Route"
HeaderText
=
"Route"
ItemStyle-HorizontalAlign
=
"Center"
HeaderStyle-HorizontalAlign
=
"Center"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"PlantName"
DataField
=
"PlantName"
HeaderText
=
"Plant Name"
ItemStyle-HorizontalAlign
=
"Center"
HeaderStyle-HorizontalAlign
=
"Center"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"MachineName"
DataField
=
"MachineName"
HeaderText
=
"Machine Name"
ItemStyle-HorizontalAlign
=
"Center"
HeaderStyle-HorizontalAlign
=
"Center"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"CustomerEquipmentID"
DataField
=
"CustomerEquipmentID"
HeaderText
=
"Machine ID"
ItemStyle-HorizontalAlign
=
"Center"
HeaderStyle-HorizontalAlign
=
"Center"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
UniqueName
=
"TestPackage"
DataField
=
"TestPackage"
HeaderText
=
"Test Package"
ItemStyle-HorizontalAlign
=
"Center"
HeaderStyle-HorizontalAlign
=
"Center"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"PointID"
Visible
=
"false"
></
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
When I load 2600 rows, the browser gives me the following error:
"A script on this page may be busy, or it may have stopped responding. You can stop the script now, open the script in the debugger, or let the script continue. Script: http://localhost:50820/ScriptR…8-VKUfdnFfZq18eaxA2&t=7c776dc1:652"
The OnGridCreated event looks like this:
function
SelectAndResizeAllRows(sender, eventArgs) {
var
rows = $find(
'<%= radgridMachines.ClientID%>'
).get_masterTableView().get_dataItems();
for
(
var
i = 0; i < rows.length; i++) {
rows[i].set_selected(
true
);
}
var
grid = $find(
"<%= radgridMachines.ClientID %>"
);
var
columns = grid.get_masterTableView().get_columns();
for
(
var
i = 0; i < 4; i++) {
//columns.length
columns[i].resizeToFit(
false
,
true
);
}
}
If I remove the first for loop, the grid loads properly. But I need to support selecting all rows. Is there another way to accomplish this? Why can't the grid handle this?
Thanks
I have a basic RadGrid control on a page. I only set the grid property AllowPaging="True" and the only Pager Style is <PagerStyle Mode="NextPrevAndNumeric" />. When the form loads up the paging is showing on 4 separate lines. I just want it to be on one line like all of the samples. Any ideas why this is happening? Do I need to apply CSS?
Hi,
I´m delaing with some trouble; here is the topic: I have a 3 nested radgrid:
<telerik:RadGrid ID="radGridEquipos" runat="server" ShowStatusBar="True" AutoGenerateColumns="False" AllowSorting="True" AllowPaging="True" OnDetailTableDataBind="radGridEquipos_DetailTableDataBind" OnNeedDataSource="radGridEquipos_NeedDataSource" Width="100%" GroupPanelPosition="Top" Skin="MetroTouch" Culture="es-MX" OnDataBound="radGridEquipos_DataBound" AllowFilteringByColumn="True" PageSize="15" OnSelectedIndexChanged="radGridEquipos_SelectedIndexChanged" AllowMultiRowSelection="True" MasterTableView-HierarchyLoadMode="ServerBind"> <PagerStyle AlwaysVisible="True" EnableSEOPaging="True" Mode="Slider" PageButtonCount="5"></PagerStyle> <ClientSettings> <ClientEvents OnRowSelected="itemSelected" /> <Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="true" FrozenColumnsCount="2" ScrollHeight="590"></Scrolling> <Selecting AllowRowSelect="True" /> </ClientSettings> <MasterTableView DataKeyNames="ID_Equipo" AllowMultiColumnSorting="True"> <DetailTables> <telerik:GridTableView DataKeyNames="ID_Equipo" Name="Sistema" Width="100%" AllowPaging="False"> <DetailTables> <telerik:GridTableView DataKeyNames="ID_Equipo" Name="Componente" Width="100%" AllowPaging="False"> <Columns> <telerik:GridBoundColumn SortExpression="ID_Equipo" HeaderText="ID" HeaderButtonType="TextButton" DataField="ID_Equipo" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="Denominacion" HeaderText="Componente" HeaderButtonType="TextButton" DataField="Denominacion" FilterControlWidth="100%"> </telerik:GridBoundColumn> </Columns> <PagerStyle AlwaysVisible="True" Mode="Slider" PageButtonCount="5" /> </telerik:GridTableView> </DetailTables> <Columns> <telerik:GridBoundColumn SortExpression="ID_Equipo" HeaderText="ID" HeaderButtonType="TextButton" DataField="ID_Equipo" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="Denominacion" HeaderText="Sistema" HeaderButtonType="TextButton" DataField="Denominacion" FilterControlWidth="100%"> </telerik:GridBoundColumn> </Columns> <PagerStyle AlwaysVisible="True" Mode="Slider" PageButtonCount="5" /> </telerik:GridTableView> </DetailTables> <Columns> <telerik:GridBoundColumn SortExpression="ID_Equipo" HeaderText="ID" HeaderButtonType="TextButton" DataField="ID_Equipo" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="Denominacion" HeaderText="Equipo" HeaderButtonType="TextButton" DataField="Denominacion" FilterControlWidth="100%"> </telerik:GridBoundColumn> </Columns> <PagerStyle AlwaysVisible="True" Mode="Slider" PageButtonCount="5" /> </MasterTableView> </telerik:RadGrid>
what I need is to get the id of whatever row is selected on the grid and nested grids.
Can you team help me please?​
I am trying to add Excel like filtering for a dynamic RadGrid. I found this example that shows filtering with client-side binding: http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/filtering/basic-filtering/defaultcs.aspx. However, I do not have GridBoundColumns because my RadGrid is dynamic. How do I go about adding Excel like filtering if I do not know the columns beforehand? Please show an example.
Thanks
RadAjaxManagerProxy - master and content page the dropdownlist shows twice after adding it in RadAjaxManagerProxy. for information see line code - 63
if i dont add it the selected index change doesnt fire/change.
what to achieve - when user change the dropdown from master page (all the way right top in video name - select framework, the content page information should be refreshed without full page refreshed( i have achieved it using RadAjaxManagerProxy). when i select the tab ​Rating model and click on add new record-> change perspective, it doesnt update the relevant text box,autopostback is not working if i dont add in Radajaxmanagerproxy.
if i add the line 63 and so on, it shows controls twice.
why and how to fix it.
please see attached video.
http://screencast.com/t/NwG04xhle​
attaching the code.
001.
Master page
002.
003.
<
form
id
=
"form1"
runat
=
"server"
>
004.
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
>
005.
<
Scripts
>
006.
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.Core.js"
/>
007.
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQuery.js"
/>
008.
</
Scripts
>
009.
</
telerik:RadScriptManager
>
010.
<
telerik:RadStyleSheetManager
ID
=
"RadStyleSheetManager1"
runat
=
"server"
>
011.
</
telerik:RadStyleSheetManager
>
012.
<
telerik:RadFormDecorator
ID
=
"FormDecorator1"
runat
=
"server"
DecoratedControls
=
"all"
DecorationZoneID
=
"decorationZone"
></
telerik:RadFormDecorator
>
013.
<
telerik:RadAjaxLoadingPanel
ID
=
"RadAjaxLoadingPanel1"
runat
=
"server"
></
telerik:RadAjaxLoadingPanel
>
014.
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
015.
016.
017.
<
div
style
=
"float:right"
>
018.
<
table
>
019.
<
tr
>
020.
<
td
>
021.
<
App:FrameworkControl
runat
=
"server"
ID
=
"FrameworkControl"
/>
022.
</
td
>
023.
<
td
>
024.
<
asp:HyperLink
ID
=
"HyperLink1"
Target
=
"_blank"
Text
=
"Navigate to Portfolio Analyzer"
runat
=
"server"
></
asp:HyperLink
>
025.
026.
</
td
>
027.
</
tr
>
028.
</
table
>
029.
030.
031.
</
div
>
032.
033.
034.
ConfigureRatingModel content page
035.
036.
<%@ Page Title="" Language="C#" MasterPageFile="~/Framework.Master" AutoEventWireup="true" CodeBehind="ConfigureRatingModel.aspx.cs" Inherits="FrameworkBuilderApp.WebUI.ConfigureRatingModel" %>
037.
<%@ Register TagPrefix="App" TagName="PerspectiveWeightingsControl" Src="~/UserControls/PerspectiveWeightingsControl.ascx" %>
038.
<%@ Register TagPrefix="App" TagName="SurveyModelControl" Src="~/UserControls/SurveyRatingModelControl.ascx" %>
039.
<
asp:Content
ID
=
"Content2"
ContentPlaceHolderID
=
"ContentPlaceHolder1"
runat
=
"server"
>
040.
<
link
href
=
"../SkinSlik/TabStrip.SkinSlik.css"
rel
=
"stylesheet"
/>
041.
<%--<
link
href
=
"../styles/base.css"
rel
=
"stylesheet"
/>--%>
042.
<
link
href
=
"../styles/default.css"
rel
=
"stylesheet"
/>
043.
044.
045.
046.
047.
<
telerik:RadAjaxManagerProxy
ID
=
"AjaxManagerProxy1"
runat
=
"server"
>
048.
<
AjaxSettings
>
049.
<
telerik:AjaxSetting
AjaxControlID
=
"rdComboFrameworklist"
>
050.
<
UpdatedControls
>
051.
<
telerik:AjaxUpdatedControl
ControlID
=
"rdComboFrameworklist"
/>
052.
</
UpdatedControls
>
053.
</
telerik:AjaxSetting
>
054.
<
telerik:AjaxSetting
AjaxControlID
=
"rdComboFrameworklist"
>
055.
<
UpdatedControls
>
056.
<
telerik:AjaxUpdatedControl
ControlID
=
"RadTabStrip1"
/>
057.
<
telerik:AjaxUpdatedControl
ControlID
=
"RadMultiPage1"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
/>
058.
<
telerik:AjaxUpdatedControl
ControlID
=
"PerspectiveWeightingsControl"
/>
059.
<
telerik:AjaxUpdatedControl
ControlID
=
"SurveyModelControl"
/>
060.
<
telerik:AjaxUpdatedControl
ControlID
=
"ddlPerpectiveClass"
/>
061.
</
UpdatedControls
>
062.
</
telerik:AjaxSetting
>
063.
<
telerik:AjaxSetting
AjaxControlID
=
"ddlPerpectiveClass"
>
064.
<
UpdatedControls
>
065.
<
telerik:AjaxUpdatedControl
ControlID
=
"txtSubperspectiveType"
/>
066.
<
telerik:AjaxUpdatedControl
ControlID
=
"txtSubperspectiveCode"
/>
067.
</
UpdatedControls
>
068.
</
telerik:AjaxSetting
>
069.
070.
</
AjaxSettings
>
071.
072.
</
telerik:RadAjaxManagerProxy
>
073.
074.
075.
076.
<
div
id
=
"example"
style
=
"width:98%; margin:0 auto;"
>
077.
<
div
class
=
"demo-content"
>
078.
<%-- <
telerik:RadAjaxPanel
runat
=
"server"
ID
=
"RadAjaxPanel1"
ClientEvents-OnRequestStart
=
"onRequestStart"
CssClass
=
"div-container no-bg"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
>--%>
079.
080.
<
telerik:RadTabStrip
ID
=
"RadTabStrip1"
Width
=
"100%"
MultiPageID
=
"RadMultiPage1"
Orientation
=
"HorizontalTop"
CssClass
=
"RadTabStrip_SkinSlik"
runat
=
"server"
SelectedIndex
=
"0"
>
081.
<
Tabs
>
082.
083.
<
telerik:RadTab
runat
=
"server"
PageViewID
=
"RadPageView1"
Text
=
"Perspective Weightings"
Selected
=
"True"
/>
084.
<
telerik:RadTab
runat
=
"server"
PageViewID
=
"RadPageView2"
Text
=
"Rating Model"
/>
085.
086.
</
Tabs
>
087.
088.
</
telerik:RadTabStrip
>
089.
<
telerik:RadMultiPage
runat
=
"server"
ID
=
"RadMultiPage1"
SelectedIndex
=
"0"
090.
CssClass
=
"multiPage"
Width
=
"100%"
>
091.
<
telerik:RadPageView
runat
=
"server"
ID
=
"RadPageView1"
>
092.
<
App:PerspectiveWeightingsControl
runat
=
"server"
ID
=
"PerspectiveWeightingsControl"
/>
093.
</
telerik:RadPageView
>
094.
<
telerik:RadPageView
runat
=
"server"
ID
=
"RadPageView2"
>
095.
<
App:SurveyModelControl
runat
=
"server"
ID
=
"SurveyModelControl"
/>
096.
</
telerik:RadPageView
>
097.
098.
099.
</
telerik:RadMultiPage
>
100.
101.
<%-- </
telerik:RadAjaxPanel
>--%>
102.
<%--<
telerik:RadCodeBlock
ID
=
"RadCodeBlock1"
runat
=
"server"
>
103.
<
script
type
=
"text/javascript"
>
104.
function onRequestStart(sender, args) {
105.
if (args.get_eventTarget().indexOf("Button") >= 0) {
106.
args.set_enableAjax(false);
107.
}
108.
}
109.
</
script
>
110.
</
telerik:RadCodeBlock
>--%>
111.
</
div
>
112.
</
div
>
113.
</
asp:Content
>
114.
115.
116.
SurveyRatingModelControl.ascx user control
117.
118.
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="SurveyRatingModelControl.ascx.cs" Inherits="FrameworkBuilderApp.UserControls.SurveyRatingModelControl" %>
119.
<
link
href
=
"../SkinSlik/Grid.SkinSlik.css"
rel
=
"stylesheet"
/>
120.
<
link
href
=
"../styles/Style.css"
rel
=
"stylesheet"
/>
121.
<
style
>
122.
.blink_me {
123.
-webkit-animation-name: blinker;
124.
-webkit-animation-duration: 3s;
125.
-webkit-animation-timing-function: linear;
126.
-webkit-animation-iteration-count: infinite;
127.
128.
-moz-animation-name: blinker;
129.
-moz-animation-duration: 3s;
130.
-moz-animation-timing-function: linear;
131.
-moz-animation-iteration-count: infinite;
132.
133.
animation-name: blinker;
134.
animation-duration: 3s;
135.
animation-timing-function: linear;
136.
animation-iteration-count: infinite;
137.
}
138.
139.
@-moz-keyframes blinker {
140.
0% { opacity: 1.0; }
141.
50% { opacity: 0.0; }
142.
100% { opacity: 1.0; }
143.
}
144.
145.
@-webkit-keyframes blinker {
146.
0% { opacity: 1.0; }
147.
50% { opacity: 0.0; }
148.
100% { opacity: 1.0; }
149.
}
150.
151.
@keyframes blinker {
152.
0% { opacity: 1.0; }
153.
50% { opacity: 0.0; }
154.
100% { opacity: 1.0; }
155.
}
156.
157.
158.
</
style
>
159.
<
style
type
=
"text/css"
>
160.
.hi {
161.
background-color: lightgray;
162.
opacity: 0.9;
163.
filter: Alpha(opacity=50); /* IE8 and earlier */
164.
}
165.
</
style
>
166.
<
div
style
=
"padding:0px 10px 10px;"
>
167.
<
div
style
=
"text-align:center;font-family:Arial;font-weight:bold;"
>
168.
<
h5
>Rating Model</
h5
>
169.
</
div
>
170.
171.
<
telerik:RadCodeBlock
ID
=
"RadCodeBlock2"
runat
=
"server"
>
172.
<
script
type
=
"text/javascript"
>
173.
var popUp;
174.
function PopUpShowing(sender, eventArgs) {
175.
popUp = eventArgs.get_popUp();
176.
var gridWidth = sender.get_element().offsetWidth;
177.
var gridHeight = sender.get_element().offsetHeight;
178.
var popUpWidth = popUp.style.width.substr(0, popUp.style.width.indexOf("px"));
179.
var popUpHeight = popUp.style.height.substr(0, popUp.style.height.indexOf("px"));
180.
popUp.style.left = ((gridWidth - popUpWidth) / 2 + sender.get_element().offsetLeft).toString() + "px";
181.
popUp.style.top = ((gridHeight - popUpHeight) / 2 + sender.get_element().offsetTop).toString() + "px";
182.
}
183.
</
script
>
184.
185.
</
telerik:RadCodeBlock
>
186.
<
telerik:RadCodeBlock
ID
=
"RadCodeBlock3"
runat
=
"server"
>
187.
<
script
type
=
"text/javascript"
>
188.
function RowDblClick(sender, eventArgs) {
189.
sender.get_masterTableView().editItem(eventArgs.get_itemIndexHierarchical());
190.
}
191.
</
script
>
192.
</
telerik:RadCodeBlock
>
193.
<
telerik:RadWindowManager
ID
=
"RadWindowManager1"
runat
=
"server"
></
telerik:RadWindowManager
>
194.
<%-- <
telerik:RadAjaxManagerProxy
ID
=
"AjaxManagerProxySurvey"
runat
=
"server"
>
195.
<
AjaxSettings
>
196.
197.
<
telerik:AjaxSetting
AjaxControlID
=
"ddlPerpectiveClass"
EventName
=
"SelectedIndexChanged"
>
198.
<
UpdatedControls
>
199.
<
telerik:AjaxUpdatedControl
ControlID
=
"txtSubperspectiveType"
/>
200.
<
telerik:AjaxUpdatedControl
ControlID
=
"txtSubperspectiveCode"
/>
201.
<
telerik:AjaxUpdatedControl
ControlID
=
"ddlPerpectiveClass"
/>
202.
</
UpdatedControls
>
203.
</
telerik:AjaxSetting
>
204.
205.
</
AjaxSettings
>
206.
207.
</
telerik:RadAjaxManagerProxy
>--%>
208.
<%-- <
telerik:RadAjaxLoadingPanel
ID
=
"RadAjaxLoadingPanel1"
runat
=
"server"
></
telerik:RadAjaxLoadingPanel
>
209.
<
telerik:RadAjaxPanel
runat
=
"server"
ID
=
"RadAjaxPanel1"
ClientEvents-OnRequestStart
=
"onRequestStart"
CssClass
=
"div-container no-bg"
LoadingPanelID
=
"RadAjaxLoadingPanel1"
>--%>
210.
<
telerik:RadGrid
ID
=
"gridRatingModel"
AllowPaging
=
"True"
PageSize
=
"5"
OnNeedDataSource
=
"gridRatingModel_NeedDataSource"
OnItemCommand
=
"gridRatingModel_ItemCommand"
OnItemCreated
=
"gridRatingModel_ItemCreated"
OnDeleteCommand
=
"gridRatingModel_DeleteCommand"
OnInsertCommand
=
"gridRatingModel_InsertCommand"
OnUpdateCommand
=
"gridRatingModel_UpdateCommand"
OnItemDataBound
=
"gridRatingModel_ItemDataBound"
AllowSorting
=
"true"
runat
=
"server"
>
211.
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
></
PagerStyle
>
212.
<
ClientSettings
>
213.
<
Scrolling
AllowScroll
=
"True"
UseStaticHeaders
=
"True"
SaveScrollPosition
=
"true"
FrozenColumnsCount
=
"2"
></
Scrolling
>
214.
215.
</
ClientSettings
>
216.
<
ClientSettings
>
217.
<
ClientEvents
OnRowDblClick
=
"RowDblClick"
></
ClientEvents
>
218.
</
ClientSettings
>
219.
220.
<
ExportSettings
ExportOnlyData
=
"true"
HideStructureColumns
=
"true"
OpenInNewWindow
=
"true"
IgnorePaging
=
"true"
></
ExportSettings
>
221.
<
MasterTableView
EditMode
=
"EditForms"
CommandItemDisplay
=
"Top"
CommandItemSettings-ShowRefreshButton
=
"false"
DataKeyNames
=
"ID"
AutoGenerateColumns
=
"false"
InsertItemDisplay
=
"Top"
222.
InsertItemPageIndexAction
=
"ShowItemOnFirstPage"
>
223.
<
CommandItemSettings
ShowExportToCsvButton
=
"true"
ShowExportToExcelButton
=
"true"
ShowExportToPdfButton
=
"true"
ShowExportToWordButton
=
"true"
/>
224.
225.
<
Columns
>
226.
227.
228.
<
telerik:GridBoundColumn
HeaderText
=
"ID"
DataField
=
"ID"
ReadOnly
=
"True"
229.
UniqueName
=
"ID"
Display
=
"False"
>
230.
</
telerik:GridBoundColumn
>
231.
<
telerik:GridBoundColumn
HeaderText
=
"SubPerspectiveID"
DataField
=
"SubPerspectiveID"
ReadOnly
=
"True"
232.
UniqueName
=
"SubPerspectiveID"
Display
=
"false"
>
233.
</
telerik:GridBoundColumn
>
234.
235.
236.
<
telerik:GridBoundColumn
HeaderText
=
"Perspective Category"
ItemStyle-Width
=
"100px"
DataField
=
"ModelType"
UniqueName
=
"ModelType"
>
237.
<
HeaderStyle
Width
=
"100px"
/>
238.
</
telerik:GridBoundColumn
>
239.
240.
<
telerik:GridBoundColumn
HeaderText
=
"Perspective"
ItemStyle-Width
=
"100px"
DataField
=
"PerpectiveClass"
UniqueName
=
"PerpectiveClass"
>
241.
<
HeaderStyle
Width
=
"100px"
/>
242.
</
telerik:GridBoundColumn
>
243.
244.
<
telerik:GridBoundColumn
HeaderText
=
"Sub Perspective"
DataField
=
"HintSubPerspective"
Display
=
"false"
UniqueName
=
"HintExport"
>
245.
<
HeaderStyle
Width
=
"100px"
/>
246.
</
telerik:GridBoundColumn
>
247.
<
telerik:GridBoundColumn
HeaderText
=
"Question"
DataField
=
"Question"
Display
=
"false"
UniqueName
=
"QuestionExport"
>
248.
<
HeaderStyle
Width
=
"150px"
/>
249.
</
telerik:GridBoundColumn
>
250.
<
telerik:GridBoundColumn
HeaderText
=
"Sub Perspective"
ItemStyle-Width
=
"100px"
DataField
=
"HintSubPerspective"
UniqueName
=
"Hint"
>
251.
<
HeaderStyle
Width
=
"100px"
/>
252.
</
telerik:GridBoundColumn
>
253.
<
telerik:GridBoundColumn
HeaderText
=
"Question"
ItemStyle-Width
=
"150px"
DataField
=
"Question"
UniqueName
=
"Question"
>
254.
<
HeaderStyle
Width
=
"150px"
/>
255.
</
telerik:GridBoundColumn
>
256.
<
telerik:GridBoundColumn
HeaderText
=
"DefaultComment"
ItemStyle-Width
=
"150px"
DataField
=
"DefaultComment"
UniqueName
=
"DefaultComment"
>
257.
<
HeaderStyle
Width
=
"150px"
/>
258.
</
telerik:GridBoundColumn
>
259.
<
telerik:GridBoundColumn
HeaderText
=
"Subperspective Type"
Display
=
"false"
DataField
=
"SubperspectiveType"
UniqueName
=
"SubperspectiveType"
>
260.
</
telerik:GridBoundColumn
>
261.
262.
<
telerik:GridBoundColumn
HeaderText
=
"Weighting"
HeaderStyle-Width
=
"100px"
DataField
=
"Weighting"
UniqueName
=
"Weighting"
>
263.
</
telerik:GridBoundColumn
>
264.
<
telerik:GridBoundColumn
HeaderText
=
"Rating Factor 1"
ItemStyle-Width
=
"100px"
DataField
=
"RatingFactor1"
UniqueName
=
"RatingFactor1"
>
265.
<
HeaderStyle
Width
=
"70px"
/>
266.
</
telerik:GridBoundColumn
>
267.
<
telerik:GridBoundColumn
HeaderText
=
"Rating Factor 2"
ItemStyle-Width
=
"150px"
DataField
=
"RatingFactor2"
UniqueName
=
"RatingFactor2"
>
268.
<
HeaderStyle
Width
=
"70px"
/>
269.
</
telerik:GridBoundColumn
>
270.
<
telerik:GridBoundColumn
HeaderText
=
"Rating Factor 3"
ItemStyle-Width
=
"150px"
DataField
=
"RatingFactor3"
UniqueName
=
"RatingFactor3"
>
271.
<
HeaderStyle
Width
=
"70px"
/>
272.
</
telerik:GridBoundColumn
>
273.
<
telerik:GridBoundColumn
HeaderText
=
"Rating Factor 4"
ItemStyle-Width
=
"150px"
DataField
=
"RatingFactor4"
UniqueName
=
"RatingFactor4"
>
274.
<
HeaderStyle
Width
=
"70px"
/>
275.
</
telerik:GridBoundColumn
>
276.
<
telerik:GridBoundColumn
HeaderText
=
"Rating Factor 5"
ItemStyle-Width
=
"150px"
DataField
=
"RatingFactor5"
UniqueName
=
"RatingFactor5"
>
277.
<
HeaderStyle
Width
=
"70px"
/>
278.
</
telerik:GridBoundColumn
>
279.
280.
<
telerik:GridEditCommandColumn
UniqueName
=
"EditColumn"
ButtonType
=
"ImageButton"
HeaderText
=
"Edit"
>
281.
<
HeaderStyle
Width
=
"70px"
/>
282.
</
telerik:GridEditCommandColumn
>
283.
<
telerik:GridButtonColumn
ConfirmText
=
"Delete this Perspective?"
ConfirmDialogType
=
"RadWindow"
284.
ConfirmTitle
=
"Delete"
ButtonType
=
"ImageButton"
CommandName
=
"Delete"
Text
=
"Delete"
UniqueName
=
"DeleteColumn"
HeaderText
=
"Delete"
>
285.
<
HeaderStyle
Width
=
"70px"
/>
286.
<
ItemStyle
Width
=
"70px"
/>
287.
</
telerik:GridButtonColumn
>
288.
</
Columns
>
289.
<
EditFormSettings
EditFormType
=
"Template"
>
290.
<
FormTemplate
>
291.
<
table
id
=
"Table2"
cellspacing
=
"2"
cellpadding
=
"1"
width
=
"100%"
border
=
"0"
rules
=
"none"
292.
style
=
"border-collapse: collapse;"
>
293.
<
tr
class
=
"EditFormHeader"
>
294.
295.
<
td
align
=
"left"
>
296.
<
asp:Button
ID
=
"btnUpdate"
Text='<%# (Container is GridEditFormInsertItem) ? "Save" : "Save" %>'
297.
runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'></
asp:Button
>
298.
<
asp:Button
ID
=
"btnCancel"
Text
=
"Cancel"
runat
=
"server"
CausesValidation
=
"False"
299.
CommandName
=
"Cancel"
></
asp:Button
>
300.
</
td
>
301.
302.
<
td
></
td
>
303.
<
td
></
td
>
304.
</
tr
>
305.
<
tr
>
306.
<
td
>
307.
<
table
id
=
"Table3"
width
=
"400px"
border
=
"0"
class
=
"module"
>
308.
309.
<
tr
style
=
"height:40px"
>
310.
<
td
class
=
"txtright"
>Perspective Category:
311.
</
td
>
312.
<
td
>
313.
314.
<
telerik:RadDropDownList
ID
=
"ddlPerspectiveCategory"
runat
=
"server"
OnSelectedIndexChanged
=
"ddlPerspectiveCategory_SelectedIndexChanged"
AutoPostBack
=
"true"
315.
316.
TabIndex
=
"7"
317.
/>
318.
<
asp:HiddenField
ID
=
"hiddenPerspectiveCateory"
runat
=
"server"
Value='<%# DataBinder.Eval(Container.DataItem, "ModelType") %>' />
319.
</
td
>
320.
</
tr
>
321.
<
tr
style
=
"height:40px"
>
322.
<
td
class
=
"txtright"
>Perspective:
323.
</
td
>
324.
<
td
>
325.
<
telerik:RadDropDownList
ID
=
"ddlPerpectiveClass"
runat
=
"server"
OnSelectedIndexChanged
=
"ddlPerpectiveClass_SelectedIndexChanged"
AutoPostBack
=
"true"
326.
327.
TabIndex
=
"8"
328.
/>
329.
<
asp:HiddenField
ID
=
"hiddenPerspectiveClass"
runat
=
"server"
Value='<%# Bind("PerpectiveClass") %>' />
330.
</
td
>
331.
</
tr
>
332.
<
tr
style
=
"height:40px"
>
333.
<
td
class
=
"txtright"
>Sub-Perspective:
334.
</
td
>
335.
<
td
>
336.
<
telerik:RadTextBox
ID
=
"txtHint"
runat
=
"server"
Text='<%# Bind("Hint") %>' TextMode="MultiLine" TabIndex="2" Rows="2" Columns="40"></
telerik:RadTextBox
>
337.
338.
</
td
>
339.
</
tr
>
340.
<
tr
style
=
"height:40px;"
>
341.
<
td
rowspan
=
"2"
class
=
"txtright"
>Question:
342.
</
td
>
343.
<
td
rowspan
=
"2"
>
344.
<
telerik:RadTextBox
ID
=
"TextBox5"
Text='<%# Bind("Question") %>' runat="server" TextMode="MultiLine"
345.
Rows="5" Columns="40" TabIndex="6">
346.
</
telerik:RadTextBox
>
347.
<
asp:HiddenField
ID
=
"SubPerspectiveID"
runat
=
"server"
Value='<%# Bind("SubPerspectiveID") %>' />
348.
</
td
>
349.
</
tr
>
350.
351.
352.
353.
<
tr
>
354.
<
td
colspan
=
"2"
></
td
>
355.
</
tr
>
356.
357.
358.
</
table
>
359.
</
td
>
360.
361.
<
td
style
=
"vertical-align: top"
>
362.
<
table
id
=
"Table4"
cellspacing
=
"1"
cellpadding
=
"1"
width
=
"450px"
border
=
"0"
class
=
"module"
>
363.
364.
<
tr
style
=
"height:40px"
>
365.
<
td
class
=
"txtright"
>Weight:
366.
</
td
>
367.
<
td
>
368.
<
telerik:RadNumericTextBox
ID
=
"txtWeighting"
Text='<%# Bind( "Weighting") %>' runat="server" TabIndex="5" ></
telerik:RadNumericTextBox
>
369.
370.
</
td
>
371.
</
tr
>
372.
<
tr
style
=
"height:40px"
>
373.
<
td
class
=
"txtright"
>Perspective Code:
374.
</
td
>
375.
<
td
>
376.
<
telerik:RadTextBox
ID
=
"txtSubperspectiveType"
Enabled
=
"false"
ReadOnly
=
"true"
Text='<%# Bind( "SubperspectiveType") %>' runat="server" TabIndex="9">
377.
</
telerik:RadTextBox
>
378.
</
td
>
379.
</
tr
>
380.
381.
<
tr
style
=
"height:40px"
>
382.
<
td
class
=
"txtright"
>Sub-Perspective Code:
383.
</
td
>
384.
<
td
>
385.
<
telerik:RadTextBox
ID
=
"txtSubperspectiveCode"
Enabled
=
"false"
ReadOnly
=
"true"
Text='<%# Bind( "SubPerspectiveID") %>' runat="server" TabIndex="9">
386.
</
telerik:RadTextBox
>
387.
</
td
>
388.
</
tr
>
389.
<
tr
style
=
"height:40px;"
>
390.
<
td
class
=
"txtright"
>Default Comment:
391.
</
td
>
392.
<
td
>
393.
<
telerik:RadTextBox
ID
=
"RadTextBox1"
Text='<%# Bind("DefaultComment") %>' runat="server" TextMode="MultiLine"
394.
Rows="4" Columns="40" TabIndex="6">
395.
</
telerik:RadTextBox
>
396.
</
td
>
397.
</
tr
>
398.
399.
400.
</
table
>
401.
</
td
>
402.
<
td
style
=
"vertical-align: top"
>
403.
<
table
id
=
"Table1"
cellspacing
=
"1"
cellpadding
=
"1"
width
=
"350px"
border
=
"0"
class
=
"module"
>
404.
<
tr
style
=
"height:40px"
>
405.
<
td
class
=
"txtright"
>Rating 1:
406.
</
td
>
407.
408.
<
td
>
409.
<
telerik:RadTextBox
ID
=
"TextBox1"
Text='<%# Bind("RatingFactor1") %>' runat="server" TextMode="MultiLine"
410.
Rows="2" Columns="40" TabIndex="4">
411.
</
telerik:RadTextBox
>
412.
</
td
>
413.
</
tr
>
414.
<
tr
style
=
"height:40px"
>
415.
<
td
class
=
"txtright"
>Rating 2:
416.
</
td
>
417.
418.
<
td
>
419.
<
telerik:RadTextBox
ID
=
"TextBox6"
Text='<%# Bind("RatingFactor2") %>' runat="server" TextMode="MultiLine"
420.
Rows="2" Columns="40" TabIndex="3">
421.
</
telerik:RadTextBox
>
422.
</
td
>
423.
</
tr
>
424.
<
tr
style
=
"height:40px"
>
425.
<
td
class
=
"txtright"
>Rating 3:
426.
</
td
>
427.
428.
<
td
>
429.
<
telerik:RadTextBox
ID
=
"TextBox2"
Text='<%# Bind("RatingFactor3") %>' runat="server" TextMode="MultiLine"
430.
Rows="2" Columns="40" TabIndex="2">
431.
</
telerik:RadTextBox
>
432.
</
td
>
433.
</
tr
>
434.
<
tr
style
=
"height:40px"
>
435.
<
td
class
=
"txtright"
>Rating 4:
436.
</
td
>
437.
438.
<
td
>
439.
<
telerik:RadTextBox
ID
=
"TextBox3"
Text='<%# Bind("RatingFactor4") %>' runat="server" TextMode="MultiLine"
440.
Rows="2" Columns="40" TabIndex="1">
441.
</
telerik:RadTextBox
>
442.
</
td
>
443.
</
tr
>
444.
<
tr
style
=
"height:40px"
>
445.
<
td
class
=
"txtright"
>Rating 5:
446.
</
td
>
447.
448.
<
td
>
449.
<
telerik:RadTextBox
ID
=
"TextBox4"
Text='<%# Bind("RatingFactor5") %>' runat="server" TextMode="MultiLine"
450.
Rows="2" Columns="40" TabIndex="10">
451.
</
telerik:RadTextBox
>
452.
</
td
>
453.
</
tr
>
454.
</
table
>
455.
</
td
>
456.
</
tr
>
457.
458.
</
table
>
459.
</
FormTemplate
>
460.
</
EditFormSettings
>
461.
</
MasterTableView
>
462.
</
telerik:RadGrid
>
463.
<
table
style
=
"height:30px;"
>
464.
<
tr
id
=
"trAlert"
runat
=
"server"
>
465.
<
td
colspan
=
"4"
><
span
runat
=
"server"
id
=
"spAlert"
class
=
"blink_me"
style
=
"color:red;text-align:right;font-weight:bold"
><
asp:Label
ID
=
"lblerror"
runat
=
"server"
></
asp:Label
></
span
></
td
>
466.
467.
</
tr
>
468.
</
table
>
469.
<%-- </
telerik:RadAjaxPanel
>--%>
470.
<%-- <
telerik:RadCodeBlock
ID
=
"RadCodeBlock1"
runat
=
"server"
>
471.
<
script
type
=
"text/javascript"
>
472.
function onRequestStart(sender, args) {
473.
if (args.get_eventTarget().indexOf("Button") >= 0) {
474.
args.set_enableAjax(false);
475.
}
476.
}
477.
</
script
>
478.
</
telerik:RadCodeBlock
>--%>
479.
</
div
>
Hai, i got a problem.
I am following this demo to show a Edit Form on RadGrid. But i can't display the Edit Form when i click Edit button.
This is the code i am using:
<
telerik:RadGrid
ID
=
"radGridTarget"
GridLines
=
"None"
runat
=
"server"
AllowAutomaticDeletes
=
"True"
AllowAutomaticInserts
=
"True"
PageSize
=
"10"
Width
=
"500px"
OnItemDeleted
=
"radGridTarget_ItemDeleted"
OnItemInserted
=
"radGridTarget_ItemInserted"
OnItemUpdated
=
"radGridTarget_ItemUpdated"
AllowAutomaticUpdates
=
"True"
AllowPaging
=
"True"
AutoGenerateColumns
=
"False"
onneeddatasource
=
"radGridTarget_NeedDataSource"
onitemcommand
=
"radGridTarget_ItemCommand"
>
<
MasterTableView
CommandItemDisplay
=
"Top"
HorizontalAlign
=
"NotSet"
AutoGenerateColumns
=
"False"
>
<
NoRecordsTemplate
>
<
table
width
=
"100%"
border
=
"0"
cellpadding
=
"20"
cellspacing
=
"20"
>
<
tr
>
<
td
align
=
"center"
>
<
h2
style
=
"color:Black"
>No Data Found.</
h2
>
</
td
>
</
tr
>
</
table
>
</
NoRecordsTemplate
>
<
PagerStyle
Mode
=
"NumericPages"
/>
<
Columns
>
<
telerik:GridEditCommandColumn
HeaderStyle-Width
=
"10%"
></
telerik:GridEditCommandColumn
>
<
telerik:GridBoundColumn
DataField
=
"Sales"
HeaderText
=
"NIK Sales"
Display
=
"false"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Target"
DefaultInsertValue
=
"Target"
HeaderStyle-Width
=
"20%"
UniqueName
=
"Target"
DataField
=
"Target"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Amount"
HeaderStyle-Width
=
"20%"
HeaderText
=
"Target Amount"
SortExpression
=
"Amount"
UniqueName
=
"Amount"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Campaign"
HeaderText
=
"Campaign"
UniqueName
=
"Campaign"
HeaderStyle-Width
=
"20%"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"StartDate"
HeaderText
=
"StartDate"
UniqueName
=
"StartDate"
HeaderStyle-Width
=
"10%"
></
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"EndDate"
HeaderText
=
"EndDate"
UniqueName
=
"EndDate"
HeaderStyle-Width
=
"10%"
></
telerik:GridBoundColumn
>
<
telerik:GridButtonColumn
ConfirmText
=
"Delete this target?"
ConfirmDialogType
=
"RadWindow"
ConfirmTitle
=
"Delete"
HeaderText
=
"Delete"
HeaderStyle-Width
=
"10%"
ButtonType
=
"ImageButton"
CommandName
=
"Delete"
Text
=
"Delete"
UniqueName
=
"DeleteColumn"
>
</
telerik:GridButtonColumn
>
</
Columns
>
<
EditFormSettings
EditFormType
=
"Template"
>
<
FormTemplate
>
<
table
id
=
"tableFormEdit"
cellspacing
=
"2"
cellpadding
=
"1"
width
=
"100%"
border
=
"0"
rules
=
"none"
style
=
"border-collapse: collapse;"
>
<
tr
class
=
"EditFormHeader"
>
<
td
colspan
=
"2"
>
<
b
>Target Details</
b
>
</
td
>
</
tr
>
<
tr
>
<
td
>
<
table
id
=
"Table3"
width
=
"450px"
border
=
"0"
class
=
"module"
>
<
tr
>
<
td
>Target:
</
td
>
<
td
>
<
telerik:RadDropDownList
ID
=
"radDropDownTargetList"
EmptyMessage
=
"Target"
runat
=
"server"
SelectedItem='<%# Bind("Target") %>'
DataSource='<%# PopulateTargetList() %>' DataTextField="Desc" DataValueField="Value" Skin="MetroTouch" TabIndex="5" >
</
telerik:RadDropDownList
>
</
td
>
</
tr
>
<
tr
>
<
td
>Amount:
</
td
>
<
td
>
<
telerik:RadNumericTextBox
ID
=
"radTextAmount"
runat
=
"server"
EmptyMessage
=
"Amount"
Text='<%# Bind("Amount") %>' TabIndex="6"
Skin="MetroTouch" ShowButton="false" ShowSpinButtons="false">
<
NumberFormat
GroupSeparator
=
""
DecimalDigits
=
"0"
/>
</
telerik:RadNumericTextBox
>
</
td
>
</
tr
>
<
tr
>
<
td
>Campaign:
</
td
>
<
td
>
<
telerik:RadDropDownList
ID
=
"radDropDownCampaignList"
EmptyMessage
=
"Campaign"
runat
=
"server"
SelectedItem='<%# Bind("Campaign") %>'
DataTextField="Desc" DataValueField="Value" Skin="MetroTouch" TabIndex="7" >
</
telerik:RadDropDownList
>
</
td
>
</
tr
>
<
tr
>
<
td
>Start Date:
</
td
>
<
td
>
<
telerik:RadDatePicker
ID
=
"radStartDate"
runat
=
"server"
Culture
=
"en-US"
TabIndex
=
"8"
Skin
=
"MetroTouch"
>
<
Calendar
ID
=
"Calendar1"
runat
=
"server"
>
<
SpecialDays
>
<
telerik:RadCalendarDay
Repeatable
=
"Today"
ItemStyle-BackColor
=
"Yellow"
>
</
telerik:RadCalendarDay
>
</
SpecialDays
>
</
Calendar
>
<
DateInput
DisplayDateFormat
=
"d/M/yyyy"
DateFormat
=
"d/M/yyyy"
LabelWidth
=
"40%"
TabIndex
=
"6"
>
</
DateInput
>
</
telerik:RadDatePicker
>
</
td
>
</
tr
>
<
tr
>
<
td
>End Date:
</
td
>
<
td
>
<
telerik:RadDatePicker
ID
=
"radEndDate"
runat
=
"server"
Culture
=
"en-US"
TabIndex
=
"9"
Skin
=
"MetroTouch"
>
<
Calendar
ID
=
"Calendar2"
runat
=
"server"
>
<
SpecialDays
>
<
telerik:RadCalendarDay
Repeatable
=
"Today"
ItemStyle-BackColor
=
"Yellow"
>
</
telerik:RadCalendarDay
>
</
SpecialDays
>
</
Calendar
>
<
DateInput
DisplayDateFormat
=
"d/M/yyyy"
DateFormat
=
"d/M/yyyy"
LabelWidth
=
"40%"
TabIndex
=
"6"
>
</
DateInput
>
</
telerik:RadDatePicker
>
</
td
>
</
tr
>
</
table
>
</
td
>
</
tr
>
<
tr
>
<
td
colspan
=
"2"
></
td
>
</
tr
>
<
tr
>
<
td
></
td
>
<
td
></
td
>
</
tr
>
<
tr
>
<
td
align
=
"right"
colspan
=
"2"
>
<
asp:Button
ID
=
"btnUpdate"
Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'
runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>' TabIndex="10"></
asp:Button
>
<
asp:Button
ID
=
"btnCancel"
Text
=
"Cancel"
runat
=
"server"
CausesValidation
=
"False"
TabIndex
=
"11"
CommandName
=
"Cancel"
></
asp:Button
>
</
td
>
</
tr
>
</
table
>
</
FormTemplate
>
</
EditFormSettings
>
</
MasterTableView
>
<
ClientSettings
AllowKeyboardNavigation
=
"true"
>
</
ClientSettings
>
</
telerik:RadGrid
>
protected
void
radGridTarget_ItemCommand(
object
sender, GridCommandEventArgs e)
{
if
(e.CommandName == RadGrid.InitInsertCommandName)
//"Add new" button clicked
{
GridEditCommandColumn editColumn = (GridEditCommandColumn)radGridTarget.MasterTableView.GetColumn(
"EditCommandColumn"
);
editColumn.Visible =
false
;
}
else
if
(e.CommandName == RadGrid.RebindGridCommandName && e.Item.OwnerTableView.IsItemInserted)
{
e.Canceled =
true
;
}
else
{
GridEditCommandColumn editColumn = (GridEditCommandColumn)radGridTarget.MasterTableView.GetColumn(
"EditCommandColumn"
);
if
(!editColumn.Visible)
editColumn.Visible =
true
;
}
}
Where part that i gone wrong?
Please help me. Thank you
Hi there is a RadComboBox inside EditItemTemplate of RadGrid along with a Button.
I am using _ItemsRequested event just to do the search in RadComboBox but not loading the whole list into it on click of RadComboBox.
Current functionality is:
When user click on textarea of RadComboBox, type/key-in any thing, then only the Combo binds the searched related Items into it.
Now I want to get below functionality on button click:
when user click on textarea of RadComboBox, type/key-in any thing, and click on button..then only the Combo shall bind the searched related Items into it.
Please someone reply how to achieve it ?
Below is code of my Current functionality:
<
telerik:RadGrid
ID
=
"RGGSTAcCode"
runat
=
"server"
ShowFooter
=
"True"
GroupingEnabled
=
"False"
ShowStatusBar
=
"true"
EmptyDataText
=
"No record available."
AllowAutomaticInserts
=
"False"
AllowAutomaticUpdates
=
"False"
AllowAutomaticDeletes
=
"true"
OnNeedDataSource
=
"RGGSTAcCode_NeedDataSource"
OnItemDataBound
=
"RGGSTAcCode_ItemDataBound"
OnInsertCommand
=
"RGGSTAcCode_InsertCommand"
OnDeleteCommand
=
"RGGSTAcCode_DeleteCommand"
OnUpdateCommand
=
"RGGSTAcCode_UpdateCommand"
OnItemCommand
=
"RGGSTAcCode_ItemCommand"
>
<
mastertableview
ShowHeadersWhenNoRecords
=
"true"
autogeneratecolumns
=
"false"
datakeynames
=
"AccountCodeID"
InsertItemDisplay
=
"Top"
insertitempageindexaction
=
"ShowItemOnCurrentPage"
ShowFooter
=
"True"
CommandItemDisplay
=
"Top"
ClientIDMode
=
"Static"
>
<
Columns
>
<
telerik:GridEditCommandColumn
ButtonType
=
"ImageButton"
UniqueName
=
"EditCommandColumn"
></
telerik:GridEditCommandColumn
>
<
telerik:GridBoundColumn
DataField
=
"AccountCodeID"
HeaderText
=
"AccountCode ID"
UniqueName
=
"AccountCodeID"
ReadOnly
=
"True"
>
</
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
UniqueName
=
"AccountCode"
HeaderText
=
"Account Code"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"lblAcCode"
runat
=
"server"
Text='<%# Eval("AccountCode")%>'></
asp:Label
>
</
ItemTemplate
>
<
EditItemTemplate
>
<
asp:Label
ID
=
"lblAcCode2"
runat
=
"server"
Text='<%# Eval("AccountCode") + " - " + Eval("AccountDescription")%>' Visible="false"></
asp:Label
>
<
telerik:RadComboBox
ID
=
"ddlAccountCode"
runat
=
"server"
Height
=
"200"
Width
=
"240"
DropDownWidth
=
"310"
HighlightTemplatedItems
=
"true"
CausesValidation
=
"true"
OnItemsRequested
=
"ddlAccountCode_ItemsRequested"
EnableItemCaching
=
"true"
ShowDropDownOnTextboxClick
=
"false"
EnableLoadOnDemand
=
"True"
ShowMoreResultsBox
=
"true"
EnableVirtualScrolling
=
"true"
MarkFirstMatch
=
"True"
Filter
=
"Contains"
AppendDataBoundItems
=
"true"
DataTextField
=
"AccountDescription"
DataValueField
=
"AccountCodeID"
>
</
telerik:RadComboBox
>
<
asp:Button
ID
=
"btnSearch"
runat
=
"server"
Text
=
"Search"
OnClick
=
"btnSearch_Click"
/>
</
EditItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridButtonColumn
ConfirmTextFormatString
=
"Are you sure you want to Delete {0} Account Code?"
ConfirmTextFields
=
"AccountCodeID"
ConfirmDialogType
=
"RadWindow"
CommandName
=
"Delete"
Text
=
"Delete"
UniqueName
=
"DeleteColumn"
></
telerik:GridButtonColumn
>
</
Columns
>
<
EditFormSettings
>
<
EditColumn
ButtonType
=
"ImageButton"
/>
</
EditFormSettings
>
<
CommandItemSettings
AddNewRecordText
=
"Add new record"
RefreshText
=
"Refresh"
></
CommandItemSettings
>
</
mastertableview
>
</
telerik:RadGrid
>
public
DataTable GetAccCode(
string
CompanyCode)
{
SqlConnection con =
new
SqlConnection(strcon);
SqlCommand cmd =
new
SqlCommand(
"[Invoice].[usp_tbl_AccountCode_DL_Test]"
, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue(
"@CompanyCode"
, CompanyCode);
SqlDataAdapter da =
new
SqlDataAdapter(cmd);
DataTable dt =
new
DataTable();
try
{
con.Open();
da.Fill(dt);
con.Close();
}
catch
(Exception ex)
{
}
return
dt;
}
#region Load on Demand
private
const
int
ItemsPerRequest = 50;
private
static
string
GetStatusMessage(
int
offset,
int
total)
{
if
(total <= 0)
{
return
"No matches"
;
}
else
{
return
String.Format(
"Items <b>1</b>-<b>{0}</b> out of <b>{1}</b>"
, offset, total);
}
}
protected
void
ddlAccountCode_ItemsRequested(
object
sender, RadComboBoxItemsRequestedEventArgs e)
{
//Allow only search in RadComboBox, do not load whole List item initially on combobox click
RadComboBox combo = (RadComboBox)sender;
string
c = ddlCompany.SelectedValue.ToString();
DataTable dt =
new
DataTable();
string
txt = e.Text;
int
itemOffset=0;
int
endOffset=0;
if
(txt == String.Empty)
{
combo.ShowDropDownOnTextboxClick =
false
;
}
else
{
dt = GetAccCode(c);
//got all Items related to selcted company in dt
DataView dv =
new
DataView(dt);
dv.RowFilter =
string
.Format(
"AccountDescription LIKE '%{0}%'"
, txt);
dt = dv.ToTable();
int
a = dv.Count;
//get the filtered/searched items
if
(dv.Count > 0)
{
itemOffset = e.NumberOfItems;
endOffset = Math.Min(itemOffset + ItemsPerRequest, dt.Rows.Count);
e.EndOfItems = endOffset == dt.Rows.Count;
}
else
if
(a <= 0)
{
itemOffset = e.NumberOfItems;
endOffset = Math.Min(a, a);
e.EndOfItems = endOffset == a;
}
}
//code adds/bind the records inside Combo
for
(
int
i = itemOffset; i < endOffset; i++)
{
combo.Items.Add(
new
RadComboBoxItem(dt.Rows[i][
"AccountDescription"
].ToString(), dt.Rows[i][
"AccountDescription"
].ToString()));
}
//If search/key-in text is not empty, show only searched records no. in footer of Combo
if
(!
string
.IsNullOrEmpty(e.Text))
{
DataView dv =
new
DataView(dt);
int
num = dv.Count;
endOffset = dv.Count;
}
else
{
combo.ShowDropDownOnTextboxClick =
false
;
}
e.Message = GetStatusMessage(endOffset, dt.Rows.Count);
}
#endregion
protected
void
btnSearch_Click(
object
sender, EventArgs e)
{
}