This is a migrated thread and some comments may be shown as answers.

Group Footer button to Delete Group

1 Answer 63 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Rick asked on 13 Jan 2012, 10:40 PM

I have an application that manages currencies on hand for various countries. Each group is essentially a country that consists of records for each banknote denomination.

What I want to do is have a button in the group footer for each country that:

A - Is labeled "Delete United Kingdom Pound
B - When clicked, it will run an SQL query to delete all records for that country.

I have been unable to label the button.
I have been unable to get the country code needed to run the delete query.

I am developing on a Windows 7 computer using MS Visual Studio 2010.

Please let me know if I can provide more information.

<telerik:RadStyleSheetManager id="RadStyleSheetManager1" runat="server" />

<style type="text/css">

.body

{

background:#eeeeee;

}

.MyBoldedRow

{

font-weight: bold;

color: Red;

}

.MyNormalRow

{

font-weight: Normal;

color: Black;

}

.RadTextboxClass

{

text-align:right;

}

</style>

</head>

<body>

<form id="form1" runat="server">

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">

<Scripts>

<%--Needed for JavaScript IntelliSense in VS2010--%>

<%--For VS2008 replace RadScriptManager with ScriptManager--%>

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />

<asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" />

</Scripts>

</telerik:RadScriptManager>

<script type="text/javascript">

//Put your JavaScript code here.

</script>

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="RadGrid1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadGrid1" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<div>

<asp:SqlDataSource ID="CountryCodes" runat="server"

ConnectionString="Data Source=W-SQL04.dlbassociates.com;Initial Catalog=DonPlanner;Integrated Security=SSPI"

SelectCommand="SELECT 'XXXX' as CurrencyTarget_CountryCode, '<Select a Country>' as DisplayValue UNION SELECT dbo.Currency_LatestConversions_TBL.Currency_CountryCode as CountryCode, dbo.Currency_LatestConversions_TBL.Currency_CountryDesc + ' (' + dbo.Currency_LatestConversions_TBL.Currency_CountryCode + ')' as DisplayValue

FROM dbo.Currency_LatestConversions_TBL

LEFT OUTER JOIN dbo.Currency_TargetAmounts_TBL ON dbo.Currency_LatestConversions_TBL.Currency_CountryCode = dbo.Currency_TargetAmounts_TBL.CurrencyTarget_CountryCode

ORDER BY DisplayValue ASC">

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:DonPlannerCS %>"

DeleteCommand="DELETE FROM Currency_TargetAmounts_TBL WHERE CurrencyTarget_CountryCode = @CurrencyTarget_CountryCode"

InsertCommand="INSERT INTO [Currency_TargetAmounts_TBL] ([CurrencyTarget_CountryCode], [CurrencyTarget_USDDenomination], [CurrencyTarget_USDNeeded], [CurrencyTarget_Native], [CurrencyTarget_NativeCurrent])

Select @CurrencyTarget_CountryCode, @USDDenomination1, @USRequired1, @NativeDenom1, @CurrentCount1 UNION ALL

Select @CurrencyTarget_CountryCode, @USDDenomination2, @USRequired2, @NativeDenom2, @CurrentCount2 UNION ALL

Select @CurrencyTarget_CountryCode, @USDDenomination3, @USRequired3, @NativeDenom3, @CurrentCount3 UNION ALL

Select @CurrencyTarget_CountryCode, @USDDenomination4, @USRequired4, @NativeDenom4, @CurrentCount4 UNION ALL

Select @CurrencyTarget_CountryCode, @USDDenomination5, @USRequired5, @NativeDenom5, @CurrentCount5"

SelectCommand="SELECT TOP (100) PERCENT

dbo.Currency_TargetAmounts_TBL.Currency_ID,

dbo.Currency_TargetAmounts_TBL.CurrencyTarget_CountryCode,

dbo.Currency_LatestConversions_TBL.Currency_CountryDesc,

dbo.Currency_TargetAmounts_TBL.CurrencyTarget_USDDenomination,

dbo.Currency_TargetAmounts_TBL.CurrencyTarget_USDNeeded,

dbo.Currency_TargetAmounts_TBL.CurrencyTarget_Native,

dbo.Currency_TargetAmounts_TBL.CurrencyTarget_NativeCurrent,

CEILING(dbo.Currency_TargetAmounts_TBL.CurrencyTarget_USDNeeded / (dbo.Currency_TargetAmounts_TBL.CurrencyTarget_Native * (1 / dbo.Currency_LatestConversions_TBL.Currency_Conversion))) AS CountNeeded

FROM dbo.Currency_LatestConversions_TBL LEFT OUTER JOIN

dbo.Currency_TargetAmounts_TBL ON

dbo.Currency_LatestConversions_TBL.Currency_CountryCode = dbo.Currency_TargetAmounts_TBL.CurrencyTarget_CountryCode

WHERE (NOT (dbo.Currency_TargetAmounts_TBL.CurrencyTarget_CountryCode IS NULL))

ORDER BY dbo.Currency_LatestConversions_TBL.Currency_CountryDesc, dbo.Currency_TargetAmounts_TBL.CurrencyTarget_USDDenomination"

UpdateCommand="UPDATE [Currency_TargetAmounts_TBL] SET

[CurrencyTarget_USDNeeded] = @CurrencyTarget_USDNeeded,

[CurrencyTarget_Native] = @CurrencyTarget_Native,

[CurrencyTarget_NativeCurrent] = @CurrencyTarget_NativeCurrent

WHERE [Currency_ID]=@Currency_ID">

<DeleteParameters>

<asp:Parameter Name="CurrencyTarget_ID" />

</DeleteParameters>

<InsertParameters>

<asp:Parameter Type="String" Name="CurrencyTarget_CountryCode" />

<asp:Parameter Type="Int32" Name="USDDenomination1" />

<asp:Parameter Type="Int32" Name="USRequired1" />

<asp:Parameter Type="Int32" Name="NativeDenom1" />

<asp:Parameter Type="Int32" Name="CurrentCount1" />

<asp:Parameter Type="Int32" Name="USDDenomination2" />

<asp:Parameter Type="Int32" Name="USRequired2" />

<asp:Parameter Type="Int32" Name="NativeDenom2" />

<asp:Parameter Type="Int32" Name="CurrentCount2" />

<asp:Parameter Type="Int32" Name="USDDenomination3" />

<asp:Parameter Type="Int32" Name="USRequired3" />

<asp:Parameter Type="Int32" Name="NativeDenom3" />

<asp:Parameter Type="Int32" Name="CurrentCount3" />

<asp:Parameter Type="Int32" Name="USDDenomination4" />

<asp:Parameter Type="Int32" Name="USRequired4" />

<asp:Parameter Type="Int32" Name="NativeDenom4" />

<asp:Parameter Type="Int32" Name="CurrentCount4" />

<asp:Parameter Type="Int32" Name="USDDenomination5" />

<asp:Parameter Type="Int32" Name="USRequired5" />

<asp:Parameter Type="Int32" Name="NativeDenom5" />

<asp:Parameter Type="Int32" Name="CurrentCount5" />

</InsertParameters>

<UpdateParameters>

<asp:Parameter Name="CurrencyTarget_USDNeeded" />

<asp:Parameter Name="CurrencyTarget_Native" />

<asp:Parameter Name="CurrencyTarget_NativeCurrent" />

</UpdateParameters>

</asp:SqlDataSource>

<asp:Label ID="Label1" runat="server" Text="Don Beaty's Foreign Currency Tracker"

Font-Bold="False" Font-Names="Calibri" Font-Size="XX-Large"></asp:Label>

<telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticUpdates="True"

CellSpacing="0" DataSourceID="SqlDataSource1" GridLines="None"

BorderColor="Gray" BorderStyle="Inset">

<MasterTableView autogeneratecolumns="False" commanditemdisplay="Top"

datasourceid="SqlDataSource1" allowpaging="True"

datakeynames="Currency_ID"

PageSize="30" EditMode="InPlace" Name="Currency" showgroupfooter="True">

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

<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">

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

</RowIndicatorColumn>

<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">

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

</ExpandCollapseColumn>

<Columns>

<telerik:GridTemplateColumn

FilterControlAltText="Filter EditCommandColumn column"

Groupable="False"

UniqueName="EditCommandColumn">

<ItemTemplate>

<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="false" CommandName="Edit" Text="Edit"></asp:LinkButton>

</ItemTemplate>

<EditItemTemplate>

<asp:LinkButton ID="LinkButton1" runat="server" CommandName="Update" Text="Update"></asp:LinkButton>

<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="false" CommandName="Cancel" Text="Cancel"></asp:LinkButton>

</EditItemTemplate>

<InsertItemTemplate>

<asp:LinkButton ID="LinkButton3" runat="server" CommandName="Insert" Text="Insert"></asp:LinkButton>

<asp:LinkButton ID="LinkButton4" runat="server" CausesValidation="false" CommandName="Cancel" Text="Cancel"></asp:LinkButton>

</InsertItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn

DataField="Currency_ID"

FilterControlAltText="Filter Currency_ID column"

HeaderText=""

SortExpression="Currency_ID"

UniqueName="Currency_ID">

<ItemTemplate>

</ItemTemplate>

<EditItemTemplate>

<asp:Label ID="Currency_IDLabel1" runat="server" Text='<%# Bind("Currency_ID") %>'></asp:Label>

</EditItemTemplate>

<InsertItemTemplate></InsertItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn

DataField="CurrencyTarget_CountryCode"

FilterControlAltText="Filter column column"

HeaderText="Country Code"

UniqueName="ddCountryCode">

<ItemTemplate>

<asp:Label ID="CurrencyTarget_CountryCodeLabel" runat="server" Text='<%# Bind("CurrencyTarget_CountryCode") %>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:Label ID="CurrencyTarget_CountryCodeLabel1" runat="server" Text='<%# Bind("CurrencyTarget_CountryCode") %>'></asp:Label>

</EditItemTemplate>

<InsertItemTemplate>

<telerik:RadComboBox ID="CurrencyTarget_CountryCode" runat="server"

DataSourceID="CountryCodes" DataTextField="DisplayValue"

DataValueField="CurrencyTarget_CountryCode"

SelectedValue='<%# Bind("CurrencyTarget_CountryCode") %>'>

</telerik:RadComboBox>

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ErrorMessage="Select A Country Code" ControlToValidate="CurrencyTarget_CountryCode" ValidationExpression="[^<]*"/>

</InsertItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn

DataField="Currency_CountryDesc"

FilterControlAltText="Filter Currency_CountryDesc column"

HeaderText="Country Description"

SortExpression="Currency_CountryDesc"

UniqueName="Currency_CountryDesc">

<ItemTemplate>

<asp:Label ID="Currency_CountryDescLabel" runat="server" Text='<%# Bind("Currency_CountryDesc") %>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:Label ID="Currency_CountryDescLabel1" runat="server" Text='<%# Bind("Currency_CountryDesc") %>'></asp:Label>

</EditItemTemplate>

<InsertItemTemplate></InsertItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn

DataField="CurrencyTarget_USDDenomination"

DataType="System.Int32"

FilterControlAltText="Filter CurrencyTarget_USDDenomination column"

HeaderText="USD Denomination"

SortExpression="CurrencyTarget_USDDenomination"

UniqueName="CurrencyTarget_USDDenomination">

<ItemTemplate>

<asp:Label ID="CurrencyTarget_USDDenominationLabel" runat="server" Text='<%# Eval("CurrencyTarget_USDDenomination","${0:#}") %>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:Label ID="CurrencyTarget_USDDenominationLabel1" runat="server" Text='<%# Eval("CurrencyTarget_USDDenomination", "${0:#}") %>'></asp:Label>

</EditItemTemplate>

<InsertItemTemplate>

<telerik:RadNumericTextBox ID="USDDenomination1" runat="server" NumberFormat-DecimalDigits="0" Value="5" MinValue="1" CssClass="RadTextboxClass" /><br />

<br /><telerik:RadNumericTextBox ID="USDDenomination2" runat="server" NumberFormat-DecimalDigits="0" Value="10" MinValue="1" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="USDDenomination3" runat="server" NumberFormat-DecimalDigits="0" Value="20" MinValue="1" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="USDDenomination4" runat="server" NumberFormat-DecimalDigits="0" Value="50" MinValue="1" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="USDDenomination5" runat="server" NumberFormat-DecimalDigits="0" Value="100" MinValue="1" CssClass="RadTextboxClass"/><br />

<br /></InsertItemTemplate>

<HeaderStyle HorizontalAlign="Right" />

<ItemStyle HorizontalAlign="Right" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn

DataField="CurrencyTarget_USDNeeded"

DataType="System.Int32"

FilterControlAltText="Filter CurrencyTarget_USDNeeded column"

HeaderText="USD Needed"

SortExpression="CurrencyTarget_USDNeeded"

UniqueName="CurrencyTarget_USDNeeded">

<ItemTemplate>

<asp:Label ID="CurrencyTarget_USDNeededLabel" runat="server" Text='<%# Bind("CurrencyTarget_USDNeeded", "${0:#}") %>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadNumericTextBox ID="CurrencyTarget_USDNeededTextBox" runat="server" NumberFormat-DecimalDigits="0" text='<%# Bind("CurrencyTarget_USDNeeded") %>' MinValue="0" CssClass="RadTextboxClass"/>

</EditItemTemplate>

<InsertItemTemplate>

<telerik:RadNumericTextBox ID="USRequired1" runat="server" NumberFormat-DecimalDigits="0" Value="10" MinValue="0" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="USRequired2" runat="server" NumberFormat-DecimalDigits="0" Value="0" MinValue="0" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="USRequired3" runat="server" NumberFormat-DecimalDigits="0" Value="40" MinValue="0" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="USRequired4" runat="server" NumberFormat-DecimalDigits="0" Value="150" MinValue="0" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="USRequired5" runat="server" NumberFormat-DecimalDigits="0" Value="300" MinValue="0" CssClass="RadTextboxClass"/><br />

<br /></InsertItemTemplate>

<HeaderStyle HorizontalAlign="Right" />

<ItemStyle HorizontalAlign="Right" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn

DataField="CurrencyTarget_Native"

DataType="System.Int32"

FilterControlAltText="Filter CurrencyTarget_Native column"

HeaderText="Foreign Denomination"

SortExpression="CurrencyTarget_Native"

UniqueName="CurrencyTarget_Native">

<ItemTemplate>

<asp:Label ID="CurrencyTarget_NativeLabel" runat="server" Text='<%# Bind("CurrencyTarget_Native") %>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadNumericTextBox ID="CurrencyTarget_NativeTextBox" runat="server" NumberFormat-DecimalDigits="0" text='<%# Bind("CurrencyTarget_Native") %>' MinValue="1" CssClass="RadTextboxClass"/>

</EditItemTemplate>

<InsertItemTemplate>

<telerik:RadNumericTextBox ID="NativeDenom1" runat="server" NumberFormat-DecimalDigits="0" MinValue="1" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="NativeDenom2" runat="server" NumberFormat-DecimalDigits="0" MinValue="1" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="NativeDenom3" runat="server" NumberFormat-DecimalDigits="0" MinValue="1" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="NativeDenom4" runat="server" NumberFormat-DecimalDigits="0" MinValue="1" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="NativeDenom5" runat="server" NumberFormat-DecimalDigits="0" MinValue="1" CssClass="RadTextboxClass"/><br />

<br /></InsertItemTemplate>

<HeaderStyle HorizontalAlign="Right" />

<ItemStyle HorizontalAlign="Right" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn

DataField="CurrencyTarget_NativeCurrent"

DataType="System.Decimal"

FilterControlAltText="Filter CurrencyTarget_NativeCurrent column"

HeaderText="Foreign Count On Hand"

SortExpression="CurrencyTarget_NativeCurrent"

UniqueName="CurrencyTarget_NativeCurrent">

<ItemTemplate>

<asp:Label ID="CurrencyTarget_NativeCurrentLabel" runat="server" Text='<%# Bind("CurrencyTarget_NativeCurrent") %>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<telerik:RadNumericTextBox ID="CurrencyTarget_NativeCurrentLabel" runat="server" NumberFormat-DecimalDigits="0" text='<%# Bind("CurrencyTarget_NativeCurrent") %>' MinValue="0" CssClass="RadTextboxClass"/>

</EditItemTemplate>

<InsertItemTemplate>

<telerik:RadNumericTextBox ID="CurrentCount1" runat="server" Value="0" NumberFormat-DecimalDigits="0" MinValue="0" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="CurrentCount2" runat="server" Value="0" NumberFormat-DecimalDigits="0" MinValue="0" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="CurrentCount3" runat="server" Value="0" NumberFormat-DecimalDigits="0" MinValue="0" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="CurrentCount4" runat="server" Value="0" NumberFormat-DecimalDigits="0" MinValue="0" CssClass="RadTextboxClass"/><br />

<br /><telerik:RadNumericTextBox ID="CurrentCount5" runat="server" Value="0" NumberFormat-DecimalDigits="0" MinValue="0" CssClass="RadTextboxClass"/><br />

<br /></InsertItemTemplate>

<HeaderStyle HorizontalAlign="Right" />

<ItemStyle HorizontalAlign="Right" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn

DataField="CountNeeded"

DataType="System.Decimal"

FilterControlAltText="Filter CountNeeded column"

HeaderText="Count Needed"

SortExpression="CountNeeded"

UniqueName="CountNeeded">

<ItemTemplate>

<asp:Label ID="CountNeeded" runat="server" Text='<%# Bind("CountNeeded") %>'></asp:Label>

</ItemTemplate>

<EditItemTemplate>

<asp:label ID="CountNeededTextBox" runat="server" Text='<%# Bind("CountNeeded") %>'></asp:label>

</EditItemTemplate>

<InsertItemTemplate></InsertItemTemplate>

<HeaderStyle HorizontalAlign="Right" />

<ItemStyle HorizontalAlign="Right" />

</telerik:GridTemplateColumn>

</Columns>

<GroupByExpressions>

<telerik:GridGroupByExpression>

<SelectFields>

<telerik:GridGroupByField FieldAlias="CountryCode" FieldName="CurrencyTarget_CountryCode" HeaderText="Country Code" />

</SelectFields>

<GroupByFields>

<telerik:GridGroupByField FieldAlias="CurrencyTarget_CountryCode" FieldName="CurrencyTarget_CountryCode" />

</GroupByFields>

</telerik:GridGroupByExpression>

</GroupByExpressions>

<GroupFooterTemplate>

<telerik:RadButton ID="RadButton1" runat="server" OnClick="RadButton1_click" Text='<%# Bind("CurrencyTarget_CountryCode") %>'>

</telerik:RadButton>

</GroupFooterTemplate>

<EditFormSettings>

<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>

</EditFormSettings>

<GroupHeaderItemStyle BackColor="PaleGreen" BorderColor="Black" BorderStyle="Solid" Font-Bold="True" Font-Names="Calibri" Font-Size="Medium" ForeColor="Black" />

<AlternatingItemStyle BackColor="#D7FFD7" />

<PagerStyle AlwaysVisible="True" BackColor="#FFC080" />

<HeaderStyle Font-Bold="True" />

</MasterTableView>

<FilterMenu EnableImageSprites="False"></FilterMenu>

<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>

</telerik:RadGrid>

</div>

</form>

</body>

</html

Group Footer button to Delete Group

1 Answer, 1 is accepted