Questions on UI for ASP.NET AJAX Forum

4 answers

205 views

I have a rad pivot grid and I am trying to export the grid to pdf and csv. I am able to export it to excel. Is there a work around to get it exported to other formats. Would appreciate any suggestions you might have.

I tried this for .csv but I am unable to get any data.

protected void btnExportCSV_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=GridViewExport.csv");
Response.Charset = "";
Response.ContentType = "application/text";

RadPivotGrid1.AllowPaging = false;
RadPivotGrid1.DataBind();

StringBuilder sb = new StringBuilder();
for (int i = 0; i < RadPivotGrid1.Fields.Count; i++)
{
//add separator
sb.Append(RadPivotGrid1.Fields[i].ToString() + ',');
}
//append new line
sb.Append("\r\n");
lblTest.Text = sb.ToString();
Response.Output.Write(sb.ToString());
Response.Flush();
Response.End();
}

I think I am not doing this right? What is the best way to loop through the cells in a pivot grid and get data.
for (int i = 0; i < RadPivotGrid1.Fields.Count; i++)
{
//add separator
sb.Append(RadPivotGrid1.Fields[i].ToString() + ',');
}

Thanks

PivotGrid

answered on 09 Jul 2015

1 answer

543 views

Dynamic column exported in Excel as System.Data.DataRowView

Hi there,

I do need to create 3 new columns dynamically according to the data existence in the database. This approach has been done successfully and it works very well.

The issue occurs once the user clicks on the export button and the header does disappear and the data appears as "System.Data.DataRowView" in the excel sheet.

The following event is to load the grid. I do need to create programmatically, because I have to rename the column header according to the data that I receive.

//Add in name column

GridBoundColumn col = new GridBoundColumn();

col.HeaderText = addition1;

col.DataField = "Additional1";

col.UniqueName = "Additional1";

// col.Display = false;

RadGrid1.MasterTableView.Columns.Add(col);

col = new GridBoundColumn();

col.HeaderText = addition2;

col.DataField = "Additional2";

col.UniqueName = "Additional2";

// col.Display = false;

RadGrid1.MasterTableView.Columns.Add(col);

col = new GridBoundColumn();

col.HeaderText = addition3;

col.DataField = "Additional3";

col.UniqueName = "Additional3";

//col.Display = false;

RadGrid1.MasterTableView.Columns.Add(col);

So, after the above code, I do create a Data Table and bind the data in it and bind the Data Table in RadGrid.DataSource.

The look of the grid is okay. That means the column and the data are appearing perfectly.

However, once it comes on the excel file, the column text disappears and the content for these columns are appearing as "System.Data.DataRowView"

What could be the reason? - Thank you

Grid

answered on 09 Jul 2015

1 answer

117 views

QR Code functionality in UI for Asp.net AJAX 2012.2.815

Good morning

I'd like to know if there is a full functionality for QR Code in UI for Asp.net AJAX 2012.2.815. I have a purchased license and I need to know if I can embed the whole QR Code functionality without purchasing a new product (for example the latest version of 2015). If there is that possibility what is the estimated cost for this?

Thnx

Billy P.

Athens

Barcode

answered on 08 Jul 2015

2 answers

196 views

Clear added items of active upload control

I have been following this thread (http://www.telerik.com/forums/radasyncupload-clear-items-using-serverside-code) for a similar issue.

Issue: "I am using RadAsyncUpload to upload files. I have a 'Cancel' button which the user can click anytime after selecting the files. I want to clear the selected files - or in other words reset the RadAsyncUpload Control when 'Cancel' button is clicked." (by Liby George)

Solution: Please include the following line of code in your click handler for the "Cancel" button.
//JavaScript
$telerik.$(".ruInputs li .ruRemove").click()
This will go through the files <li> elements and click on the "Remove" link. (by Boyan Dimitrov)

My problem: Since there are severals RadAsyncUpload along with coresponding buttons in one page, this will clear all selected files of all upload controls for a single click . How can I clear the items of one RadAsyncUpload without affecting the others?

AsyncUpload

answered on 08 Jul 2015

5 answers

103 views

Display EditColumn in top instead of Add New button

Hi,

I have a Rad Grid used in my application. When i click "Add New" button, the edit column is displayed in the top and i can add new record. Is there a way i can hide the "Add New" button and display the Edit Column by default in the top always so that user can enter the value and click Insert. My Grid code as below,

<telerik:RadGrid ID="rgTest" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" Width="97%" OnNeedDataSource="rgTest_NeedDataSource"
OnUpdateCommand="rgTest_UpdateCommand" OnDeleteCommand="rgTest_DeleteCommand"
OnInsertCommand="rgTest_InsertCommand" AllowAutomaticDeletes="true" Visible="true">
<PagerStyle Mode="NextPrevAndNumeric" />
<MasterTableView Width="100%" CommandItemDisplay="Top" EditMode="InPlace" DataKeyNames="ID"
AllowAutomaticDeletes="true">
<CommandItemSettings AddNewRecordText="Add New" ShowRefreshButton="false" />
<Columns>
<telerik:GridEditCommandColumn UniqueName="TestEdit">
</telerik:GridEditCommandColumn>
<telerik:GridTemplateColumn HeaderText="ID" Display="false" UniqueName="TestID">
<ItemTemplate>
<asp:Label runat="server" ID="lblID" Text='<%# Eval("ID") %>' />
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Names" UniqueName="TestName">
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem,"Name")%>
</ItemTemplate>
<EditItemTemplate>
<telerik:RadComboBox runat="server" ID="rcbTestName" DataTextField="Name" DataValueField="ID">
</telerik:RadComboBox>
</EditItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridButtonColumn CommandName="Delete" ButtonType="ImageButton" ImageUrl="~/Images/delete16x16.png"
Text="Delete" ConfirmText="Are you sure you want to delete the selected row?">
</telerik:GridButtonColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>

Grid

answered on 08 Jul 2015

3 answers

92 views

[Solved] Hide a cell if i have a specific value in an other cell

Hello,

On my RadGrid, I have an column.

On this column i have an image, but this image is hidden if i haven't a specific value in an other column.

How can i hide this ?

Exemple :

| ---------- | --------------------------|

| Image | Specific Value |

| -----------| --------------------------|

| Nothing | Not specific Value |

| -----------|---------------------------|

Thanks for your support,

Alexandre

Grid

answered on 08 Jul 2015

3 answers

567 views

[Solved] RadGrid AutoGenerateColumns false

Hi! I'm trying to make a radgrid with explicit defined columns. I've tried setting the AutoGenerateColumns property of the radgrid to false, but it won't show anything. This is my code

<telerik:RadGrid ID="rdContainers" runat="server" AutoGenerateColumns="false" OnNeedDataSource="fnGetScanContainers" AllowFilteringByColumn="True" Width="91%">

<telerik:MasterTableView TableLayout="Fixed">

<HeaderStyle Width="102px" />

<Columns>

<telerik:GridBoundColumn DataField="ContainerID" HeaderText="Container ID" SortExpression="ContainerID" UniqueName="gcContainerID" FilterControlWidth="60px">

<HeaderStyle Width="170px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Location" HeaderText="Location" UniqueName="gcLocation" FilterControlWidth="60px">

<HeaderStyle Width="115px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PartNumber" HeaderText="Part Number" UniqueName="gcPartNumber" FilterControlWidth="60px">

<HeaderStyle Width="115px" />

</telerik:GridBoundColumn>

</telerik:MasterTableView>

<ClientSettings EnableRowHoverStyle="true">

<Selecting AllowRowSelect="true" EnableDragToSelectRows="false" />

<Scrolling AllowScroll="true" UseStaticHeaders="true" ScrollHeight="" />

</ClientSettings>

</telerik:RadGrid>

Grid

answered on 08 Jul 2015

1 answer

80 views

highlight mis spelt words

How can i highlight mistyped words using rad spell control..i don't want any suggestion dialogue...becoz the text is read only....please suggest me, how to do that with rad spell or is there any other way to do the same.

Spell

answered on 08 Jul 2015

2 answers

102 views

Why i need to expand twice when Collapsed="false

Hi,

I am using RadDockLayout with userControl. I want all my dock to be close when my page load.
I use Collapsed="false" but here my problem if i do that
The problem is is that i need to expand each section twice or there nothing showing from the usercontrol.
If i click once the RadDock it will open just a little bit and then i need close it and expand again.
Then everything is fine.
Any idea why?

Tks

<%@ Register Src="~/information/profil/control/resultats.ascx" TagName="Profil" TagPrefix="uc2" %>

<%@ Register Src="~/information/profil/control/action_one_eleve.ascx" TagName="action_one_eleve" TagPrefix="uc2" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">

<div class="boxLessSpaceV">

<i class="fa fa-user fa-2x"></i> <asp:Label ID="lblName" CssClass="TitlePage" runat="server" Text="Profil - Luc Emond"></asp:Label>

<hr />

<uc2:menuProfil ID="menuProfil" runat="server" />

<hr />

</div>

<telerik:RadDockLayout runat="server" ID="RadDockLayout1" EnableEmbeddedSkins="true" Skin="Metro">

<div>

<table style="padding: 0px;border-collapse: collapse; border-spacing: 0;">

<tr>

<td style="width: 222px;">

<telerik:RadDockZone runat="server" ID="RadDockZone1" Skin="Metro" Orientation="vertical" Style="border: 0;width: 700px;height:500px;">

<telerik:RadDock runat="server" ID="UserInfo" Collapsed="false" EnableDrag="false" Title="Résultats" Width="700px" Height="500px" EnableAnimation="true">

<ContentTemplate>

<uc2:Profil ID="ProfilControl" runat="server"></uc2:Profil>

</ContentTemplate>

</telerik:RadDock>

<telerik:RadDock runat="server" ID="RadDock1" EnableDrag="false" Collapsed="false" Title="Actions " Width="700px" Height="500px" EnableAnimation="true">

<ContentTemplate>

<uc2:Profil ID="Profil1" runat="server"></uc2:Profil>

</ContentTemplate>

</telerik:RadDock>

</telerik:RadDockZone>

</td>

</tr>

</table>

</div>

</telerik:RadDockLayout>

</asp:Content>

Dock

answered on 08 Jul 2015

3 answers

891 views

RadGrid ClientEvents OnRowClick

Hello,

I have a requirement to allow client side selection of a row using RadGrid.

I have a parent form that opens a child form using javascript window.open. I want the child form to pass back a value in a selected row in the grid.

I have set the following:

The problem is the OnRowClick event is fired on load of the grid, but not on RowClick. I've tried OnRowDblClick, OnRowSelected all with the same result.

Please help.

Thank you,

Tim Inouye

Documentation and Tutorials

answered on 08 Jul 2015