Imports Telerik.Web.UIPartial Class xtopia_ContentMS_testlistview Inherits System.Web.UI.Page Protected Sub rap_AjaxRequest(sender As Object, e As AjaxRequestEventArgs) Handles rap.AjaxRequest ltl_show_text.Text = e.Argument End SubEnd Class<%@ Page Language="VB" AutoEventWireup="false" CodeFile="test_onkeyupEvent.aspx.vb" Inherits="xtopia_ContentMS_testlistview" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"><head> <title></title> <script src="http://code.jquery.com/jquery-1.10.1.min.js"></script> <script src="http://code.jquery.com/jquery-migrate-1.2.1.min.js"></script> <script> function requestStart(sender, eventArgs) { console.log("ss"); } function onkeyupEvent() { var text = $find("<%= txt_art_search_box.ClientID %>").get_textBoxValue(); console.log(text); $find('<%=rap.ClientID %>').ajaxRequest($('#txt_art_search_box').val()); } </script></head><body> <form runat="server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager> <telerik:RadAjaxPanel runat="server" ID="rap"> <telerik:RadTextBox AutoPostBack="false" AutoCompleteType="Disabled" onkeyup="onkeyupEvent();" ID="txt_art_search_box" runat="server" EmptyMessage="Type here to search" Width="80%"> </telerik:RadTextBox> <br /> You type: <asp:Literal ID="ltl_show_text" runat="server" /> </telerik:RadAjaxPanel> </form></body></html>if (cell.CellType == PivotGridDataCellType.ColumnGrandTotalDataCell || cell.CellType == PivotGridDataCellType.RowGrandTotalDataCell)
{
if ((cell.Field as PivotGridAggregateField).DataField == "Amount")
{
string maxvaluerow = cell.ParentRowIndexes[1].ToString();
if (maxvaluerow == "11")
{
cell.Text = "";
// here i want to set the grandtotal result as Max value of row
}
}
}
<telerik:GridTemplateColumn HeaderText="Code" SortExpression="Code" UniqueName="Code" AllowFiltering="True"> <ItemTemplate> <asp:LinkButton ID="lbCCode" runat="server" Text='<%# Eval("Code") %>' /> </ItemTemplate></telerik:GridTemplateColumn>Width="98%" and etc information.
the MasterTableView TableLayout="Fixed"
I have a table with 40 columns, so the user can select many columns to show in the grid.
the grid had 40 telerik:GridTemplateColumn, and in the code behind in the event of _ItemCreated set the property visible (true/false).
and the <HeaderStyle without Width
And the propertys of grid Scrolling-AllowScroll ="true" Scrolling-UseStaticHeaders="true"
But dont work!
pls help!
<div ID="divGrid" runat="server" style="width:1900; background-color:Red;"> <telerik:RadGrid ID="rgvMainGrid" runat="server" DataSourceID="SQLDS_Receivables" EnableEmbeddedSkins="true" Skin="Office2010Silver" EnableAjaxSkinRendering="true" Height="600px" Width="1800px" EnableViewState="true" AutoGenerateColumns="false" AllowMultiRowSelection="false" AllowFilteringByColumn="false" EnableHeaderContextMenu="false" EnableHeaderContextFilterMenu="false" ShowGroupPanel="false" AllowAutomaticDeletes="false" AllowAutomaticInserts="false" AllowAutomaticUpdates="false" AllowSorting="true" EnableLinqExpressions="false" AllowPaging="false" PageSize="100" > <ItemStyle Wrap="true" /> <AlternatingItemStyle Wrap="true" /> <ActiveItemStyle BackColor="CornflowerBlue"/> <HeaderStyle HorizontalAlign="Center"/> <EditItemStyle BackColor="CornflowerBlue"/> <ClientSettings AllowColumnsReorder="true" ReorderColumnsOnClient="true" ColumnsReorderMethod="Reorder" AllowDragToGroup="false" EnablePostBackOnRowClick="false" EnableRowHoverStyle="false" > <Resizing AllowColumnResize="false" EnableRealTimeResize="true" ResizeGridOnColumnResize="false" AllowRowResize="false" /> <Selecting AllowRowSelect="true"/> <Scrolling AllowScroll="true" UseStaticHeaders="true" /> </ClientSettings> <GroupHeaderItemStyle Font-Size="11px" Font-Names="calibri" Font-Bold="true" Height="12px"/> <MasterTableView Name="Invoices" DataSourceID="SQLDS_Receivables" DataKeyNames="RecordId" ClientDataKeyNames="RecordId" EnableViewState="true" EditMode="EditForms" CommandItemDisplay="None" TableLayout="Fixed" Width="1800px" EnableNoRecordsTemplate="true" ShowHeadersWhenNoRecords="true" > <NoRecordsTemplate> <div>There are no records to display. </div></NoRecordsTemplate> <Columns> <telerik:GridBoundColumn UniqueName="Job" DataField="Job" HeaderText="Job" HeaderStyle-Width="87px" ReadOnly="true" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="JobDescription" DataField="JobDescription" HeaderText="Job Name" HeaderStyle-Width="200px" ReadOnly="true" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Extra" DataField="Extra" HeaderText="Extra" HeaderStyle-Width="87px" ReadOnly="true" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="CustomerName" DataField="CustomerName" HeaderText="Customer Name" HeaderStyle-Width="200px" ReadOnly="true" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="ContractNumber" DataField="ContractNumber" HeaderText="Contract" HeaderStyle-Width="100px" ReadOnly="true" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="DocumentId" DataField="DocumentId" HeaderText="Document Id" HeaderStyle-Width="100px" ReadOnly="true" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Draw" DataField="Draw" HeaderText="Draw" HeaderStyle-Width="125px" ReadOnly="true" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="InvoiceDate" DataField="InvoiceDate" HeaderText="Inv Date" HeaderStyle-Width="80px" ReadOnly="true" DataType="System.DateTime" DataFormatString="{0:MM/dd/yy}" ItemStyle-HorizontalAlign="Center" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="DaysOld" DataField="DaysOld" HeaderText="Days Old" HeaderStyle-Width="40px" ReadOnly="true" DataType="System.Int16" DataFormatString="{0:#,###,###}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="AccountingDate" DataField="AccountingDate" HeaderText="Acct Date" HeaderStyle-Width="80px" ReadOnly="true" DataType="System.DateTime" DataFormatString="{0:MM/dd/yy}" ItemStyle-HorizontalAlign="Center" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="BilledLessRetainage" DataField="BilledLessRetainage" HeaderText="Billed Less Ret" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="UnbilledRetainage" DataField="UnbilledRetainage" HeaderText="Unbilled Retainage" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridTemplateColumn UniqueName="gtcUpdateAll" HeaderText="Update All Transactions" AllowFiltering="false" > <ItemTemplate></ItemTemplate> <EditItemTemplate><asp:CheckBox ID = "chkUpdateAll" runat="server" Checked="true" /></EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn UniqueName="gtcExpectedPaymentDate" DataField="ExpectedPaymentDate" HeaderText="Exp Pay Date" HeaderStyle-Width="80px" ItemStyle-HorizontalAlign="Center" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" > <ItemTemplate><asp:Label ID="lblExpectedPaymentDate" runat="server" Text='<%# Eval("ExpectedPaymentDate", "{0:MM-dd-yy}" ) %>' /></ItemTemplate> <EditItemTemplate><telerik:RadDatePicker ID = "rdpExpectedPaymentDate" runat="server" Width="85px" DbSelectedDate='<%# Bind("ExpectedPaymentDate") %>' SkinID="skn_RadDatePicker" /></EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn UniqueName="DaysToPay" DataField="DaysToPay" HeaderText="Days To Pay" HeaderStyle-Width="55px" ReadOnly="true" DataType="System.Int16" DataFormatString="{0:#,###,###}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridDropDownColumn UniqueName="ActionCode" DataField="ActionCode" HeaderText="Action" HeaderStyle-Width="100px" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" ListTextField="LevelCode" ListValueField="IdentifierCode" DataSourceID="SQLDS_ActionCode" DropDownControlType="RadComboBox" DefaultInsertValue="NA" /> <telerik:GridDropDownColumn UniqueName="StatusCode" DataField="StatusCode" HeaderText="Status" HeaderStyle-Width="120px" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" ListTextField="LevelCode" ListValueField ="IdentifierCode" DataSourceID="SQLDS_StatusCode" DropDownControlType="RadComboBox" DefaultInsertValue="NA"/> <telerik:GridDropDownColumn UniqueName="ResponsibleParty" DataField="ResponsibleParty" HeaderText="Responsible Party" HeaderStyle-Width="150px" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" ListTextField="LevelCode" ListValueField ="IdentifierCode" DataSourceID="SQLDS_ResponsibleParty" DropDownControlType="RadComboBox" DefaultInsertValue="NA"/> <telerik:GridTemplateColumn UniqueName="Comments" DataField="Comments" HeaderText="Comments" HeaderStyle-Width="120px" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" > <ItemTemplate> <asp:Label ID="lblComments" runat="server" Text='<%# Bind("Comments") %>' /> <asp:ImageButton ID="ibtHistory" runat="server" ImageUrl='<%# Eval("HistoryImage") %>' ToolTip="Click To Show Status History" /> </ItemTemplate> <EditItemTemplate><telerik:RadTextBox ID="txtComments" runat="server" Text='<%# Bind("Comments") %>' TextMode="MultiLine" InputType="Text" Width="500px" Rows="5" Height="50px" Resize="Both" ButtonsPosition="Right"/></EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn UniqueName="CurrentlyDue" DataField="CurrentlyDue" HeaderText="Currently Due" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Days31" DataField="Days31" HeaderText="Age 31-60 Days" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Days61" DataField="Days61" HeaderText="Age 61-90 Days" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Days91" DataField="Days91" HeaderText="Age > 90 Days" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="PastDue" DataField="PastDue" HeaderText="Payment Past Due" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Pay30" DataField="Pay30" HeaderText="Due 0-30 Days" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Pay60" DataField="Pay60" HeaderText="Due 31-60 Days" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Pay90" DataField="Pay90" HeaderText="Due 61-90 Days" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="Pay91" DataField="Pay91" HeaderText="Due >90 Days" HeaderStyle-Width="100px" ReadOnly="true" DataType="System.Decimal" DataFormatString="{0:#,###,###.#0}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> <telerik:GridBoundColumn UniqueName="RecordId" DataField="RecordId" HeaderText="Record Id" HeaderStyle-Width="50px" ReadOnly="true" DataType="System.Int32" DataFormatString="{0:###}" ItemStyle-HorizontalAlign="Right" FilterImageUrl="<%$ Resources:Images,FilterGray16%>" /> </Columns> </MasterTableView> </telerik:RadGrid></div>string username = (string)RadGrid1.SelectedValues["UserName"];