Telerik Forums
UI for ASP.NET AJAX Forum
4 answers
140 views
I permit to contact you because I’ve a problem with a telerik:RadGrid component and the Export Fonction

In fact, we have the PageSize of 20 but we want to export all data without filter.

I developed the code like this:

       <telerik:RadGrid  ID="xxxxxxx" runat="server" DataSourceID="xxxxx"  OnItemCommand="ApplicationDependency_ItemCommand" OnItemDataBound="ApplicationDependency_ItemDataBound" OnItemCreated="ApplicationDependency_ItemCreated" AutoGenerateColumns="False" AllowPaging="True" AllowFilteringByColumn="True"  PageSize="20"  AllowCustomPaging="True" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" ClientSettings-AllowColumnsReorder="false" AllowSorting="True" CellSpacing="0" GridLines="None" Height="800px" ShowGroupPanel="True">
              <ExportSettings
                FileName="ApplicationDependency"
                ExportOnlyData="true"
                IgnorePaging="true"
                UseItemStyles="true"
                ></ExportSettings>

It works fine on my local Pc and on the Acceptance Server. But in Production it doesn’t work and the export give me just the 20 firsts lines. For me, the only difference is IIS 7.5on the production and IIS 8 for Acceptence.
Kostadin
Telerik team
 answered on 27 Jul 2016
3 answers
76 views

Hi. i am required to export the data from RadGrid into excel on Sharepoint 2013 custom webpart. i have the following issue

  1. the export file is empty. i.e the file does not have any workbook/worksheet being created
  2. i have a external xml with the excel setting and styling from ASP global resource. how can i add this in during export?

ascx markup

01.<telerik:RadGrid RenderMode="Lightweight" runat="server" ID="gridCourse" AllowPaging="True" AutoGenerateColumns="False" AllowSorting="true" PageSize="14"
02.        OnSortCommand="gridCourse_SortCommand" OnPageIndexChanged="gridCourse_PageIndexChanged" OnExcelMLExportRowCreated="gridCourse_ExcelMLExportRowCreated"
03.        OnPageSizeChanged="gridCourse_PageSizeChanged" AllowMultiRowSelection="true">
04.      <MasterTableView PagerStyle-Mode="NumericPages" PagerStyle-Position="TopAndBottom" PagerStyle-HorizontalAlign="Right" UseAllDataFields="true">
05.          <Columns>
06.                <telerik:GridTemplateColumn HeaderStyle-Font-Bold="true" SortExpression="id" UniqueName="id" HeaderText="Course ID" ItemStyle-HorizontalAlign="Center" ItemStyle-VerticalAlign="Middle">
07.                    <ItemTemplate>
08.                   <asp:HyperLink ID="lnkId" runat="server" NavigateUrl='<%# string.Format(manageCourseURL, HttpUtility.UrlEncode(Eval("id").ToString())) %>' Text='<%# Eval("id") %>'></asp:HyperLink>
09.                <asp:Label runat="server" ID="lblCourseId" Visible="false" Text='<%# Eval("id") %>'></asp:Label>
10.               </ItemTemplate>
11.                </telerik:GridTemplateColumn>
12.                <telerik:GridBoundColumn HeaderStyle-Font-Bold="true" UniqueName="courseCode" ItemStyle-Width="150" ItemStyle-HorizontalAlign="Center" ItemStyle-VerticalAlign="Middle"
13.                    SortExpression="courseCode" HeaderText="Course Code" DataField="courseCode">
14.                </telerik:GridBoundColumn>
15.              <telerik:GridBoundColumn HeaderStyle-Font-Bold="true" UniqueName="courseTitle" ItemStyle-Width = "250" ItemStyle-HorizontalAlign="Center" ItemStyle-VerticalAlign="Middle"
16.                    SortExpression="courseTitle" HeaderText="Course Title" DataField="courseTitle">
17.                </telerik:GridBoundColumn>
18.              <telerik:GridBoundColumn HeaderStyle-Font-Bold="true" UniqueName="courseType" ItemStyle-Width = "150" ItemStyle-HorizontalAlign="Center" ItemStyle-VerticalAlign="Middle"
19.                    SortExpression="courseType" HeaderText="Course Type" DataField="courseType">
20.                </telerik:GridBoundColumn>
21.              <telerik:GridBoundColumn HeaderStyle-Font-Bold="true" UniqueName="courseTemplate" ItemStyle-Width = "150" ItemStyle-HorizontalAlign="Center" ItemStyle-VerticalAlign="Middle"
22.                    SortExpression="courseTemplate" HeaderText="Course Template" DataField="courseTemplate">
23.                </telerik:GridBoundColumn>
24.              <telerik:GridBoundColumn HeaderStyle-Font-Bold="true" UniqueName="duration" ItemStyle-Width = "80" ItemStyle-HorizontalAlign="Center" ItemStyle-VerticalAlign="Middle"
25.                    SortExpression="duration" HeaderText="Duration" DataField="duration">
26.                </telerik:GridBoundColumn>
27.              <telerik:GridBoundColumn HeaderStyle-Font-Bold="true" UniqueName="status" ItemStyle-Width = "60" ItemStyle-HorizontalAlign="Center" ItemStyle-VerticalAlign="Middle"
28.                    SortExpression="status" HeaderText="Status" DataField="status">
29.                </telerik:GridBoundColumn>
30.               <telerik:GridBoundColumn HeaderStyle-Font-Bold="true" UniqueName="modifiedDate" ItemStyle-Width = "200" ItemStyle-HorizontalAlign="Center" ItemStyle-VerticalAlign="Middle"
31.                    SortExpression="modifiedDate" HeaderText="Last Modified Date" DataField="modifiedDate" DataFormatString="{0:d MMMM yyyy hh:mm tt}" htmlencode="false">
32.                </telerik:GridBoundColumn>
33.              <telerik:GridClientSelectColumn UniqueName="chkCell" ItemStyle-Width="10">
34.                </telerik:GridClientSelectColumn>
35.          </Columns>
36.      </MasterTableView>
37.        <ClientSettings>
38.            <Selecting AllowRowSelect="true"></Selecting>
39.        </ClientSettings>
40.        </telerik:RadGrid>

 

code behind

01.protected void btnExport_Click(object sender, EventArgs e)
02.{
03.    gridCourse.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
04.    gridCourse.ExportSettings.ExportOnlyData = true;
05.    gridCourse.ExportSettings.IgnorePaging = true;
06.    gridCourse.ExportSettings.OpenInNewWindow = true;
07.    gridCourse.ExportSettings.FileName = export.getResourceString("litExportFilename");
08.    gridCourse.ExportToExcel();
09.}
10. 
11.protected void gridCourse_ExcelMLExportRowCreated(object sender, Telerik.Web.UI.GridExcelBuilder.GridExportExcelMLRowCreatedArgs e)
12.{
13.   e.Worksheet.Name = export.getResourceString("litExcelDefaultWorksheetName");
14.}

Benjamin
Top achievements
Rank 1
 answered on 27 Jul 2016
2 answers
83 views
Hi, I wanted to know if there was a way to edit the default template for the tasks.I have explored client templates but you lose the percent complete functionality when you do this and I'd like to keep that. Specifically visually seeing the percent complete highlight as well as adjusting the percent complete by moving the slider. If there was a way to add custom text to the default task, that would be perfect. 
Sam
Top achievements
Rank 1
 answered on 26 Jul 2016
1 answer
207 views

Hi There,

I have a 3-Month view RadCalender in my page, however, the control  crossed the border of my page. As shown in the attached screenshot, I would like to set the RadCalendar inside the the Red area. I figured that the width of the Calendar control can only set to the value larger than "280px". The control size does not change at all when I set the width value to "220px". Is there any way to make the RadCalendar fit my page?

My second question is, the look and feel of the RadCalendar in my page is not the same as shown in the Telerik RadCalendar demos, please see the attached screenshot files. I use the same code as the Telerik demos, how to make it looks the same as the demos? Please help.

Any suggestions is much appreciated. 

 

Meng
Top achievements
Rank 1
 answered on 26 Jul 2016
8 answers
333 views
Hi,
I have a RadGrid (parent) which is having another radGrid (child) inside the NestedViewTemplate.
I am providing the datasource of parent from code behind need datasource.

How can I bind the child radgrid from codebehind based upon the a column/datakey value of the parent grid?

In below code I have to fill the child grid with the  values sent by OAHSSQ column.



<telerik:RadGrid ID="radGridShippedOrders" runat="server" GridLines="None" AllowPaging="True"
            PageSize="10" AllowSorting="True" AutoGenerateColumns="false" ShowStatusBar="true"
            HorizontalAlign="NotSet" AllowMultiRowEdit="false" OnNeedDataSource="radGridShippedOrders_NeedDataSource" 
            OnItemDataBound="radGridShippedOrders_ItemDataBound" OnItemCommand="radGridShippedOrders_OnItemCommand"
            Width="800px" AllowMultiRowSelection="False" AllowFilteringByColumn="true" ShowGroupPanel="True">
            <PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true"></PagerStyle>
            
            <ExportSettings ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true">
                 <Pdf PageTitle="Shipped Orders" />
            </ExportSettings>


            <MasterTableView GroupLoadMode="Client" CommandItemDisplay="Bottom" DataKeyNames="OAHSSQ" Name="MTVShippedOrders">
                <CommandItemTemplate>
                    <asp:Button ID="DownloadPDF" runat="server" CommandName="ExportToPdf" Text="Export" />
                </CommandItemTemplate>
                <CommandItemSettings ShowExportToExcelButton="true" />
                <Columns>
                    <telerik:GridBoundColumn UniqueName="OACONO" HeaderText="OACONO" DataField="OACONO">
                    </telerik:GridBoundColumn>                
                    <telerik:GridBoundColumn UniqueName="OAINNO" HeaderText="OAINNO" DataField="OAINNO">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn UniqueName="OAORNO" HeaderText="OAORNO" DataField="OAORNO">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn UniqueName="OAORGN" HeaderText="OAORGN" DataField="OAORGN">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn UniqueName="OAHSSQ" HeaderText="OAHSSQ" DataField="OAHSSQ">
                    </telerik:GridBoundColumn>
                                     
                </Columns>
                
                <NestedViewTemplate>
                
                    <telerik:RadGrid ID="radGridInvoiceHeader" runat="server" GridLines="None" AllowPaging="True"
                        PageSize="20" AllowSorting="True" AutoGenerateColumns="true" ShowStatusBar="true"
                        HorizontalAlign="NotSet" AllowMultiRowEdit="false" 
                        Width="100%" AllowMultiRowSelection="False" AllowFilteringByColumn="false">
                        <PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true"></PagerStyle>
                    </telerik:RadGrid>

</NestedViewTemplate>
                                
                
            </MasterTableView>
             <ClientSettings AllowGroupExpandCollapse="True" ReorderColumnsOnClient="True" AllowDragToGroup="True"
                AllowColumnsReorder="True">
            </ClientSettings>
             <GroupingSettings ShowUnGroupButton="true" />
        </telerik:RadGrid>
Makunda
Top achievements
Rank 1
 answered on 26 Jul 2016
0 answers
85 views

Today I ran into an issue with a grid that is linked to a LinqDataSource via DataSourceId and no ViewState.

Initially, everything works fine but after a postback (paging, sorting, filtering), the Selecting event of the LinqDataSource is fired twice, once before page_load and once after. The problem is that this will cause an expensive query to run twice.

Anybody experienced this problem? With ViewState enabled, everything works fine.

Thanks, Martijn

martijnb
Top achievements
Rank 1
 asked on 26 Jul 2016
1 answer
51 views
I found example code RadSchedule and webservice, but example using xml data. Please for example code using RadSchedule ajax vs WCF web service with provider database (not xml data file).
Peter Milchev
Telerik team
 answered on 26 Jul 2016
9 answers
657 views
HI ALL

Every time I update to a new version of Telerik Radcontrols we get the "Failed to create designer" view error back,before instal my version is 2012.2.607.40  and now 2012.2.912.40

we have attached an image herewith


devolpment team 
(Rohan & Hasindu)
Ibrahim
Top achievements
Rank 1
 answered on 26 Jul 2016
0 answers
93 views

Hi

We use RadGrid as a single Grid for many tables.

We bind the radGrid at runtime at the OnInit event, and showing the values is not an issue, it works fine.

We have for example table of Users with some columns such as: Name, ID, Phone number and UserType, this UserType column holds a foreign key number in DB, but those keys represent text from another table, let's say "UserTypeTable".

The grid should show the text - so we bind the grid with a view, and it works great.

The problem starts when we need to allow to edit, then we should know whether it's a "Normal" field or "ForeignKey" field and if it's ForeignKey field, it should be a combobox with relevant values.

Same about filters, for normal fields the filter is normal, but for ForeignKey fields, the filter should be combobox.

All this should be dynamically and work at runtime.

Is it possible at all?

 

Thanks,

Eliran

yigal
Top achievements
Rank 1
 asked on 26 Jul 2016
2 answers
481 views

I have two RadDatePicker control for Start Date and End Date selections. The tabbing should be in order from Start Date textbox (tabindex=1), then to Start Date calendar icon(tabindex=2), then to End Date textbox(tabindex=3) and to End Date calendar icon(tabindex=4).

My issues were every time I hit the Start Date calendar icon and select a date, the focus always appear on the Textbox of Start Date and the tabbing start in Start Date textbox. Even I hit the End Date calendar icon and after selecting a date, the tabbing start in Start Date textbox again.

I want the focus stay in the calendar icon every time I select a date, so that the tabbing will be in order.

Please help...I spent a lot of time of searching a solutions in the internet and can't find anything that I can use. Thanks in advance....

<tr>
   <td width="160px">Start Date</td>
    <td>
                                <telerik:RadDatePicker ID="dtFrom" runat="server" title="Start Date Entry" TabIndex="1" >
                                    <DatePopupButton ToolTip="Open Start Date Calendar popup" />                                    
                                    <Calendar ID="Calendar1"  runat="server" NavigationNextToolTip="NextMonth" NavigationPrevTooltip="PreviousMonth" FastNavigationNextToolTip="NextMonth3" FastNavigationPrevToolTip="PreviousMonth3" EnableKeyboardNavigation="true" TabIndex="2" CalendarCaption="Start Date Calendar">
                                    </Calendar>   
                                </telerik:RadDatePicker>
                                <asp:RequiredFieldValidator ID="rvStart" runat="server" ErrorMessage="Travel Start Date is Required" ControlToValidate="dtFrom"></asp:RequiredFieldValidator>

    </td>
  </tr>
   <tr>
   <td>End Date                                                     
    </td>
    <td>
                                <telerik:RadDatePicker ID="dtTo" name="dtTo" runat="server" title="End Date Entry" TabIndex="3">
                                    <DatePopupButton ToolTip="Open End Date Calendar popup" />
                                    <Calendar ID="Calendar2" runat="server" NavigationNextToolTip="NextMonth" NavigationPrevTooltip="PreviousMonth" FastNavigationNextToolTip="NextMonth3" FastNavigationPrevToolTip="PreviousMonth3" EnableKeyboardNavigation="true" TabIndex="4" CalendarCaption="End Date Calendar">
                                    </Calendar>
                                </telerik:RadDatePicker>
                                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="Travel End Date is Required" ControlToValidate="dtTo"></asp:RequiredFieldValidator>

</td>
 </tr>

 

G
Top achievements
Rank 1
 answered on 26 Jul 2016
Narrow your results
Selected tags
Tags
+? more
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?