Questions on UI for ASP.NET AJAX Forum

1 answer

154 views

Export RadGrid (that contains RadChart) to Excel

I have a radgrid that I would like to export to excel.
The grid is pretty simple except that it has got a simple bar chart in it. (See the attached image file)
Is there a way to export the grid to excel with the barchart intact?
I've read couple of posts such as http://www.telerik.com/community/forums/aspnet-ajax/grid/exporting-chart-along-with-grid.aspx
but it doesn't really explain in detail on how I can achieve the suggested method.

Grid

answered on 24 Feb 2011

2 answers

115 views

Error while adding new row to grid

Dear All,
I am loading a blank row on page load. I am unable to add a new row in grid on Add Row context Radmenu item click. For your reference please go through the code below
following is the aspx code and server code. Any help will be greatly appreciated.

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="WebForm4.aspx.vb" Inherits="BNBERP.WebForm4" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<title></title>

</head>

<body>

<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

<script type="text/javascript">

function RowContextMenu(sender, eventArgs) {

var menu = $find("<%=RadMenu1.ClientID %>");

var evt = eventArgs.get_domEvent();

if (evt.target.tagName == "INPUT" || evt.target.tagName == "A") {

return;

}

var index = eventArgs.get_itemIndexHierarchical();

document.getElementById("radGridClickedRowIndex").value = index;

sender.get_masterTableView().selectItem(sender.get_masterTableView().get_dataItems()[index].get_element(), true);

menu.show(evt);

evt.cancelBubble = true;

evt.returnValue = false;

if (evt.stopPropagation) {

evt.stopPropagation();

evt.preventDefault();

}

</script>

</telerik:RadCodeBlock>

<form id="form1" runat="server">

<div>

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">

</telerik:RadScriptManager>

<telerik:RadButton ID="RadButton1" runat="server" Text="Get Data">

</telerik:RadButton>

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False"

Skin="Forest" EnableHeaderContextMenu="True">

<MasterTableView >

<CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>

<Columns>

<telerik:GridTemplateColumn HeaderText="Item No">

<ItemTemplate>

<telerik:RadComboBox ID="RadComboBox1" runat="server"

DataSourceID="SqlDataSource1" DataTextField="ItemCode"

DataValueField="ItemCode">

</telerik:RadComboBox>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:SBODemoINConnectionString %>"

SelectCommand="SELECT [ItemCode], [ItemName] FROM [OITM]">

</asp:SqlDataSource>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Item Description">

<ItemTemplate>

<telerik:RadComboBox ID="RadComboBox2" runat="server" DataSourceID="SqlDataSource2"

DataTextField="ItemName" DataValueField="ItemCode">

</telerik:RadComboBox>

<asp:SqlDataSource ID="SqlDataSource2" runat="server"

ConnectionString="<%$ ConnectionStrings:SBODemoINConnectionString %>"

SelectCommand="SELECT [ItemCode], [ItemName] FROM [OITM]">

</asp:SqlDataSource>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="On Hand">

<ItemTemplate>

<telerik:RadTextBox ID="RadTextBox3" Runat="server">

</telerik:RadTextBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Prefered Vendor">

<ItemTemplate>

<telerik:RadTextBox ID="RadTextBox4" Runat="server">

</telerik:RadTextBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

<ClientSettings>

<ClientEvents OnRowContextMenu="RowContextMenu" />

</ClientSettings>

<HeaderContextMenu EnableImageSprites="True" CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>

</telerik:RadGrid>

<input type="hidden" id="radGridClickedRowIndex" name="radGridClickedRowIndex" />

<telerik:RadContextMenu ID="RadMenu1" runat="server"

EnableRoundedCorners="true" EnableShadows="true">

<Items>

<telerik:RadMenuItem Text="Add Row" />

<telerik:RadMenuItem Text="Delete Row" />

<telerik:RadMenuItem Text="Duplicate Row"/>

</Items>

</telerik:RadContextMenu>

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" Height="200px" Width="300px">

</telerik:RadAjaxPanel>

</div>

</form>

</body>

</html>

Imports Telerik.Web.UI

Imports System

Imports System.Data

Imports System.Data.SqlClient

Public Class WebForm4

Inherits System.Web.UI.Page

Dim sqlCon As SqlConnection

Dim sqlDa As SqlDataAdapter

Dim sqlDs As DataSet

Dim sqlDt, sqlDt1 As DataTable

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

Try

If Not Page.IsPostBack Then

'Dim box1 As RadComboBox = DirectCast(RadGrid1.Items(0).FindControl("RadComboBox1"), RadComboBox)

'Dim col As GridTemplateColumn

'col = RadGrid1.Columns(0)

sqlCon = New SqlConnection("Data Source=BNBSOFT-EF98F06\SQLEXPRESS;Initial Catalog=SBODemoIN;Integrated Security=True")

sqlDa = New SqlDataAdapter("SELECT [ItemCode],[ItemName],[OnHand],[CardCode] FROM [SBODemoIN].[dbo].[OITM]", sqlCon)

sqlDs = New DataSet()

sqlDt = New DataTable()

sqlDa.FillSchema(sqlDt, SchemaType.Source)

For Each column As DataColumn In sqlDt.Columns()

column.AllowDBNull = "True"

Next

SetInitialRow(sqlDt)

End If

Catch ex As Exception

End Try

End Sub

Private Sub FillItemsCombo()

sqlCon = New SqlConnection("Data Source=BNBSOFT-EF98F06\SQLEXPRESS;Initial Catalog=SBODemoIN;Integrated Security=True")

sqlDa = New SqlDataAdapter("SELECT [ItemCode],[ItemName],[OnHand],[CardCode] FROM [SBODemoIN].[dbo].[OITM]", sqlCon)

End Sub

Private Sub SetInitialRow(ByRef dt1 As DataTable)

Dim dt As New DataTable()

dt = dt1

Dim dr As DataRow = Nothing

dr = dt.NewRow()

dr.Item(2) = "4.0"

dt.Rows.Add(dr)

'Store the DataTable in ViewState

ViewState("CurrentTable") = dt

RadGrid1.DataSource = dt

RadGrid1.DataBind()

SetPreviousData()

'DirectCast(item("YourColumnUniqueName").FindControl("IDofYourRadTextBox"), RadTextBox).Text()

End Sub

Private Sub SetPreviousData()

Dim rowIndex As Integer = 0

If ViewState("CurrentTable") IsNot Nothing Then

Dim dt As DataTable = DirectCast(ViewState("CurrentTable"), DataTable)

If dt.Rows.Count > 0 Then

For i As Integer = 0 To dt.Rows.Count - 1

Dim box1 As RadComboBox = DirectCast(RadGrid1.Items(rowIndex).Cells(0).FindControl("RadComboBox1"), RadComboBox)

Dim box2 As RadComboBox = DirectCast(RadGrid1.Items(rowIndex).Cells(1).FindControl("RadComboBox2"), RadComboBox)

Dim box3 As RadTextBox = DirectCast(RadGrid1.Items(rowIndex).Cells(2).FindControl("RadTextBox3"), RadTextBox)

Dim box4 As RadTextBox = DirectCast(RadGrid1.Items(rowIndex).Cells(3).FindControl("RadTextBox4"), RadTextBox)

'If box1.Items.Count <= 0 Then

'    sqlCon = New SqlConnection("Data Source=BNBSOFT-EF98F06\SQLEXPRESS;Initial Catalog=SBODemoIN;Integrated Security=True")

'    sqlDa = New SqlDataAdapter("SELECT [ItemCode],[ItemName],[OnHand],[CardCode] FROM [SBODemoIN].[dbo].[OITM]", sqlCon)

' sqlDs = New DataSet

' sqlDa.Fill(sqlDs)

' Dim rs, rs1 As RadComboBoxItem

' For j As Integer = 0 To sqlDs.Tables(0).Rows.Count

' rs = New RadComboBoxItem(sqlDs.Tables(0).Rows(j)(0).ToString(), sqlDs.Tables(0).Rows(j)(0).ToString())

' rs1 = New RadComboBoxItem(sqlDs.Tables(0).Rows(j)(0).ToString(), sqlDs.Tables(0).Rows(j)(0).ToString())

' box1.Items.Add(rs)

' box2.Items.Add(rs1)

' Next

'End If

'box1.SelectedValue = dt.Rows(i)("ItemCode").ToString()

box1.SelectedIndex = 0

box2.SelectedIndex = 0

' box2.Text = dt.Rows(i)("ItemName").ToString()

box3.Text = dt.Rows(i)("OnHand").ToString()

box4.Text = dt.Rows(i)("CardCode").ToString()

rowIndex += 1

Next

End If

End Sub

Private Sub AddNewRowToGrid()

Dim rowIndex As Integer = 0

If ViewState("CurrentTable") IsNot Nothing Then

Dim dtCurrentTable As DataTable = DirectCast(ViewState("CurrentTable"), DataTable)

Dim drCurrentRow As DataRow = Nothing

If dtCurrentTable.Rows.Count > 0 Then

For i As Integer = 1 To dtCurrentTable.Rows.Count

'extract the TextBox values

Dim box1 As RadComboBox = DirectCast(RadGrid1.Items(rowIndex).Cells(0).FindControl("RadComboBox1"), RadComboBox)

Dim box2 As RadComboBox = DirectCast(RadGrid1.Items(rowIndex).Cells(1).FindControl("RadComboBox2"), RadComboBox)

Dim box3 As RadTextBox = DirectCast(RadGrid1.Items(rowIndex).Cells(2).FindControl("RadTextBox3"), RadTextBox)

Dim box4 As RadTextBox = DirectCast(RadGrid1.Items(rowIndex).Cells(3).FindControl("RadTextBox4"), RadTextBox)

drCurrentRow = dtCurrentTable.NewRow()

dtCurrentTable.Rows(i - 1)("ItemCode") = box1.SelectedItem

dtCurrentTable.Rows(i - 1)("ItemName") = box2.SelectedItem

dtCurrentTable.Rows(i - 1)("OnHand") = box3.Text

dtCurrentTable.Rows(i - 1)("CardCode") = box4.Text

rowIndex += 1

Next

dtCurrentTable.Rows.Add(drCurrentRow)

ViewState("CurrentTable") = dtCurrentTable

RadGrid1.DataSource = dtCurrentTable

RadGrid1.DataBind()

End If

Else

Response.Write("ViewState is null")

End If

'Set Previous Data on Postbacks

SetPreviousData()

End Sub

Private Sub RadMenu1_ItemClick(ByVal sender As Object, ByVal e As Telerik.Web.UI.RadMenuEventArgs) Handles RadMenu1.ItemClick

Dim radGridClickedRowIndex As Integer

Try

radGridClickedRowIndex = Convert.ToInt32(Request.Form("radGridClickedRowIndex"))

Select Case e.Item.Text

Case "Duplicate Row"

'AddDuplicateRowToGrid(radGridClickedRowIndex)

Exit Select

Case "Add Row"

AddNewRowToGrid()

Exit Select

Case "Delete Row"

'DeleteRowFromGrid(radGridClickedRowIndex)

'RadGrid1.Items(radGridClickedRowIndex).

'RadGrid1.MasterTableView.PerformDelete(RadGrid1.Items(radGridClickedRowIndex))

Exit Select

End Select

Catch ex As Exception

End Try

End Sub

Protected Sub RadButton1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles RadButton1.Click

Try

AddNewRowToGrid()

Catch ex As Exception

End Try

End Sub

End Class

Grid

answered on 24 Feb 2011

1 answer

110 views

Grid Settings Persister not picking up the resized column widths

Hi
I am using Telerik radgrid with user defined columns to have custom filter controls.
I have specified the headerstyle-width to a default column width and allowed some columns to be resizable. When the user resizes the grid and hits on sort or does any postback the column widths are not being retained.
I then went for the GridSettingsPersister class and called the persist method to save to session as shown in the demo after the column is resized. When i firebug the window the colgroup has the col width that the user resized but unfortunately this is not being picked up in the
GridSettingsPersister.GetColumnSettings. The value that is being picked up is the default headerstyle-width that I had given.
Is this because I am using user defined columns?

Any help would be appreciated as i seem to be stuck at dead ends whatever i try.

Grid

answered on 24 Feb 2011

1 answer

61 views

Column headertext displayed in single line when unhidden clientside

Hi,
I used the solution in this thread to hide/display columns clientside. It works fine but the headertext gets unwrapped and gets displayed in a single line when the column is displayed after being hidden.

Is there anyway to avoid this?

Thank you!

Grid

answered on 24 Feb 2011

1 answer

52 views

Chart in custom web part under SP2010

I'm unable to get a chart to render in a web part under SharePoint 2010. I've read all of the other posts about this and inserted the handler strings into web.config. We are not using URL rewriting. Does Telerik have an actual working example of this scenario (chart in custom web part) that I can download to use as a test?

We have Radcontrols for ASP.Net Ajax Q2 2010, SharePoint 2010 Enterprise and Windows Server 2008 R2

Chart (Obsolete)

answered on 24 Feb 2011

2 answers

104 views

Calculated Column

Hi,

I am trying to create a calculated column, which I have succeeded in doing, but filtering and grouping is triggering a javascript exception.

This is my code:

<telerik:RadGrid ID="timesheetGrid" runat="server" GridLines="None" Skin="Windows7"AllowSorting="True" ShowGroupPanel="True" AutoGenerateColumns="False" AllowPaging="True"

PageSize="15" ShowStatusBar="True" AllowFilteringByColumn="True" AllowMultiRowSelection="True"

OnNeedDataSource="timesheetGrid_NeedDataSource" OnPreRender="timesheetGrid_PreRender"

ViewStateMode="Enabled" onitemdatabound="timesheetGrid_ItemDataBound" Width="970px">

<ClientSettings EnableRowHoverStyle="true" AllowColumnsReorder="True" ReorderColumnsOnClient="True"

AllowDragToGroup="True">

<Selecting AllowRowSelect="True" />

<ClientEvents OnRowDblClick="RowDblClick" />

</ClientSettings>

<MasterTableView DataKeyNames="ID" EditMode="EditForms">

<RowIndicatorColumn>

<HeaderStyle Width="20px"></HeaderStyle>

</RowIndicatorColumn>

<ExpandCollapseColumn>

<HeaderStyle Width="20px"></HeaderStyle>

</ExpandCollapseColumn>

<CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>

<Columns>

<telerik:GridClientSelectColumn UniqueName="ClientSelectColumn" />

<telerik:GridBoundColumn DataField="ID" HeaderText="ID" UniqueName="ID" Visible="False"

ReadOnly="true">

</telerik:GridBoundColumn>

<telerik:GridDateTimeColumn DataField="From" DataType="System.DateTime"

HeaderText="Date" UniqueName="DateFrom" ReadOnly="true" DataFormatString="{0:dd/MM/yyyy}" FilterControlWidth="100px" HeaderStyle-Width="100px">

</telerik:GridDateTimeColumn>

<telerik:GridBoundColumn DataField="User.UserName" HeaderText="User" UniqueName="User"

ReadOnly="true">

</telerik:GridBoundColumn>

<telerik:GridNumericColumn UniqueName="Duration" HeaderText="Duration" DataType="System.Double" HeaderStyle-Width="30px" FilterControlWidth="30px">

<ItemStyle HorizontalAlign="Right"/>

</telerik:GridNumericColumn>

<telerik:GridBoundColumn DataField="Description" HeaderText="Description" UniqueName="Description">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="DocketNo" HeaderText="Docket No" UniqueName="DocketNo"

ReadOnly="true">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FileCode" HeaderText="File Code" UniqueName="FileCode" HeaderStyle-Width="50px" FilterControlWidth="50px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FileCodeID" HeaderText="File Code ID" UniqueName="FileCodeID"

Visible="false">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CostCenter" HeaderText="Cost Center" UniqueName="CostCenter" HeaderStyle-Width="50px" FilterControlWidth="50px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CostCenterID" HeaderText="Cost Center ID" UniqueName="CostCenterID"

Visible="false">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CompanyID" HeaderText="Company ID" UniqueName="CompanyID"

Visible="false">

</telerik:GridBoundColumn>

<telerik:GridCheckBoxColumn DataField="IsNegativeTimesheet" DataType="System.Boolean"

HeaderText="Negative Timesheet" UniqueName="NegativeTimesheet" ReadOnly="true">

</telerik:GridCheckBoxColumn>

<telerik:GridCheckBoxColumn DataField="IsOvertime" DataType="System.Boolean" HeaderText="Overtime"

UniqueName="Overtime" ReadOnly="true">

</telerik:GridCheckBoxColumn>

</Columns>

<EditFormSettings UserControlName="UserControls/TimesheetEdit.ascx" EditFormType="WebUserControl">

<EditColumn FilterControlAltText="Filter EditCommandColumn column">

</EditColumn>

</EditFormSettings>

</MasterTableView>

<PagerStyle Mode="NumericPages" VerticalAlign="Bottom" />

<FilterMenu EnableImageSprites="False">

</FilterMenu>

<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Windows7">

</HeaderContextMenu>

</telerik:RadGrid>

Column Calculation:

protected void timesheetGrid_ItemDataBound(object sender, GridItemEventArgs e)

{

if (e.Item is GridDataItem)

{

GridDataItem row = e.Item as GridDataItem;

TimeSheet item = e.Item.DataItem as TimeSheet;

if (item != null)

{

double duration = item.To.TimeOfDay.TotalHours - item.From.TimeOfDay.TotalHours;

row["Duration"].Text = duration.ToString();

}

else

{

row["Duration"].Text = "0";

}

Exception:

Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: Expression cannot be null or empty.

Attached image.

Any help would be greatly appreciated.

Many thanks,
Daryl

Grid

answered on 24 Feb 2011

1 answer

100 views

show real-time logging of server-side events

I'm trying to create an application that will display real-time logging of server-side events and show the status of these events within an ajaxpanel. I'm performing tasks such as extracting a zip file, copy files/folders to other locations, and deleting files and folders... all on the server where the application will be hosted.

I would like the status of each of these processes to be displayed to the user... for example:

- zip file is now being extracted... complete
- now searching for audio folder... complete
- now copying audio folder contents to driver folder... complete

... and so on

Can anyone suggest how this can be implemented?

Thanks!

Ajax

answered on 24 Feb 2011

1 answer

198 views

Grid Edit and Delete column shifting to right with AutoGenerated columns

Hi,

I have a Grid with the AutoGenerated Columns set to true and The Edit,Delete Column defined in the MasterTableView in design time. Currently the Edit and Delete columns appear to be on the left hand side and the AutoGenerated columns next to Edit and delete columns. Now we need to shift the Edit and delete columns to the right without affecting the sequence of the columns generated. We have tried swapping the columns technique but it seems to effect the sequence of autogenerated columns.

Please can you let us know the direct way to achieve this a bit urgently.

Below is the part of code for your reference which creates the Edit Delete column to the left:

<telerik

:RadGrid AutoGenerateColumns="true" ID="grid" runat="server" AllowSorting="True"

AllowPaging="true" ShowFooter="false">

</FilterMenu>

</RowIndicatorColumn>

</EditColumn>

</EditFormSettings>

</ExpandCollapseColumn>

</CommandItemTemplate>

<telerik:GridTemplateColumn HeaderText="" UniqueName="Edit"

AllowFiltering="false">

<%

--<img onclick="javascript:handler('','ctl00_MainContentHolder_RadPanelBar3_i0_i0_grid','<%# Container.ItemIndex %>')" style="border: 0" src="images/Edit.png" alt="Edit" />--%>

<eui:eLabel ID="lblEdit" runat="server" Text="Edit" CssClass="label" ForeColor="Blue"></eui:eLabel>

</a>

</itemtemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="" UniqueName="Delete"

AllowFiltering="false">

<asp:TextBox id="txt1" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "id")%>' style="display:none" ></asp:TextBox>

<a href="#" id='<%# DataBinder.Eval(Container.DataItem, "id")%>' title="Delete" onclick='Textt(this)'>

<%

--<img onclick="javascript:handler('','ctl00_MainContentHolder_RadPanelBar3_i0_i0_grid','<%# Container.ItemIndex %>')" style="border: 0" src="images/Delete.png" alt="Delete" />--%>

<eui:eLabel ID="lblDelete" runat="server" Text="Delete" CssClass="label" ForeColor="Blue"></eui:eLabel>

</a>

</itemtemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

<Resizing AllowRowResize="false" EnableRealTimeResize="false" ResizeGridOnColumnResize="false"

AllowColumnResize="false"></Resizing>

</ClientSettings>

</telerik:RadGrid>

Thanks in Advance.

Grid

answered on 24 Feb 2011

1 answer

200 views

how to get the rowindex in text_changed event

hi

i have used this line to get the row index in the textchanged event but i didnt get any value and this is the line

int i = ((GridDataItem)(((RadNumericTextBox)sender).NamingContainer)).ItemIndex;

how to get the row index in text changed event

General Discussions

answered on 24 Feb 2011

8 answers

217 views

Possible bug with bullets and numbering tools?

I've found what appears to be a bug with the bullets and number options in the Editor control.

When in the editor enter some text and click the Numbering button to give you something like this:

text

Press ENTER twice to get back to a normal paragraph and then enter another line of text with a bullet. This will either work (randomly) or will indent the text directly below the numbered list above as a bullet giving a <UL> inside of the <OL> tag above it. If you then click the bullet button to remove the bullet it will be removed but then cannot be put back again using the button. Once you're in this position it seems impossible to reformat everything again and the entire section must be removed including the <OL> above or you never get the items where intended.

Ironically whilst trying to give examples in this post I have come across the same problem! I don't know if this page is using the same control or not but it's most frustrating.

Is this something you've come across?

Thanks

Dave

Editor

answered on 24 Feb 2011