Questions on UI for ASP.NET AJAX Forum

110,776 questions

9 answers

171 views

Telerik RadGrid -> How SUM of (nvarchar) Column in footer?

my radgrid(telerik) is like below :

<telerik:RadGrid ID="grdUsers" runat="server" GridLines="None" Skin="Vista" DataSourceID="sdsUsers"

AllowPaging="True" AutoGenerateColumns="False" OnItemCommand="grdUsers_ItemCommand"

Width="900px" AllowSorting="True" PageSize="20">

<MasterTableView AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="sdsUsers">

<DetailTables>

<telerik:GridTableView runat="server" DataKeyNames="ID,User_ID" DataSourceID="sdsDownload"

ShowFooter="True">

<ParentTableRelation>

<telerik:GridRelationFields DetailKeyField="User_ID" MasterKeyField="ID" />

</ParentTableRelation>

<CommandItemSettings ExportToPdfText="Export to Pdf" />

<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">

<HeaderStyle Width="20px" />

</RowIndicatorColumn>

<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">

<HeaderStyle Width="20px" />

</ExpandCollapseColumn>

<Columns>

<telerik:GridBoundColumn DataField="ID" DataType="System.Int32" FilterControlAltText="Filter ID column"

HeaderText="ID" ReadOnly="True" SortExpression="ID" UniqueName="ID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="User_ID" DataType="System.Int32" FilterControlAltText="Filter User_ID column"

HeaderText="User_ID" SortExpression="User_ID" UniqueName="User_ID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FileSize" FilterControlAltText="Filter FileSize column"

HeaderText="FileSize" SortExpression="FileSize" UniqueName="FileSize" Aggregate="Sum">

</telerik:GridBoundColumn>

</Columns>

<EditFormSettings>

<EditColumn FilterControlAltText="Filter EditCommandColumn column">

</EditColumn>

</EditFormSettings>

</telerik:GridTableView>

</DetailTables>

<CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>

<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">

<HeaderStyle Width="20px"></HeaderStyle>

</RowIndicatorColumn>

<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column" Visible="True">

<HeaderStyle Width="20px"></HeaderStyle>

</ExpandCollapseColumn>

<Columns>

<telerik:GridBoundColumn DataField="ID" FilterControlAltText="Filter ID column" HeaderText="ID"

SortExpression="ID" UniqueName="ID">

<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" />

<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FirstName" FilterControlAltText="Filter FirstName column"

HeaderText="FirstName" SortExpression="FirstName" UniqueName="FirstName">

<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" />

<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />

</telerik:GridBoundColumn>

</Columns>

<EditFormSettings>

<EditColumn FilterControlAltText="Filter EditCommandColumn column">

</EditColumn>

</EditFormSettings>

</MasterTableView>

<FilterMenu EnableImageSprites="False">

</FilterMenu>

<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default">

</HeaderContextMenu>

</telerik:RadGrid>

this is a Hierarchy grid with two tables (one master and one detail).
i have a column in detail table named (FileSize)!
this column in my database is nvarchar(50), i want to have sum of file sizes in the footer of detail table.
but after enabling Footer in this detail table and set aggregate of FileSize Column to Sum, i got an error that tells you can not have sum of object values!
is there a way for make sum of FileSize Column?

Grid

answered on 07 Nov 2011

21 answers

495 views

RadGrid Reducing the filter menu options by column

I have a grid with 5 GridBoundColumns (Name, SSN, DOB, Address, etc..). I want different set of filtering menu options for each of these columns. Is there any way to achieve this?

Grid

answered on 07 Nov 2011

1 answer

120 views

After doing collapse/expand left pane , RadSlidingPane is not showing properly.

After doing collapse/expand left pane , RadSlidingPane is not showing properly in my code.
When I collapse the left radpane and again expands it, my bottom sliding radpane is not resizing.
Here is my code for bottom first radslidingpane and it's same for all other bottom sliding panes......

<telerik:RadSlidingPane ID="rspAttrConstraints" Title="<%$ Resources:tabAttrConstraints %>"

runat="server" Height="170" OnClientExpanded="RadSlidingHelp" OnClientDocked="RadSlidingHelp" ResizeText="<%$ Resources:ResizeText %>" DockText="<%$ Resources:DockText %>" UndockText="<%$ Resources:UndockText %>" CollapseText="<%$ Resources:CollapseText %>">

<table cellpadding="0" cellspacing="0" width="100%" height="100%" border="0">

<tr>

<td height="100%" valign="top" align="left">

<%-- <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <%--ClientSettings-ClientEvents-OnRowSelected="AttrRowSelected"

<ContentTemplate>--%>

<telerik:RadGrid ID="rgAttrConstraints" runat="server" AllowPaging="false" Width="100%"

Height="100%" GroupHeaderItemStyle-Height="0" ShowGroupPanel="false" AllowMultiRowSelection="true"

GridLines="Both" ShowFooter="false" AllowAutomaticUpdates="true" EnableViewState="true"

OnSelectedIndexChanged="rgAttrConstraints_SelectedIndexChanged" ShowStatusBar="True"

AutoGenerateColumns="False" OnItemDataBound="rgAttrConstraints_ItemDataBound"

OnItemCreated="rgAttrConstraints_ItemCreated" OnNeedDataSource="rgAttrConstraints_NeedDataSource"

OnInsertCommand="rgAttrConstraints_InsertCommand" OnUpdateCommand="rgAttrConstraints_UpdateCommand" BorderWidth="0">

<ClientSettings EnableRowHoverStyle="true" Resizing-AllowColumnResize="false" Resizing-EnableRealTimeResize="true" >

<Selecting AllowRowSelect="true"/>

<%--<ClientEvents OnRowClick="RowClick" OnRowDblClick="RowDblClick" OnCommand="GridCommand" OnGridCreated="GridCreated"/>--%>

<ClientEvents OnRowSelected="AttrRowSelected" OnMasterTableViewCreated="AttrOnLoad" ></ClientEvents

>    <%--  OnRowSelected="AttrRowSelected" --%>                                                                                                             </

ClientSettings>

<MasterTableView AutoGenerateColumns="false" CommandItemDisplay="Top" EditMode="InPlace"

InsertItemDisplay="Bottom" AllowAutomaticInserts="false" DataKeyNames="Id,IsAdvancedConstraint"

ClientDataKeyNames="Id,IsAdvancedConstraint,Expression,Name,ConstraintType">

<CommandItemTemplate>

<div style="padding: 3px 3px;">

<table>

<tr>

<td>

<asp:LinkButton ID="btnAddNew" runat="server" CommandName="InitInsert" Visible='<%# rgAttrConstraints.EditIndexes.Count == 0 && !rgAttrConstraints.MasterTableView.IsItemInserted %>'>

<img style="border:0px;vertical-align:middle;" alt="" src="../Images/NewEnable2.png"/>

<asp:Literal runat="server" Text="<%$ Resources:btnAddConstraint %>" ></asp:Literal>

</asp:LinkButton> </td>

<td> <asp:LinkButton ID="btnAddPredefined" runat="server" CommandName="AddPredefined"

OnClientClick="return addPredefinedAttrConstraint();" Visible='<%# rgAttrConstraints.EditIndexes.Count == 0 && !rgAttrConstraints.MasterTableView.IsItemInserted %>'> <%----%>

<img style="border: 0px; vertical-align: middle;" alt="" src="../Images/NewEnable2.png" />

<asp:Literal ID="ltrPredefined" runat="server" Text="<%$ Resources:ltrPredefined %>"></asp:Literal>

</asp:LinkButton> </td>

<td> <asp:LinkButton ID="btnInsert" runat="server" CommandName="PerformInsert" Visible='<%# rgAttrConstraints.EditIndexes.Count == 0 && rgAttrConstraints.MasterTableView.IsItemInserted %>'>

<img style="border: 0px; vertical-align: middle;" alt="" src="../Images/NewEnable2.png" />

<asp:Literal ID="Literal2" runat="server" Text="<%$ Resources:btnInsertConstraint %>"></asp:Literal>

</asp:LinkButton> </td>

<td> <asp:LinkButton ID="btnEditSelected" runat="server" CommandName="EditSelected" OnClientClick="return editSelectedAttrConstraint();"

Visible='<%# rgAttrConstraints.EditIndexes.Count == 0 && !rgAttrConstraints.MasterTableView.IsItemInserted%>'>

<img style="border: 0px; vertical-align: middle;" alt="" src="../Images/imgEditBtnEnable.png" />

<asp:Literal ID="Literal1" runat="server" Text="<%$ Resources:btnEditSelectedConstraint %>"></asp:Literal>

</asp:LinkButton> </td>

<td> <asp:LinkButton ID="btnUpdateEdited" runat="server" CommandName="UpdateEdited" Visible='<%# rgAttrConstraints.EditIndexes.Count > 0 %>'>

<img style="border: 0px; vertical-align: middle;" alt="" src="../Images/update.png" />

<asp:Literal ID="Literal3" runat="server" Text="<%$ Resources:btnUpdateEditedConstraint %>"></asp:Literal>

</asp:LinkButton> </td>

<td> <asp:LinkButton ID="btnCancel" runat="server" CommandName="CancelAll" Visible='<%# rgAttrConstraints.EditIndexes.Count > 0 || rgAttrConstraints.MasterTableView.IsItemInserted %>'>

<img style="border: 0px; vertical-align: middle;" alt="" src="../Images/imgDelBtnEnable.png" />

<asp:Literal ID="Literal4" runat="server" Text="<%$ Resources:btnCancel %>"></asp:Literal>

</asp:LinkButton> </td>

<td> <asp:LinkButton ID="btnDeleteConstraint" runat="server" CommandName="DeleteSelected"

Visible='<%# rgAttrConstraints.EditIndexes.Count == 0 && !rgAttrConstraints.MasterTableView.IsItemInserted %>'

OnClientClick="javascript:return ConfirmConstraintsDelete();">

<%--OnClientClick="ConfirmConstraintsDelete();"--%>

<img style="border: 0px; vertical-align: middle;" alt="" src="../Images/imgDelBtnEnable.png" />

<asp:Literal ID="Literal5" runat="server" Text="<%$ Resources:btnDeleteConstraint %>"></asp:Literal>

</asp:LinkButton> </td>

<td> <asp:LinkButton ID="btnAndOr" runat="server" CommandName="AndOr" OnClick="btnAndOrAttrConstraint_Click"

Visible='<%# rgAttrConstraints.EditIndexes.Count == 0 && !rgAttrConstraints.MasterTableView.IsItemInserted %>'>

<img style="border: 0px; vertical-align: middle;" alt="" src="../Images/and_or.png" />

</asp:LinkButton></td>

<td> <asp:LinkButton ID="btnUseNot" runat="server" CommandName="AddGroup" OnClick="btnUseNotAttrConstraint_Click"

Visible='<%# rgAttrConstraints.EditIndexes.Count == 0 && !rgAttrConstraints.MasterTableView.IsItemInserted %>'>

<img style="border: 0px; vertical-align: middle;" alt="" src="../Images/not.png" />

</asp:LinkButton> </td>

<td> <asp:LinkButton ID="btnAddGroup" runat="server" CommandName="AddGroup" OnClick="btnGroupConstraints_Click"

Visible='<%# rgAttrConstraints.EditIndexes.Count == 0 && !rgAttrConstraints.MasterTableView.IsItemInserted %>'>

<img style="border: 0px; vertical-align: middle;" alt="" src="../Images/AddGroupClause.gif" />

<asp:Literal ID="Literal6" runat="server" Text="<%$ Resources:btnAddGroup %>"></asp:Literal>

</asp:LinkButton> </td>

<td> <asp:LinkButton ID="btnRemoveGroup" runat="server" CommandName="removeGroup" OnClick="btnRemoveGroupConstraints_Click"

Visible='<%# rgAttrConstraints.EditIndexes.Count == 0 && !rgAttrConstraints.MasterTableView.IsItemInserted %>'>

<img style="border: 0px; vertical-align: middle;" alt="" src="../Images/UnGroupClause.gif" />

<asp:Literal ID="Literal7" runat="server" Text="<%$ Resources:btnRemoveGroup %>"></asp:Literal>

</asp:LinkButton> </td>

<td> <asp:LinkButton ID="btnMoveConstraintUp" runat="server" CommandName="MoveUp" OnClick="btnMoveConstraintUp_Click"

Visible='<%# rgAttrConstraints.EditIndexes.Count == 0 && !rgAttrConstraints.MasterTableView.IsItemInserted %>'>

<img style="border: 0px; vertical-align: middle;" alt="" src="../Images/Up.png" />

<asp:Literal ID="Literal8" runat="server" Text="<%$ Resources:btnMoveConstraintUp %>"></asp:Literal>

</asp:LinkButton> </td>

<td> <asp:LinkButton ID="btnMoveConstraintDown" runat="server" CommandName="MoveDown"

OnClick="btnMoveConstraintDown_Click" Visible='<%# rgAttrConstraints.EditIndexes.Count == 0 && !rgAttrConstraints.MasterTableView.IsItemInserted %>'>

<img style="border: 0px; vertical-align: middle;" alt="" src="../Images/Down.png" />

<asp:Literal ID="Literal9" runat="server" Text="<%$ Resources:btnMoveConstraintDown %>"></asp:Literal>

</asp:LinkButton> </td>

<td> <asp:LinkButton ID="btnAdvancedMode" runat="server" CommandName="UpdateEdited" OnClientClick="return AdvancedConstraintMode();"

Visible='<%# rgAttrConstraints.EditIndexes.Count > 0 || rgAttrConstraints.MasterTableView.IsItemInserted %>'>

<img style="border: 0px; vertical-align: middle;" alt="" src="../Images/advanced.png" />

<asp:Literal ID="Literal10" runat="server" Text="<%$ Resources:btnAdvancedMode %>"></asp:Literal>

</asp:LinkButton> </td>

</tr>

</table>

</div>

</CommandItemTemplate>

<Columns>

<telerik:GridTemplateColumn UniqueName="Constraint_Group" HeaderText="" HeaderStyle-Width="10px"

ItemStyle-Width="10px">

<ItemTemplate>

<asp:Label ID="lblGroup" runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "GroupingDisplayText")%>'></asp:Label>

<asp:HiddenField ID="hdnParentId" runat="server" />

<asp:HiddenField ID="hdnConstraintId" runat="server" Value='<%#DataBinder.Eval(Container.DataItem, "Id")%>' />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="Constraint_AndOr" HeaderText="" HeaderStyle-Width="45px"

ItemStyle-HorizontalAlign="Center">

<ItemTemplate>

<asp:Literal ID="ltrNodeOperator" runat="server"></asp:Literal>

</ItemTemplate>

<%--<EditItemTemplate>

<telerik:RadComboBox ID="ddlAndOr" runat="server" AutoPostBack="true" Width="100%">

<Items>

<telerik:RadComboBoxItem Text="And" Value="0"></telerik:RadComboBoxItem>

<telerik:RadComboBoxItem Text="Or" Value="1"></telerik:RadComboBoxItem>

</Items>

</telerik:RadComboBox>

</EditItemTemplate>--%>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="Constraint_UseNot" HeaderText="" HeaderStyle-Width="40px"

ItemStyle-HorizontalAlign="Center">

<ItemTemplate>

<asp:Literal ID="ltrUseNot" runat="server"></asp:Literal>

</ItemTemplate>

<%--<EditItemTemplate>

<telerik:RadComboBox ID="ddlNot" runat="server" AutoPostBack="true" Width="100%">

<Items>

<telerik:RadComboBoxItem Text="" Value="0"></telerik:RadComboBoxItem>

<telerik:RadComboBoxItem Text="Not" Value="1"></telerik:RadComboBoxItem>

</Items>

</telerik:RadComboBox>

</EditItemTemplate>--%>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="Constraint_Name" DataField="Name" HeaderText="<%$ Resources:Constraint_Name %>"

HeaderStyle-Width="90px">

<ItemTemplate>

<asp:Image ID="imgIcon" runat="server" ImageUrl="~/Images/CustomConstraint.bmp" />

<asp:Literal ID="ltrConstraintName" runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "Name")%>'></asp:Literal>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadTextBox ID="txtConstraintName" runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "Name")%>'

Width="100%">

</telerik:RadTextBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="Constraint_Dimension" DataField="ConstraintLeftDimension"

HeaderText="<%$ Resources:Constraint_Dimension %>" HeaderStyle-Width="100px">

<ItemTemplate>

<asp:Literal ID="ltrDimensionName" runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "ConstraintLeftDimension")%>'></asp:Literal>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadComboBox ID="ddlDimension" runat="server" AutoPostBack="true" Width="100%">

</telerik:RadComboBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="Constraint_Field" HeaderText="<%$ Resources:Constraint_Field %>"

HeaderStyle-Width="100px">

<ItemTemplate>

<%#DataBinder.Eval(Container.DataItem, "ConstraintLeftAttribute")%>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadComboBox ID="ddlField" runat="server" AutoPostBack="true" Width="100%">

</telerik:RadComboBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="Constraint_Operator" HeaderText="<%$ Resources:Constraint_Operator %>"

HeaderStyle-Width="80px">

<ItemTemplate>

<asp:Literal ID="ltrOperator" runat="server"></asp:Literal>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadComboBox ID="ddlOperators" runat="server" AutoPostBack="true" Width="100%"

DropDownWidth="120px">

</telerik:RadComboBox>

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="Constraint_Value1" HeaderText="<%$ Resources:Constraint_Value1 %>"

HeaderStyle-Width="80px">

<ItemTemplate>

<%#DataBinder.Eval(Container.DataItem, "ConstraintValue1")%>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadTextBox ID="txtValue1" runat="server" Enabled="true" Width="50%">

</telerik:RadTextBox>

<%--<asp:Label ID="lblValue1" runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "ConstraintValue1")%>'></asp:Label>--%>

<asp:ImageButton ID="imgbPickValue1" runat="server" OnClick="btnPickDBValue1_Click"

ImageUrl="~/Images/valuepicker.png" ToolTip="Pick DB Value" />

<asp:ImageButton ID="imgParameters1" runat="server" OnClientClick="onPickParameter1()"

ImageUrl="~/Images/pickparameter_16x16.png" ToolTip="Pick Parameter" />

</EditItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="Constraint_Value2" HeaderText="<%$ Resources:Constraint_Value2 %>"

HeaderStyle-Width="80px">

<ItemTemplate>

<%#DataBinder.Eval(Container.DataItem, "ConstraintValue2")%>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadTextBox ID="txtValue2" runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "ConstraintValue2")%>'

Enabled="true" Width="50%">

</telerik:RadTextBox>

<%--<asp:Label ID="lblValue2" runat="server" Text='<%#DataBinder.Eval(Container.DataItem, "ConstraintValue2")%>'></asp:Label>--%>

<asp:ImageButton ID="imgbPickValue2" runat="server" OnClick="btnPickDBValue2_Click"

ImageUrl="~/Images/valuepicker.png" ToolTip="Pick DB Value" />

<asp:ImageButton ID="imgParameters2" runat="server" OnClientClick="onPickParameter2()"

ImageUrl="~/Images/pickparameter_16x16.png" ToolTip="Pick Parameter" />

</EditItemTemplate>

</telerik:GridTemplateColumn>

<%--<telerik:GridEditCommandColumn UniqueName="Constraint_Edit" HeaderText="" HeaderStyle-Width="100px"

EditText="Edit" ButtonType="ImageButton" EditImageUrl="../Images/imgEditBtnEnable.png" UpdateImageUrl="../Images/Success.gif"

InsertImageUrl="../Images/Success.gif" CancelImageUrl="../Images/Error.gif"></telerik:GridEditCommandColumn>--%>

</Columns>

</MasterTableView>

</telerik:RadGrid>

<%-- </ContentTemplate>

</asp:UpdatePanel>--%>

</td>

</tr>

</table>

</telerik:RadSlidingPane>

So please give me the solution for this. I've attached screen shot for more information.

General Discussions

answered on 07 Nov 2011

1 answer

106 views

Row Header Column

Hi,

I am trying to display a column before the tree column where I can display the data record number. Is this possible? If so can you get me started?

Thanks,
Paul

TreeList

answered on 07 Nov 2011

1 answer

129 views

How to Modify the Layout of Uploading Progress Container

Hellow Telerik ,
How to Modify the Layout of Uploading Progress Container.
Upload file status window, looks sloppy. Get things
on one line, eliminate the random breaks.
Regards

Upload (Obsolete)

answered on 07 Nov 2011

3 answers

181 views

Save selected options of HEADER CONTEXT MENU

Hello! I need save the preferences of user.
I user hide X columns from Header Context menu, order, etcc I need save it.
which is the events of Header Cotext menu, that i can use for that?

Thanks!

Grid

answered on 07 Nov 2011

1 answer

159 views

hello all.
we need an eform builder that made with asp.net ajax telerik component.who has done this?please help me for this.thanks.

General Discussions

answered on 07 Nov 2011

1 answer

122 views

datepicker popup button always disabled

I have three datepickers on the same page. The calendar is not working in any of them.
I can´t even click the popup buttons. They seem to be always disabled.
The text part works just ok, but the calendar is never shown.
Any hints?
TIA

Calendar