Questions on UI for ASP.NET AJAX Forum

1 answer

82 views

CSV Export Issue :- ">>" getting Converted into '&'gt; &'gt; " as well as empty cells coming as &'nbsp:'

Hi ,

I have a telerik grid("Version=5.0.1.0") which is getting filled from SQL datasource.

ISSUE 1:
If Cell value is 'April>>test1>>Section1>>A' then after exporting to CSV it comes as
'April>>test1>>Section1>>A'

ISSUE 2:
Empty cell or cell having value " " are getting converting to " ". while exporting to the CSV.

General Discussions

answered on 04 Apr 2013

1 answer

62 views

CSV Export Issue :- ">>" getting Converted into "> > " as well as empty cells coming as &nbsp

Hi ,

I have a telerik RAD grid("Version=5.0.1.0") which is getting data from SQL datasource.

ISSUE 1:
If Cell value is 'April>>test1>>Section1>>A' then after exporting to CSV it comes as
'April>>test1>>Section1>>A'

ISSUE 2:
Empty cell or cell having value " " are getting converting to " ". while exporting to the CSV.

General Discussions

answered on 04 Apr 2013

18 answers

356 views

Accessing a RadGrid within a RadGrids ItemTemplate

I am trying to export two different rad grids on one excel file. I followed an example I found posed in the formums but am having issues acessing the radgrids that are inside of the itemtemplate of the RadGrid i want to export. I have the following ASPX code:

    
            <telerik:RadGrid ID="telerikBatchExportGrid" runat="server">  
        
                                        <MasterTableView> 
        
                                            <ItemTemplate> 
        
                                                <telerik:RadGrid ID="telerikTransBatchGrid" runat="server" AutoGenerateColumns="false" 
        
                                                    AllowFilteringByColumn="true" AllowSorting="true" AllowPaging="true" Skin="BlueGrid" 
        
                                                    EnableEmbeddedSkins="false" AllowMultiRowSelection="false" Width="570px" PagerStyle-AlwaysVisible="true" 
        
                                                    ShowFooter="true" OnNeedDataSource="telerikTransBatchGrid_NeedDataSource" OnInit="telerikTransBatchGrid_Init">  
        
                                                    <PagerStyle Mode="NextPrevAndNumeric" /> 
        
                                                    <GroupingSettings CaseSensitive="False" /> 
        
                                                    <MasterTableView Width="570px">  
        
                                                        <Columns> 
        
                                                            <telerik:GridBoundColumn DataField="TrackingNumber" HeaderText="Tracking #" UniqueName="TrackingNumber" /> 
        
                                                            <telerik:GridBoundColumn DataField="IndividualName" HtmlEncode="false" HeaderText="Name" 
        
                                                                ItemStyle-HorizontalAlign="left" HeaderStyle-HorizontalAlign="center" /> 
        
                                                            <telerik:GridBoundColumn DataField="EffectiveDate" HtmlEncode="false" HeaderText="Orig Date" 
        
                                                                ItemStyle-HorizontalAlign="left" HeaderStyle-HorizontalAlign="center" DataFormatString="{0:d}" 
        
                                                                FilterControlWidth="50px" /> 
        
                                                            <telerik:GridBoundColumn DataField="Status" HtmlEncode="false" HeaderText="Status" 
        
                                                                UniqueName="Status" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="center">  
        
                                                                <FilterTemplate> 
        
                                                                    <telerik:RadScriptBlock ID="RadScriptsBlockStatus" runat="server">  
        
                                                                        <script type="text/javascript">  
        
                                                                function StatusSelectedIndexChanged2(sender, args) {  
        
                                                                    var tableView = $find("<%# TryCast(Container, GridItem).OwnerTableView.ClientID %>");  
        
                                                                    tableView.filter("Status", args.get_item().get_value(), "EqualTo");  
        
                                                                }  
        
                                                                        </script> 
        
                                                                    </telerik:RadScriptBlock> 
        
                                                                    <telerik:RadComboBox ID="telerikDDLStatusFilter" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("Status").CurrentFilterValue %>' 
        
                                                                        runat="server" OnClientSelectedIndexChanged="StatusSelectedIndexChanged2" Width="85px">  
        
                                                                        <Items> 
        
                                                                            <telerik:RadComboBoxItem Text="All" Value="" /> 
        
                                                                            <telerik:RadComboBoxItem Text="Pending" Value="Pending" /> 
        
                                                                            <telerik:RadComboBoxItem Text="Sent" Value="Sent" /> 
        
                                                                            <telerik:RadComboBoxItem Text="Funded" Value="Funded" /> 
        
                                                                            <telerik:RadComboBoxItem Text="Failed" Value="Failed" /> 
        
                                                                            <telerik:RadComboBoxItem Text="Approved" Value="Approved" /> 
        
                                                                            <telerik:RadComboBoxItem Text="Refunded" Value="Refunded" /> 
        
                                                                            <telerik:RadComboBoxItem Text="Reversal Requested" Value="Reversal Requested" /> 
        
                                                                            <telerik:RadComboBoxItem Text="Reversal Complete" Value="Reversal Complete" /> 
        
                                                                        </Items> 
        
                                                                    </telerik:RadComboBox> 
        
                                                                </FilterTemplate> 
        
                                                            </telerik:GridBoundColumn> 
        
                                                            <telerik:GridBoundColumn DataField="Amount" HtmlEncode="false" HeaderText="Amount" 
        
                                                                UniqueName="Amount" ItemStyle-HorizontalAlign="right" HeaderStyle-HorizontalAlign="center" 
        
                                                                DataFormatString="{0:C}" Aggregate="sum" FooterStyle-HorizontalAlign="right" 
        
                                                                FilterControlWidth="50px" FooterStyle-Font-Bold="true">  
        
                                                            </telerik:GridBoundColumn> 
        
                                                        </Columns> 
        
                                                    </MasterTableView> 
        
                                                </telerik:RadGrid> 
        
                                                <br /> 
        
                                                <h3> 
        
                                                    Client Transactions</h3> 
        
                                                <telerik:RadGrid ID="telerikClientTransBatchGrid" runat="server" AutoGenerateColumns="false" 
        
                                                    AllowFilteringByColumn="true" AllowSorting="true" AllowPaging="true" Skin="BlueGrid" 
        
                                                    EnableEmbeddedSkins="false" AllowMultiRowSelection="false" Width="570px" PagerStyle-AlwaysVisible="true" 
        
                                                    ShowFooter="true" OnNeedDataSource="telerikClientTransBatchGrid_NeedDataSource" OnInit="telerikClientTransBatchGrid_Init">  
        
                                                    <PagerStyle Mode="NextPrevAndNumeric" /> 
        
                                                    <GroupingSettings CaseSensitive="False" /> 
        
                                                    <MasterTableView Width="570px">  
        
                                                        <Columns> 
        
                                                            <telerik:GridBoundColumn DataField="TrackingNumber" HeaderText="Tracking #" UniqueName="TrackingNumber">  
        
                                                            </telerik:GridBoundColumn> 
        
                                                            <telerik:GridBoundColumn DataField="IndividualName" HtmlEncode="false" HeaderText="Name" 
        
                                                                ItemStyle-HorizontalAlign="left" HeaderStyle-HorizontalAlign="center" /> 
        
                                                            <telerik:GridBoundColumn DataField="LogDate" HtmlEncode="false" HeaderText="Orig Date" 
        
                                                                ItemStyle-HorizontalAlign="left" HeaderStyle-HorizontalAlign="center" DataFormatString="{0:d}" 
        
                                                                FilterControlWidth="50px" /> 
        
                                                            <telerik:GridBoundColumn DataField="Status" HtmlEncode="false" HeaderText="Status" 
        
                                                                UniqueName="Status" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="center">  
        
                                                                <FilterTemplate> 
        
                                                                    <telerik:RadScriptBlock ID="RadScriptsBlockClientStatus" runat="server">  
        
                                                                        <script type="text/javascript">  
        
                                                                function StatusSelectedIndexChanged3(sender, args) {  
        
                                                                    var tableView = $find("<%# TryCast(Container, GridItem).OwnerTableView.ClientID %>");  
        
                                                                    tableView.filter("Status", args.get_item().get_value(), "EqualTo");  
        
                                                                }  
        
                                                                        </script> 
        
                                                                    </telerik:RadScriptBlock> 
        
                                                                    <telerik:RadComboBox ID="telerikDDLStatusFilter" SelectedValue='<%# TryCast(Container,GridItem).OwnerTableView.GetColumn("Status").CurrentFilterValue %>' 
        
                                                                        runat="server" OnClientSelectedIndexChanged="StatusSelectedIndexChanged3" Width="85px">  
        
                                                                        <Items> 
        
                                                                            <telerik:RadComboBoxItem Text="All" Value="" /> 
        
                                                                            <telerik:RadComboBoxItem Text="Pending" Value="Pending" /> 
        
                                                                            <telerik:RadComboBoxItem Text="Sent" Value="Sent" /> 
        
                                                                            <telerik:RadComboBoxItem Text="Funded" Value="Funded" /> 
        
                                                                            <telerik:RadComboBoxItem Text="Failed" Value="Failed" /> 
        
                                                                        </Items> 
        
                                                                    </telerik:RadComboBox> 
        
                                                                </FilterTemplate> 
        
                                                            </telerik:GridBoundColumn> 
        
                                                            <telerik:GridBoundColumn DataField="Amount" HtmlEncode="false" HeaderText="Amount" 
        
                                                                UniqueName="Amount" ItemStyle-HorizontalAlign="right" HeaderStyle-HorizontalAlign="center" 
        
                                                                DataFormatString="{0:C}" Aggregate="sum" FooterStyle-HorizontalAlign="right" 
        
                                                                FilterControlWidth="50px" FooterStyle-Font-Bold="true">  
        
                                                            </telerik:GridBoundColumn> 
        
                                                        </Columns> 
        
                                                    </MasterTableView> 
        
                                                </telerik:RadGrid> 
        
                                            </ItemTemplate> 
        
                                        </MasterTableView> 
        
                                    </telerik:RadGrid>\

How do I access the internal RadGrids? I have tried the following with no sucess

    
            CType(Me.telerikBatchExportGrid.MasterTableView.FindControl("telerikTransBatchGrid"), Telerik.Web.UI.RadGrid)  
        
            CType(Me.telerikBatchExportGrid.MasterTableView.Items(0).FindControl("telerikTransBatchGrid"), Telerik.Web.UI.RadGrid)

Grid

answered on 04 Apr 2013

1 answer

373 views

[Solved] Disable edit mode on clicking a button inside the Radgrid

Hi
When i press the edit button in the radgrid, the grid enters a Inplace Editmode. wat i want is when i click on a button in that particular editable row , the edit mode is set to false.. Help me with the code . Thanx in Advance..

Grid

answered on 04 Apr 2013

2 answers

125 views

Client Update Edit Control

I have a date time picker control in an edit form of a rad grid. I added a button to the edit for to get the current date and update the selected date of the date time picker. I can't seem to get the code correct. I get the following javascript error:

Error: Object doesn't support property or method 'set_selectedDate'

Here is the javascript function and the aspx markup:

Can some please help me figure out a way to update the selected date when the button in click in the edit form?

function AccessOnclient() {

var grid = $find("<%= radGrid.ClientID %>");

if (grid) {

var EditItems = grid.get_editItems();

for (var i = 0; i < EditItems.length; i++) {

var editItem = EditItems[0];

var dateTimePicker = $(editItem.get_editFormItem()).find("input[id*='StartDate']").get(0)

var date = new Date;

dateTimePicker.set_selectedDate(date);

}

return false;

<telerik:GridTemplateColumn HeaderText="Start Date" UniqueName="StartDate" DataField="StartDate" SortExpression="StartDate" FilterControlWidth="90px">

<ItemTemplate>

<asp:Label runat="server" ID="lblStartDate" Text='<%# Eval("StartDate", "{0:g}") %>'>

</asp:Label>

</ItemTemplate>

<InsertItemTemplate>

<telerik:RadDateTimePicker ID="StartDate" MinDate="2013/1/1" runat="server" DbSelectedDate='<%# Bind("StartDate") %>'>

</telerik:RadDateTimePicker>

<asp:Button runat="server" id="btnGetDate" Text="Get Date" OnClientClick="return AccessOnclient()" />

<asp:RequiredFieldValidator ID="StartDateRequiredInsert" ControlToValidate="StartDate" runat="server" ErrorMessage="Required"></asp:RequiredFieldValidator>

</InsertItemTemplate>

<EditItemTemplate>

<telerik:RadDateTimePicker ID="StartDate" MinDate="2013/1/1" runat="server" DbSelectedDate='<%# Bind("StartDate") %>'>

</telerik:RadDateTimePicker>

<asp:Button runat="server" id="btnGetDate" Text="Get Date" OnClientClick="return AccessOnclient()" />

<asp:RequiredFieldValidator ID="StartDateRequiredEdit" ControlToValidate="StartDate" runat="server" ErrorMessage="Required"></asp:RequiredFieldValidator>

</EditItemTemplate>

</telerik:GridTemplateColumn>

Thanks in advance for any help.

Brett

Grid

answered on 04 Apr 2013

1 answer

48 views

[Solved] Telerik RadGrid Sorting issue

Hello,

I am using Telerik RedGrid with it’s default skin in are application[.NET 4.0] to display the record and on the sorting, Searching , paging features as well but override the default colors of the grid item through coding in “itemdatabound “ event but when apply the sorting on the specific column of the grid then it alter the colors of this column to default skin in rest cases it is working fine.

Please see the attached screen shot it will clear little bit more about the problem what I am facing.

Please Response if any body facing this type problem and have solution.

Thanks In Advance!

Grid

answered on 04 Apr 2013

1 answer

364 views

[Solved] Set RadTimePicker time interval from C#

Hi,

I have a RadTimePicker in which I want to set its interval property from the code behind. I had tried setting but everytime
it is displaying a type conversion error. So can anyone help me how to set the same from code behind?

Thanks,
Shahi

Calendar

answered on 04 Apr 2013

1 answer

83 views

[Solved] Get GridDropDownColumn Text on insert

Hi,

I am using the RadGrid control which has a GridDropDownColumn. In the insert form, I want to fetch the GridDropDown selected text and assign it to a session variable. How can I get the selected text from the GridDropDown on insert?

Thank You
Sameer

General Discussions

answered on 04 Apr 2013

9 answers

244 views

[Solved] Dynamic Grid Creation - Sorting Causes Problems

All

Here is my scenario...
I have a combo box control with some values in it. Based on the selected value, I run a stored procedure to return a table of data. Each of the items in the combo box will call a different stored procedure, which will return a totally different result set. I need to do everything dynamically without hard coding any column names.

I can get this all to work. My issue comes when I do the sorting on the grid. With each sort, it initiates a postback thus resetting to the default value of the grid and not sorting the correct grid/datatable that was most recently populated. I have seen some topics similar around the forum, but nothing that I found helpful.

Hope you guys can help!
- JB

Grid

answered on 03 Apr 2013

4 answers

93 views

[Solved] Show all items when selected item's text is deleted

Hello Telerik,

In new version Q1 2013 I have issue how to show all items (records) when user typed to combobox some characters, choose filtered item and then delete selected item's text. In previous versions Q2 2013, this worked without problems.

You can find the same behaviour in demo example:
http://demos.telerik.com/aspnet-ajax/combobox/examples/overview/defaultcs.aspx

Steps to reproduce my problem.
1. Type to first combobox text anis
2. Records are filtered and just one record has left with text Aniseed Syrup
3. Clik on selected item or press Enter key. Now, combobox has selected item
4. Click on same combobox stelected item and press Delete key

After set 4, normally all records had been shown, but in Q1 2013 nothing is shown. Is is bug or do I make some mistake ?

This problem is appeared only in IE browsers (v.8,v.9).

Please help me to solve this issue.

Best regrads

Vasssek

ComboBox

answered on 03 Apr 2013