Telerik Forums
UI for ASP.NET AJAX Forum
5 answers
120 views
  • I am using MS Visual Studio 2010 in a 3.5 environment.
  • I am using Microsoft Vista (32 bit)
  • The database is currently located on an SQL 2008 server.
  • I am using RadGrid & tools, version 2012.2.724.35
  • I am using Internet Explorer (9.0.8112.16421)
  • I am programming in VB.net


I think this will be an easy one to solve.  I want to set the sort order of a grid based on who is logged in.  Basically if it's person A, then sort by X, Y.  If it's anyone else, sort by Z.

I have a radGrid with 1 nested detail table.

I had tried to put this on the Page_load using an exit sub if it's a postback, but as you may have guessed, this has many side effects:

  1. Go to another page produces a blank page (no grid at all because it's empty.)
  2. Trying to edit a row in the top table makes the grid disappear.

If I remove the postback exit sub, editing a record just causes an error.


So I think I'm just not setting the data source in the right place or I'm just doing it wrong.  

My Page Load code
Private Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
 
    If Page.IsPostBack Then Exit Sub
    Dim sSQLText As String = "SELECT Currency_CountryCode, Currency_CountryDesc, CurrencyTarget_CountryCode, Currency_LastUpdated, Currency_DisplayOrder FROM Currency_LatestConversions_TBL LEFT OUTER JOIN Currency_CurrentlyTracked ON Currency_LatestConversions_TBL.Currency_CountryCode = Currency_CurrentlyTracked.CurrencyTarget_CountryCode "
 
    If Page.User.Identity.Name.ToString.ToUpper = "RSCOTT" Then
        sSQLText &= "ORDER BY Existing, Currency_LatestConversions_TBL.Currency_CountryDesc"
 
    Else
        sSQLText &= "ORDER BY Currency_DisplayOrder"
 
    End If
 
    SqlDataSource1.SelectCommand = sSQLText
    RadGrid1.DataBind()
 
End Sub



I think you'll know how to solve this without my HTML, but I'll give it to you anyway.


My HTML
<body>
    <form id="form1" runat="server">
        <div>
            <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:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager>
            <telerik:RadGrid ID="RadGrid1" runat="server" CellSpacing="0"
                  
                DataSourceID="SqlDataSource1"
                GridLines="None"
                AllowAutomaticInserts="True"
                AllowAutomaticUpdates="True"
                AllowAutomaticDeletes="True"
                BorderColor="Gray"
                BorderStyle="Inset" Skin="Office2010Silver" >
             
                <MasterTableView AutoGenerateColumns="False" DataSourceID="SqlDataSource1"
                    commanditemdisplay="None"
                    allowpaging="True" 
                    EditMode="InPlace"
                    PageSize="30"
                    Width="100%"
                    Name="Currency"
                    showgroupfooter="True" BorderColor="#E0E0E0" BorderStyle="Solid"
                    BorderWidth="1px" GridLines="Vertical" DataKeyNames="Currency_CountryCode, Currency_BriefcaseUsed, Currency_HomeOfficeUsed, Currency_OneHundUsed, Currency_LastUpdated">
 
                    <Columns>
                        <telerik:GridTemplateColumn
                            FilterControlAltText="Filter EditCommandColumn column"
                            Groupable="False"
                            UniqueName="EditCommandColumn">
 
                            <ItemTemplate>
                                <asp:LinkButton ID="lbuEditP" runat="server" CausesValidation="false" CommandName="Edit" Text="Edit"></asp:LinkButton>
                            </ItemTemplate>
 
                            <EditItemTemplate>
                                <asp:LinkButton ID="lbuUpdateP" runat="server" CommandName="Update" Text="Update"></asp:LinkButton
                                <asp:LinkButton ID="lbuCancelUpdateP" runat="server" CausesValidation="false" CommandName="Cancel" Text="Cancel"></asp:LinkButton>
                            </EditItemTemplate>
 
                        </telerik:GridTemplateColumn>
                        <telerik:GridBoundColumn DataField="Currency_CountryDesc"
                            FilterControlAltText="Filter Currency_CountryDesc column"
                            HeaderText="Currency" SortExpression="Currency_CountryDesc"
                            UniqueName="Currency_CountryDesc"
                            ReadOnly="True">
                            <HeaderStyle VerticalAlign="Bottom"></HeaderStyle>
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="ExchangeRate"
                            DataType="System.Decimal"
                            FilterControlAltText="Filter Currency_Conversion column"
                            HeaderText="Exchange Rate" SortExpression="ExchangeRate"
                            ItemStyle-HorizontalAlign="Right"  HeaderStyle-HorizontalAlign="Center"
                            UniqueName="ExchangeRate"
                            ReadOnly="True">
                            <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Right"></ItemStyle>
                        </telerik:GridBoundColumn>
                        <telerik:GridTemplateColumn HeaderText="Flag Briefcase<br/>(With DLB)" FilterControlAltText="Filter Currency_BriefcaseUsed column"
                            UniqueName="Currency_BriefcaseUsed">
                            <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center"></ItemStyle>
                            <EditItemTemplate>
                                <asp:CheckBox ID="CheckBoxA" runat="server" Checked='<%# Bind("Currency_BriefcaseUsed") %>' />
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:CheckBox ID="CheckBoxB" runat="server" Checked='<%# Bind("Currency_BriefcaseUsed") %>' OnCheckedChanged="UpdateBriefcaseFlag" autopostback="true"/>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn HeaderText="Flag Home<br/>(With DLB)" FilterControlAltText="Filter Currency_HomeOfficeUsed column"
                            UniqueName="Currency_HomeOfficeUsed">
                            <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center"></ItemStyle>
                            <EditItemTemplate>
                                <asp:CheckBox ID="CheckBoxC" runat="server" Checked='<%# Bind("Currency_HomeOfficeUsed") %>' />
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:CheckBox ID="CheckBoxD" runat="server" Checked='<%# Bind("Currency_HomeOfficeUsed") %>' OnCheckedChanged="UpdateHomeOfficeFlag" autopostback="true"/>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn HeaderText="Flag 100<br/>(With DLB)" FilterControlAltText="Filter Currency_OneHundUsed column"
                            UniqueName="Currency_OneHundUsed">
                            <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center"></ItemStyle>
                            <EditItemTemplate>
                                <asp:CheckBox ID="CheckBoxE" runat="server" Checked='<%# Bind("Currency_OneHundUsed") %>' />
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:CheckBox ID="CheckBoxF" runat="server" Checked='<%# Bind("Currency_OneHundUsed") %>' OnCheckedChanged="UpdateOneHundFlag" autopostback="true"/>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridBoundColumn DataField="Currency_EnvelopeCount500"
                            DataType="System.Int16"
                            FilterControlAltText="Filter Currency_EnvelopeCount500 column"
                            HeaderText="500 Env. Count<br/>Needed<br/>(With Accounting)"
                            SortExpression="Currency_EnvelopeCount500"
                            UniqueName="Currency_EnvelopeCount500">
                            <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle>
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Currency_EnvelopeCount100"
                            DataType="System.Int16"
                            FilterControlAltText="Filter Currency_EnvelopeCount100 column"
                            HeaderText="100 Env. Count<br/>Needed<br/>(With Accounting)"
                            SortExpression="Currency_EnvelopeCount100"
                            UniqueName="Currency_EnvelopeCount100">
                            <HeaderStyle HorizontalAlign="Center" CssClass="maximize"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle>
                        </telerik:GridBoundColumn>
                         <telerik:GridBoundColumn DataField="Currency_EnvelopeCount500_Ready"
                            DataType="System.Int16"
                            FilterControlAltText="Filter Currency_EnvelopeCount500_Ready column"
                            HeaderText="500 Env. Count<br/>On Hand<br/>(With Accounting)"
                            SortExpression="Currency_EnvelopeCount500_Ready"
                            UniqueName="Currency_EnvelopeCount500_Ready">
                            <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle>
                        </telerik:GridBoundColumn>
 
                        <telerik:GridBoundColumn DataField="Currency_EnvelopeCount100_Ready"
                            DataType="System.Int16"
                            FilterControlAltText="Filter Currency_EnvelopeCount100_Ready column"
                            HeaderText="100 Env. Count<br/>On Hand<br/>(With Accounting)"
                            SortExpression="Currency_EnvelopeCount100_Ready"
                            UniqueName="Currency_EnvelopeCount100_Ready">
                            <HeaderStyle HorizontalAlign="Center" CssClass="maximize"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle>
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Currency_DisplayOrder"
                            DataType="System.Int16"
                            FilterControlAltText="Filter Currency_DisplayOrder column"
                            HeaderText="Display<br/>Order"
                            SortExpression="Currency_DisplayOrder"
                            UniqueName="Currency_DisplayOrder">
                            <HeaderStyle HorizontalAlign="Center" CssClass="maximize"></HeaderStyle>
                            <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle>
                        </telerik:GridBoundColumn>
                    </Columns>
 
                    <DetailTables>
                        <telerik:GridTableView runat="server"  DataKeyNames="Currency_ID"
                            EditMode="InPlace" CommandItemDisplay="Bottom" Width="100%"
                            DataSourceID="SqlDataSource2" AutoGenerateColumns="False"
                            ShowGroupFooter="True" >
                         
                            <ParentTableRelation>
                                <telerik:GridRelationFields DetailKeyField="Currency_CountryCode" MasterKeyField="Currency_CountryCode" />
                            </ParentTableRelation>
 
                            <CommandItemSettings ExportToPdfText="Export to PDF" />
                            <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>
                            <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn>
 
                            <Columns>
                                <telerik:GridEditCommandColumn FilterControlAltText="Filter EditCommandColumn column" InsertText="Save">
                                    <ItemStyle HorizontalAlign="Right" BorderColor="Black"></ItemStyle>
                                </telerik:GridEditCommandColumn>
                                <telerik:GridTemplateColumn DataField="CurrencyTarget_ForeignDenomination"
                                    DataType="System.Int32"
                                    FilterControlAltText="Filter CurrencyTarget_ForeignDenomination column"
                                    HeaderText="Foreign<br/>Currency<br/>Denomination"
                                    SortExpression="CurrencyTarget_ForeignDenomination"
                                    UniqueName="CurrencyTarget_ForeignDenomination">
                                    <ItemStyle HorizontalAlign="Right" BorderColor="Black"></ItemStyle>
                                    <InsertItemTemplate>
                                        <asp:TextBox ID="CurrencyTarget_ForeignDenomination" runat="server"
                                            Text='<%# Bind("CurrencyTarget_ForeignDenomination") %>'></asp:TextBox>
                                    </InsertItemTemplate>
                                    <ItemTemplate>
                                        <asp:Label ID="CurrencyTarget_ForeignDenominationLabel" runat="server"
                                            Text='<%# Eval("CurrencyTarget_ForeignDenomination") %>'></asp:Label>
                                    </ItemTemplate>
                                    <EditItemTemplate>
                                        <asp:Label ID="CurrencyTarget_ForeignDenominationLabel2" runat="server"
                                            Text='<%# Eval("CurrencyTarget_ForeignDenomination") %>'></asp:Label>
                                    </EditItemTemplate>
                                </telerik:GridTemplateColumn>
                                <telerik:GridBoundColumn DataField="USDEquivalent"
                                    HeaderText="US<br/>Dollar<br/>Value" SortExpression="USDEquivalent" UniqueName="USDEquivalent" FilterControlAltText="Filter USDEquivalent column"
                                    DataType="System.Decimal" DataFormatString="${0:#}"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Right" BorderColor="Black"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn
                                    DataField="CurrencyTarget_FCNeeded"
                                    HeaderText="Enter<br/>Quantity to be Included<br/>for 1 '500'<br/>Envelope" SortExpression="CurrencyTarget_FCNeeded" UniqueName="CurrencyTarget_FCNeeded" FilterControlAltText="Filter CurrencyTarget_FCNeeded column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum">
                                    <ItemStyle HorizontalAlign="Center" BackColor="#CCFFCC" BorderColor="Green" CssClass="maximize"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="USDValue"
                                    HeaderText="US<br/>Dollar<br/>Value" SortExpression="USDValue" UniqueName="USDValue" FilterControlAltText="Filter USDValue column"
                                    DataType="System.Decimal" DataFormatString="${0:###,##0.00}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Right" BackColor="#CCFFCC" BorderColor="Green"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="TotalFor500Envelopes"
                                    HeaderText="Total<br/>For '500'<br/>Envelopes<br/>On Hand" SortExpression="TotalFor500Envelopes" UniqueName="TotalFor500Envelopes" FilterControlAltText="Filter TotalFor500Envelopes column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Center" BackColor="#CCFFCC" BorderColor="Green"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="CurrencyTarget_FCNeeded_100"
                                    HeaderText="Enter<br/>Quantity to be Included<br/>for 1 '100'<br/>Envelope" SortExpression="CurrencyTarget_FCNeeded_100" UniqueName="CurrencyTarget_FCNeeded_100" FilterControlAltText="Filter CurrencyTarget_FCNeeded_100 column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum">
                                    <ItemStyle HorizontalAlign="Center" BackColor="#CCCCFF" BorderColor="#6666FF" CssClass="maximize"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="USDValue_100"
                                    HeaderText="US<br/>Dollar<br/>Value" SortExpression="USDValue_100" UniqueName="USDValue_100" FilterControlAltText="Filter USDValue_100 column"
                                    DataType="System.Decimal" DataFormatString="${0:###,##0.00}" Aggregate="Sum"
                                    ReadOnly="True">
                                    <ItemStyle HorizontalAlign="Right" BackColor="#CCCCFF" BorderColor="#6666FF"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="TotalFor100Envelopes"
                                    HeaderText="Total<br/>For '100'<br/>Envelopes<br/>On Hand" SortExpression="TotalFor100Envelopes" UniqueName="TotalFor100Envelopes" FilterControlAltText="Filter TotalFor100Envelopes column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Center" BackColor="#CCCCFF" BorderColor="#6666FF"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="TotalForAllEnvelopes"
                                    HeaderText="Total<br/>All<br/>Envelopes<br/>On Hand" SortExpression="TotalForAllEnvelopes" UniqueName="TotalForAllEnvelopes" FilterControlAltText="Filter TotalForAllEnvelopes column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="CurrencyTarget_OutsideEnvelope"
                                    HeaderText="Enter<br/>Total<br/>Outside<br/>the Envelope" SortExpression="CurrencyTarget_OutsideEnvelope" UniqueName="CurrencyTarget_OutsideEnvelope" FilterControlAltText="Filter CurrencyTarget_OutsideEnvelope column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum">
                                    <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666" CssClass="maximize"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="AccountingTotalOnHand"
                                    HeaderText="Total<br/>Quantity<br/>On Hand<br/>In Accounting" SortExpression="AccountingTotalOnHand" UniqueName="AccountingTotalOnHand" FilterControlAltText="Filter AccountingTotalOnHand column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="TotalAllEnvelopesNeeded"
                                    HeaderText="Total<br/>All<br/>Envelopes<br/>Needed" SortExpression="TotalAllEnvelopesNeeded" UniqueName="TotalAllEnvelopesNeeded" FilterControlAltText="Filter TotalAllEnvelopesNeeded column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="QuantityToOrder"
                                    HeaderText="Quantity<br/>To<br/>Order" SortExpression="QuantityToOrder" UniqueName="QuantityToOrder" FilterControlAltText="Filter QuantityToOrder column"
                                    DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666" ForeColor="Crimson" Font-Bold="true"></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="TotalFCValue"
                                    HeaderText="Total<br/>Foreign<br/>Currency<br/>Value" SortExpression="TotalFCValue" UniqueName="TotalFCValue" FilterControlAltText="Filter TotalFCValue column"
                                    DataType="System.Int32" DataFormatString="{0:###,##0}" Aggregate="Sum"
                                    ReadOnly="True" >
                                    <ItemStyle HorizontalAlign="Right" BackColor="#FFCCCC" BorderColor="#FF6666" ></ItemStyle>
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn DataField="TotalUSDValue"
                                    HeaderText="Total<br/>USD<br/>Value" SortExpression="TotalUSDValue" UniqueName="TotalUSDValue" FilterControlAltText="Filter TotalUSDValue column"
                                    DataType="System.Decimal" DataFormatString="${0:###,##0.00}" Aggregate="Sum"
                                    ReadOnly="True">
                                    <ItemStyle HorizontalAlign="Right" BackColor="#FFCCCC" BorderColor="#FF6666"></ItemStyle>
                                </telerik:GridBoundColumn>
                            </Columns>
 
                            <GroupByExpressions>
                                <telerik:GridGroupByExpression>
                                    <SelectFields>
                                        <telerik:GridGroupByField FieldAlias="CountryCode"  FieldName="Currency_CountryCode" HeaderText="Country Code"  />
                                    </SelectFields>
                                    <GroupByFields>
                                        <telerik:GridGroupByField FieldAlias="Currency_CountryCode"  FieldName="Currency_CountryCode" />
                                    </GroupByFields>
                         
                                </telerik:GridGroupByExpression>
                            </GroupByExpressions>
                             <FooterStyle Font-Bold="true" />
                            <EditFormSettings>
                                <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                                </EditColumn>
                            </EditFormSettings>
                        </telerik:GridTableView>
                    </DetailTables>
 
                    <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
                    <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>
                    <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn>
 
                    <EditFormSettings>
                        <EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
                    </EditFormSettings>
 
                    <PagerStyle AlwaysVisible="True"  />
                    <HeaderStyle Font-Bold="True" />
                </MasterTableView>
 
                <FilterMenu EnableImageSprites="False"></FilterMenu>
            </telerik:RadGrid>
     
        </div>
 
        <br />
        <telerik:RadButton ID="btnReport" runat="server" style="top: 0px; left: 0px"
            Text="Summary Report">
        </telerik:RadButton>
 
        <telerik:RadEditor ID="radPDFReport" Runat="server" Height="114px"
            Width="685px" ExportSettings-FileName="ForeignCurrencyTotals"
            Visible="False" Font-Names="Calibri">
            <ExportSettings OpenInNewWindow="True">
                <Pdf PageHeight="8.5in" PageWidth="11in" AllowAdd="True" AllowCopy="True"
                    AllowModify="True" Title="Foreign Curency Totals" Author="Accounting"
                    Creator="Accounting" PageBottomMargin="45px" PageFooterMargin="18px"
                    PageHeaderMargin="18px" PageLeftMargin="18px" PageRightMargin="18px"
                    PageTopMargin="37px" />
            </ExportSettings>
            <Content>CONTENT</Content>
 
            <TrackChangesSettings CanAcceptTrackChanges="False"></TrackChangesSettings>
        </telerik:RadEditor>
 
 
         
 
 
 
 
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:DonPlannerCS %>"
 
        
        UpdateCommand="UPDATE [Currency_LatestConversions_TBL]
                        SET [Currency_EnvelopeCount500] = @Currency_EnvelopeCount500, [Currency_EnvelopeCount100] = @Currency_EnvelopeCount100, [Currency_EnvelopeCount500_Ready] = @Currency_EnvelopeCount500_Ready, [Currency_EnvelopeCount100_Ready] = @Currency_EnvelopeCount100_Ready, [Currency_BriefcaseUsed] = @Currency_BriefcaseUsed, [Currency_HomeOfficeUsed] = @Currency_HomeOfficeUsed, [Currency_OneHundUsed] = @Currency_OneHundUsed, Currency_DisplayOrder = @Currency_DisplayOrder, Currency_LastEdited = GetDate() 
                        WHERE [Currency_CountryCode]=@Currency_CountryCode">
 
        <UpdateParameters>
            <asp:Parameter Name="Currency_CountryCode" />
        </UpdateParameters>
 
    </asp:SqlDataSource>
 
 
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:DonPlannerCS %>"
 
        SelectCommand="SELECT Currency_Grid.*
                        FROM Currency_Grid
                        WHERE([Currency_CountryCode]=@Currency_CountryCode)
                        ORDER BY CurrencyTarget_ForeignDenomination"
 
        UpdateCommand="UPDATE [Currency_TargetAmounts_TBL]
                        SET [CurrencyTarget_FCNeeded] = @CurrencyTarget_FCNeeded, [CurrencyTarget_FCNeeded_100] = @CurrencyTarget_FCNeeded_100, [CurrencyTarget_OutsideEnvelope] = @CurrencyTarget_OutsideEnvelope, [CurrencyTarget_DateUpdated] = GetDate()
                        WHERE [Currency_ID] = @Currency_ID"
 
         
        InsertCommand="INSERT INTO Currency_TargetAmounts_TBL(Currency_Location, CurrencyTarget_CountryCode, CurrencyTarget_ForeignDenomination, CurrencyTarget_FCNeeded, CurrencyTarget_FCNeeded_100, CurrencyTarget_OutsideEnvelope)
                        SELECT 'Accounting' AS Expr1, @Currency_CountryCode AS Expr2, @CurrencyTarget_ForeignDenomination AS Expr3, @CurrencyTarget_FCNeeded AS Expr4, @CurrencyTarget_FCNeeded_100 AS Expr5, @CurrencyTarget_OutsideEnvelope AS Expr6" >
 
        <SelectParameters>
            <asp:SessionParameter DefaultValue="XXX" Name="Currency_CountryCode" SessionField="@Currency_CountryCode" Type="String" />
        </SelectParameters>
 
        <UpdateParameters>
            <asp:Parameter Name="CurrencyTarget_FCNeeded" />
            <asp:Parameter Name="CurrencyTarget_FCNeeded_100" />
            <asp:Parameter Name="CurrencyTarget_OutsideEnvelope" />
            <asp:Parameter Name="CurrencyTarget_DateUpdated" />
            <asp:Parameter Name="Currency_ID" />
        </UpdateParameters>
 
        <InsertParameters>
            <asp:Parameter Type="Int32" Name="CurrencyTarget_ForeignDenomination" />
            <asp:Parameter Type="Int32" Name="CurrencyTarget_FCNeeded"   />
            <asp:Parameter Type="Int32" Name="CurrencyTarget_FCNeeded_100"  />
            <asp:Parameter Type="Int32" Name="CurrencyTarget_OutsideEnvelope"  />
            <asp:Parameter Type="DateTime" Name="CurrencyTarget_DateCreated"  />
        </InsertParameters>
 
    </asp:SqlDataSource>
 
    </form>
</body>


Rick
Top achievements
Rank 1
 answered on 15 Aug 2012
2 answers
241 views
Is there a way to add an icon in select button?
Jin
Top achievements
Rank 1
 answered on 15 Aug 2012
5 answers
342 views
Hi,

I have radgrid,for which I am using inbuilt edit functionality.
Edit Template contains some controls along with the Button. on click of this button,another set of same controls should be added in the edit template. Please refer edittemplate.png and edittemplate1.png 


Also after saving these detail from Edit template we need to display TWO record inside the RadGrid row.Please refer radgrid.png
Kostadin
Telerik team
 answered on 15 Aug 2012
2 answers
94 views
I have a menu with a checkboxlist inside of an ItemTemplate.  When the menu expands, the user can check whatever boxes they want and close the menu.

But the checkbox list will be created dynamically so I want to know if I can get the width of the template to grow with the size of it's contents.

Thanks
Javier
Top achievements
Rank 1
 answered on 15 Aug 2012
1 answer
101 views
I'm evaluating Telerik controls and have a question on the best grid type control to use to lay out certain data. I've attached an image of the layout I'm trying to achieve.

Can this be done? The challenge here would be to sum up groups of data in the same control. I'm assuming that the grand total at the bottom of the grid could be done within a footer.

Thank you for your help on this. 

Terry
Kostadin
Telerik team
 answered on 15 Aug 2012
1 answer
230 views
I have a button and a RadProgressArea button in one page to execute a batch job. When I click the button and wait for some time, I click the cancel button, it have no any response. Anybody know why?

  protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                RadProgressArea1.Localization.UploadedFiles = "Completed Steps: ";
                RadProgressArea1.Localization.CurrentFileName = "Step: ";
                RadProgressArea1.Localization.TotalFiles = "Total Steps:";
            }
        }


        protected void RadButtonProcess_Click(object sender, EventArgs e)
        {
            RadProgressContext context = RadProgressContext.Current;
            context.SecondaryTotal = "100";
            for (int i = 1; i < 100; i++)
            {
                context.SecondaryValue = i.ToString();
                context.SecondaryPercent = i.ToString();
                context.CurrentOperationText = "Doing step " + i.ToString();
                if (!Response.IsClientConnected)
                {
                    //Cancel button was clicked or the browser was closed, so stop processing
                    break;
                }
                // simulate a long time performing the current step
                System.Threading.Thread.Sleep(100);
            }
        }



 <telerik:RadProgressManager runat="server" ID="RadProgressManagerCode" />
    <telerik:RadProgressArea ID="RadProgressArea1" runat="server" DisplayCancelButton="True"
        ProgressIndicators="FilesCountBar,
                          FilesCountPercent,                      
                          SelectedFilesCount,                      
                          CurrentFileName,                      
                          TimeElapsed">
    </telerik:RadProgressArea>

 <telerik:RadButton ID="RadButtonProcess" runat="server" Text="Process Comparision"
                    OnClick="RadButtonProcess_Click">
                    <Icon PrimaryIconCssClass="rbConfig" PrimaryIconLeft="4" SecondaryIconTop="4" />
                </telerik:RadButton>
Plamen
Telerik team
 answered on 15 Aug 2012
2 answers
212 views
Using a RadTreeView is it possible to have both server side and client side actions for a node click?  In my application I'm using a RadTreeView to load content into a separate panel when I click on a tree node.  The tree node click should do a call back to retrieve/load data then I'd like to be able to scroll the pane to a div in the content.  Having OnNodeClick and OnClientNodeClicked defined for a RadTreeView causes the client side to fire but not the server side.
john81
Top achievements
Rank 1
 answered on 15 Aug 2012
3 answers
292 views
I have a RadGrid on my page with the last data column being a GridTemplateColumn with a RadComboBox inside of it. I have been going by this example here to help familiarize myself with the RadGrid control. I know there is a DropDown column type, but I want to try and get this TemplateColumn working.

Whenever I click update on a row, my RadComboBox has the list of different Frequencies and has the proper one selected. When I select a different frequency and click update again to save those changes, the frequency isn't saved. It is still the previous one.

I have attached a picture of my model. OpenAccessDataSource is Task while FrequencyDS is TaskFrequency.

Here is my grid:
<telerik:RadGrid ID="RadGrid1" runat="server" CellSpacing="0" GridLines="None"
    AutoGenerateEditColumn="True" DataSourceID="OpenAccessDataSource"
    AllowAutomaticUpdates="True">
    <MasterTableView AutoGenerateColumns="False"
        DataSourceID="OpenAccessDataSource" DataKeyNames="Id">
        <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
        <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column">
            <HeaderStyle Width="20px"></HeaderStyle>
        </RowIndicatorColumn>
        <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">
            <HeaderStyle Width="20px"></HeaderStyle>
        </ExpandCollapseColumn>
        <Columns>
            <telerik:GridBoundColumn DataField="Id" DataType="System.Int32" FilterControlAltText="Filter Id column"
                HeaderText="Id" SortExpression="Id" UniqueName="Id">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="TaskName" FilterControlAltText="Filter TaskName column"
                HeaderText="TaskName" SortExpression="TaskName" UniqueName="TaskName">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="NextRun" FilterControlAltText="Filter NextRun column"
                HeaderText="NextRun" SortExpression="NextRun" UniqueName="NextRun">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="Enabled" DataType="System.Char" FilterControlAltText="Filter Enabled column"
                HeaderText="Enabled" SortExpression="Enabled" UniqueName="Enabled">
            </telerik:GridBoundColumn>
            <telerik:GridTemplateColumn HeaderText="Frequency" DataField="Frequency" UniqueName="Frequency">
                <ItemTemplate>
                    <%# DataBinder.Eval(Container.DataItem, "Frequency") %>
                </ItemTemplate>
                <EditItemTemplate>
                    <telerik:RadComboBox runat="server" ID="FrequencyCB" DataTextField="Name" DataValueField="Name" DataSourceID="FrequencyDS"
                     SelectedValue='<%# DataBinder.Eval(Container.DataItem, "Frequency") %>' />
                </EditItemTemplate>
            </telerik:GridTemplateColumn>
        </Columns>
        <EditFormSettings>
            <EditColumn FilterControlAltText="Filter EditCommandColumn column">
            </EditColumn>
        </EditFormSettings>
    </MasterTableView>
    <FilterMenu EnableImageSprites="False">
    </FilterMenu>
</telerik:RadGrid>
DuelingCats
Top achievements
Rank 2
 answered on 15 Aug 2012
1 answer
47 views
We have a custom user control (let's say Prices.ascx) which is responsible for dynamically creating a number of RadNumericTextbox based on the configuration of a specific object. For example when WidgetA we display 10 price fields dynamically.  This user control works fine on any normal form.

Let's say we have a grid that provides a list of Widgets.  We are using a user control edit form for the widget.  The edit form also includes the custom Prices user control.  In ItemDataBound we call a method on the Prices user control to dynamically create the inputs based on which Widget we are editing.  This display and binding previous price entries works fine.

So we have
Grid
with WidgetEditControl
with Prices user control
On Grid ItemDataBound we call LoadPrices(id) method on the WidgetEditControl which calls another method on the Prices user control which dynamically adds the inputs needed

When attempting to pull in the data to save on the grid update command the viewstate and properties of the Prices user control are lost and we therefore can't pull them in to update.  Is there a way the prices user control can be added and/or bound so that when the update command on the grid fires the data from the prices user control is still available?

Tsvetina
Telerik team
 answered on 15 Aug 2012
3 answers
243 views
Hello,

I really have to say that I enjoy your Header Context Menu for the Rad Grid. I am currently trying to customize it for my project, using HeaderContextMenu_ItemCreated to set "Group by" and "Ungroup" invisible, and OnPreRenderComplete to add my own Rad Menu Items to it.
However, I would like to know how to access the click event of the Rad Menu Items I have added myself. Do I have to add an event handler here?

Thanks in advance,
Robin
Kostadin
Telerik team
 answered on 15 Aug 2012
Narrow your results
Selected tags
Tags
+? more
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?