Telerik Forums
UI for ASP.NET AJAX Forum
3 answers
998 views

Can you tell me how I can hide the First, Previous, Next, and Last pager buttons in a radgrid?

I am able to hide the Page Size related controls in the code behind by using this code:
            Label changePageSizeLabel = (Label)e.Item.FindControl("ChangePageSizeLabel");
            changePageSizeLabel.Visible = false;
            Button changePageSizeLinkButton = (Button)e.Item.FindControl("ChangePageSizeLinkButton");
            changePageSizeLinkButton.Visible = false;
            RadNumericTextBox changePageSizeText = (RadNumericTextBox)e.Item.FindControl("ChangePageSizeTextBox");
            changePageSizeText.Visible = false;

And I am able to hide the text that displays next to those buttons in the markup by using this code:
<PagerStyle Mode="NextPrevNumericAndAdvanced" CssClass="quotePager" Position="TopAndBottom"  HorizontalAlign="Center" 
                        FirstPageText="" PrevPageText="" NextPageText="" LastPageText="" />

But I cannot figure out how to hide the buttons mentioned above?
Is there an ID I can use for each of them to find them and set them to visible=false in the code-behind?
Is there an attribute I can use for each of them to set them in the pagerstyle element in the markup?
Thank you
Bill
Top achievements
Rank 1
 answered on 24 Jan 2013
1 answer
51 views
Hello,
I have added an Recurrence Editor in a RadDock. When I load the page at first, IE-9 goes to 'compatibility view'. When my RadDock is loaded, some text boxes in the recurrence editor looks like as shown in the attachment. Please note that I have a limitation, where I cant change the 'browser mode' of IE-9. If there are CSS which can fix this issue it will be very helpful. 
*This is a SharePoint project.
Plamen
Telerik team
 answered on 24 Jan 2013
3 answers
867 views
I want to be able to set an item to a currency or date format depending upon its name.

Something like the following, but for the ItemDataBound event, not the ColumnCreated event.

How would I be able to accomplish that?
protected void RadGrid1_ColumnCreated(object sender, Telerik.Web.UI.GridColumnCreatedEventArgs e)
    {
        if (e.Column is GridBoundColumn && (e.Column as GridBoundColumn).DataField == "Sales")
        {
            (e.Column as GridBoundColumn).DataFormatString = "{0:C}";
        }
    }
Bill
Top achievements
Rank 2
 answered on 24 Jan 2013
1 answer
84 views
I installed this version of 'telerik radcontrols' in my 'visual studio 2012' but the controls do not appear in my toolbox how do i fix this?
MasterChiefMasterChef
Top achievements
Rank 2
 answered on 24 Jan 2013
1 answer
287 views

I am executing an SSRS rpt and need to duplicate this in a web project with sqldatasource id's.

The ssrs rpt parameters work perfectly as far as being populated, but when I try to get the same thing done in the web version, the second parameter list never gets populated.

The Ship parameter depends upon what is selected in the CruiseLine parameter.

The parameters in the web version are as follows:

<tr>
                <td>
                    Select a CruiseLine:
                    <telerik:radcombobox id="RadComboBox1" runat="server" checkboxes="True" enablecheckallitemscheckbox="False"
                        skin="Web20" sort="Ascending" allowcustomtext="True" datasourceid="SqlDataSource1"
                        datatextfield="CruiseLine" datavaluefield="CruiseLine">
                    </telerik:radcombobox>
                    <asp:RequiredFieldValidator runat="server" ID="RequiredFieldValidator3" ValidationGroup="A"
                        ControlToValidate="RadComboBox1" ErrorMessage="Choose a CruiseLine!"></asp:RequiredFieldValidator>
                </td>
                <td>
                    Select a Ship:
                    <telerik:radcombobox id="RadComboBox2" runat="server" checkboxes="True" enablecheckallitemscheckbox="False"
                        skin="Web20" sort="Ascending" allowcustomtext="True" datasourceid="SqlDataSource2"
                        datatextfield="Ship" datavaluefield="Ship">
                    </telerik:radcombobox>
                    <asp:RequiredFieldValidator runat="server" ID="RequiredFieldValidator2" ValidationGroup="A"
                        ControlToValidate="RadComboBox2" ErrorMessage="Choose a Ship!"></asp:RequiredFieldValidator>
                </td>
            </tr>

Here are the corresponidng SQL data sources:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:PrepaidConnectionString %>"
            SelectCommand="SelectCruiseLine" DataSourceMode="DataSet" EnableCaching="true"
            SelectCommandType="StoredProcedure"></asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:PrepaidConnectionString %>"
            SelectCommand="SelectShip" DataSourceMode="DataSet" EnableCaching="true" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:Parameter Name="CruiseLine" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>

The first sqldatasource executes the following sql (from a stored procedure and populates the list with no problem:
SELECT DISTINCT CruiseLine
        FROM dbo.ShipProductPrices
        ORDER BY CruiseLine

The second sqldatasource executes the following sql (also from a stored procedure):
ALTER PROCEDURE [dbo].[SelectShip] 
@CruiseLine NVARCHAR(MAX)
AS
BEGIN
    SET NOCOUNT ON;
  
    SELECT DISTINCT Ship
        FROM dbo.ShipProductPrices
        WHERE CruiseLine IN (SELECT * FROM dbo.SplitParameterValues(@CruiseLine, ','))
        ORDER BY Ship
END

For now, I'm just selecting one cruiseline and I expect that when I pull down the dropdownlist for the second combobox, it should run a query similiar to the following and have the Ship combobox populated:
SELECT DISTINCT Ship
        FROM dbo.ShipProductPrices
        WHERE CruiseLine IN (SELECT * FROM dbo.SplitParameterValues('CCL', ','))
        ORDER BY Ship

Notice the parameter type of the Ship combobox and the type of the SelectParameter of the SelectShip datasource. They are a little bit different. Don't know if this makes a difference or not.

The SelectShip SPROC executes a UDF which again is part of the sproc that I ran above manually with data coming out in sql management studio.

What do I need to do in order to populate the second combobox?

Hristo Valyavicharski
Telerik team
 answered on 24 Jan 2013
1 answer
52 views
Hi

I am facing a big issue,

When we set the scheduler selecteddate in page load by another date picked which located in the same page, That time all the appoints are went to invisible..y this happnd.....?

Am using vb.net ..

any idea?pls help me its urg

RadScheduler1.SelectedDate= rdDatePicker.SelectedDate

 

Boyan Dimitrov
Telerik team
 answered on 24 Jan 2013
4 answers
119 views
I'm working on a desktop like interface using multiple radwindows on a single page. Right now I am trying to add functionality similar to the Windows 7 Show Desktop button that hides all open windows on click, and then restores all the windows on a second click. I have that funcionality working for the most part using minimizeAll() to hide everything and then a call to showAll(), to get the window titlebars back in place, and then a call to restoreAll() to get the windows back to their previous size. 

The problem I am running into is that when a window is closed it is not truly destroyed. Therefore when I go to show my windows again the closed window comes back. I know I can switch the DestroyOnClose flag to true for the windows, which does solve this issue, but it breaks my event handlers for the close event on all other windows. When a window is created a set a handler for many events, close being one of them, like so:
oWnd.add_close(function (sender, args) {
        windowHandler(sender, "close");
    });
This allows all windows to use my handler function which essentially takes the window information (title, url, x, y, width, height) and saves them for later use. That all works fine until I turn DestroyOnClose to true. Once that is done, only the first window closed executes the handler. Any window closed after that ignores the handler entirely as if the binding for that even was destroyed for all windows, not just the window being closed. 

Is there something I can do to solve either one of these issues so that both pieces of the functionality work?
Corey
Top achievements
Rank 1
 answered on 24 Jan 2013
2 answers
140 views
Hi 
What is the server side equivalent of client side OnDateSelected in DatePicker control.
I need to use the selected date in server side code. 

Thanks.
Priya
Top achievements
Rank 1
 answered on 24 Jan 2013
2 answers
107 views
Is there a way to declaratively format individual filters? For instance, to have some align left, some align center, and each have different widths. I'd like to avoid a FilterTemplate, and ideally I'd like to do it in the markup, but if I have to, I'll just do it in the back end. Sample:

<telerik:RadGrid ID="RadGrid" runat="server" AutoGenerateColumns="False" AllowSorting="True"
            AllowFilteringByColumn="True">
  <ClientSettings AllowColumnsReorder="True">
    <Scrolling UseStaticHeaders="True" AllowScroll="True" SaveScrollPosition="True"
            ScrollHeight="500px"/>
  </ClientSettings>
             
  <GroupingSettings CaseSensitive="False"/>
 
  <MasterTableView>
    <Columns>
      <telerik:GridBoundColumn UniqueName="Name" DataField="Name" HeaderText="Name"
                        AutoPostBackOnFilter="True" HeaderStyle-Width="35%"
                        ItemStyle-HorizontalAlign="Left"/>
      <telerik:GridBoundColumn UniqueName="Common" DataField="Common" HeaderText="Common"
                        AutoPostBackOnFilter="True"
                        HeaderStyle-HorizontalAlign="Center"/>
    </Columns>
  </MasterTableView>
</telerik:RadGrid>
J
Top achievements
Rank 1
 answered on 24 Jan 2013
1 answer
129 views
Hi,

When I export data to Excel from a RadGrid with an external RadFilter, I get all the data instead of the filtered data.

I use during export:

Protected Sub Export_Klanten_Click(sender As Object, e As EventArgs) Handles btn_Export_Klanten.Click
 
RadFilter2.FireApplyCommand()
 
dtgKlanten.ExportSettings.ExportOnlyData = true     
dtgKlanten.ExportSettings.IgnorePaging = true
dtgKlanten.MasterTableView.AllowFilteringByColumn = false
dtgKlanten.ExportSettings.OpenInNewWindow = true
dtgKlanten.ExportSettings.HideStructureColumns = true
dtgKlanten.MasterTableView.ExportToExcel()
End Sub
 
Protected Sub RadFilter2_ApplyExpressions(sender As Object, e As RadFilterApplyExpressionsEventArgs)
    Dim provider As New RadFilterSqlQueryProvider()
    provider.ProcessGroup(e.ExpressionRoot)
    dtgKlanten.MasterTableView.FilterExpression = provider.Result
    dtgKlanten.Rebind()
End Sub

I thought this would filter the datasource on exporting, but is does not.

Any suggestions?

Marc
Fit2Page
Top achievements
Rank 2
Bronze
Iron
Iron
 answered on 24 Jan 2013
Narrow your results
Selected tags
Tags
+? more
Top users last month
Top achievements
Rank 1
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ivory
Top achievements
Rank 1
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
YF
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Top achievements
Rank 1
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ivory
Top achievements
Rank 1
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
YF
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?