protected void ExpExcel_Click(object sender, EventArgs e){ foreach (GridColumn col in RadGrid1.MasterTableView.Columns) { if (col.UniqueName.Contains("notes") || (col.UniqueName.Contains("EditCommandColumn")) || (col.UniqueName.Contains("column1"))) { col.Display = false; } else { col.Display = true; } } foreach (GridFilteringItem item in RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem)) item.Visible = false; RadGrid1.ExportSettings.ExportOnlyData = true; RadGrid1.MasterTableView.ExportToExcel(); }Hi There
I have a situation in which I have grid with numeric column on the web page and I have a numeric column on the web page as well.
I would like to compare the sum of all the grid numeric column values with the value of numeric column on the web page.
For example I have a value of 10,000 on the numeric column on the page and I have four records in the grid with the value 1000, 2000, 4000,2500 total=9500 which is less than 10,000 the value of my numeric column on the web page
And I am going to edit the fourth record (using Edit form mode) with the value say 5000 from 2500. Now the total value is greater than 10000 so I would like to warn my user using client side Java script and put the focus back again inside the grid numeric column so that he can change the value so that the value should not be greater than 10,000
So I would like to know the way how to calculate the total of particular numeric column of all rows including the edited row using Java script on focus out or on update client side event
In short I need to find a way to loop through all the rows including the one I am editing on the client side
Your help will be much appreciated
Many thanks
Syed
When 'postback' event is triggered in a page, rad grid header style is reset. What could be the cause of this issue and how to fix it?
aspx code
<asp:UpdatePanel UpdateMode="Always" ID="upGridConfig" runat="server"> <ContentTemplate> <asp:HiddenField ID="hdnId" runat="server" /> <asp:HiddenField ID="hdnTowerNo" runat="server" /> <telerik:RadGrid ID="gridWindTurbines" ViewStateMode="Enabled" AllowPaging="true" AllowMultiRowSelection="false" AllowSorting="true" OnPageIndexChanged="gridWindTurbines_PageIndexChanged" OnNeedDataSource="gridWindTurbines_NeedDataSource" AutoGenerateColumns="false" AllowAutomaticInserts="true" GridLines="Horizontal" ClientSettings-EnableRowHoverStyle="true" OnItemDataBound="gridWindTurbines_ItemDataBound" EnableAjaxSkinRendering="false" MasterTableView-RowIndicatorColumn-ItemStyle-BorderColor="ActiveBorder" Height="264px" runat="server"> <ClientSettings Scrolling-AllowScroll="true" Selecting-AllowRowSelect="true" Scrolling-UseStaticHeaders="true" Selecting-UseClientSelectColumnOnly="true"> <ClientEvents OnRowSelecting="enablelink" OnRowDeselecting="disablelink" /> </ClientSettings> <MasterTableView AllowPaging="true" DataKeyNames="NAME,OBJID,MODEL,POWER" Visible="true" Width="100%" TableLayout="Fixed" EnableViewState="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" AlternatingItemStyle-HorizontalAlign="Center" ClientDataKeyNames="NAME,OBJID"> <Columns> <telerik:GridClientSelectColumn UniqueName="CHK" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="5%"> </telerik:GridClientSelectColumn> <telerik:GridBoundColumn DataField="OBJID" HeaderStyle-Font-Bold="true" Visible="false" HeaderStyle-Width="10%"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="NAME" HeaderStyle-Font-Bold="true" HeaderText="WTG" HeaderStyle-Width="10%"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="MODEL" HeaderText="TYPE" HeaderStyle-Font-Bold="true" HeaderStyle-Width="25%"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn UniqueName="POWER" SortExpression="POWER" HeaderStyle-Font-Bold="true" HeaderText="POWER"> <ItemTemplate> <asp:Label ID="LblPower" runat="server" /> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="PLCCount" HeaderText="#PLC" HeaderStyle-Font-Bold="true" HeaderStyle-Width="10%"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CCUCount" HeaderText="#CCU" HeaderStyle-Font-Bold="true" HeaderStyle-Width="10%"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="SMPCount" HeaderText="#SMP" HeaderStyle-Font-Bold="true" HeaderStyle-Width="10%"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DASCount" HeaderText="#DAS" HeaderStyle-Font-Bold="true" HeaderStyle-Width="10%"> </telerik:GridBoundColumn> </Columns> <HeaderStyle CssClass="GridHeader" /> </MasterTableView> <PagerStyle Mode="NextPrevAndNumeric" VerticalAlign="Bottom" Position="Bottom" AlwaysVisible="true" /> </telerik:RadGrid> </ContentTemplate> </asp:UpdatePanel>
Has anyone managed to create a FileBrowserContentProvider to handle physical paths outside the web app? I have a scenario where I need files to be managed outside of the application, and it appears that everything wants virtual paths!
Looking at the demo I also thought of using a httphandler for the files, however that isn’t working. I got as far as getting the directory tree to show in the left tree view however no files are being shown.
I am by no means an ASP.net expert and am still learning the ropes, so if anyone can point me in the right direction I'd be most grateful.
I Keep getting errors like below thrown up:
---------------------------
Message from webpage
---------------------------
Callback Loading error:
D:\Test\
Unrecognized escape sequence. (14): { path : "D:\Test\", sortExpression : ""}96|/wEWCAL4tITjBwL8w9uGDALztZepDwLytZepDwL1tZepDwL0tZepDwLvtZepDwLutZepD4v1sVL6WoAl9jmHj5iuS6WymetQ
---------------------------
OK
---------------------------
