Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
113 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
308 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
57 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
132 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
147 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
114 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
136 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
1 answer
124 views
I am a freelancer and in discussions with an end customer to develop a web application. The code that I develop will be used by the customer in their organization as a intranet website.

Based on my understanding of licensing (from your site):

1) I will need a developer license to develop the aplication (I intend using RadControl for .NET)
2) A GPL will suffice since the customer is using this for internal use and will not redistribute the software
3) A copyright / acknowledgement of Telerik copyright needs to be place in the About page of the customers intranet application

Please confirm if the above steps and assumptions are correct.

Thanks
Kishore
Apo
Telerik team
 answered on 24 Jan 2013
1 answer
84 views
I have a problem while I deploy our web site into another IIS. Locally from Visual Studio all works fine but when we deploy our site on IIS (7.5 on Windows Server 2008 R2), we have some problems. When I open the 2 web sites (locally from Visual Studio and the other from IIS on Windows Server) in the same IE (2 tabs) and I notice some different behavior in the user interface !?!?!

I cannot tell if it's the case for all problems we have but at least for one problem I notice the problem come from CSS. On a RadTabStrip, I set Orientation="VerticalLeft". So locally it's on the left because the "display" attributes value is "block" but in the server it's not because because both values "block" and "inline" are present and the "inline" is applied!

Can anybody tell me what's wrong?

I attached screen shots...

Nencho
Telerik team
 answered on 24 Jan 2013
1 answer
169 views
Hi Experts,

I have created rad grid with  multiple group header and added the check box in  first grouping header (BATCH_ID).So i want to do,
when i check the   check box in first grouping header then to be selected (highlighted) the grid items belong to second group header (ITEM_NAME)



Grouping  at Design Level
<GroupByExpressions>
<!-- First Grouping Header -->
                        <telerik:GridGroupByExpression>
                            <SelectFields>
                                <telerik:GridGroupByField FieldAlias="BATCH_ID" FieldName="BATCH_ID" HeaderValueSeparator=" : " />
                            </SelectFields>
                            <GroupByFields>
                                <telerik:GridGroupByField FieldName="BATCH_ID" SortOrder="Ascending" />
                            </GroupByFields>
                        </telerik:GridGroupByExpression>
<!-- Second Grouping Header -->
                        <telerik:GridGroupByExpression>
                            <SelectFields>
                                <telerik:GridGroupByField FieldAlias="Name" FieldName="EMP_DISPLAY_NAME" HeaderValueSeparator=" : " />
                            </SelectFields>
                            <GroupByFields>
                                <telerik:GridGroupByField FieldName="ITEM_NAME" SortOrder="Ascending" />
                            </GroupByFields>
                        </telerik:GridGroupByExpression
</GroupByExpressions>

         Create Header control at run time
Private Sub CreateHeaderControls(ByVal e As GridItemEventArgs)
        If TypeOf e.Item Is GridGroupHeaderItem Then
            Dim item As GridGroupHeaderItem = e.Item
            If IsNumeric(item.GroupIndex.ToString()) Then
                item.DataCell.Controls.Clear()
                Dim check As New CheckBox()
                check.AutoPostBack = True
                check.ID = "CheckAll"
                AddHandler check.CheckedChanged, AddressOf check_CheckedChanged
                item.DataCell.Controls.Add(check)
            End If
        End If
    End Sub


Thanks
Angel Petrov
Telerik team
 answered on 24 Jan 2013
Narrow your results
Selected tags
Tags
+? more
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?