Questions on UI for ASP.NET AJAX Forum

3 answers

422 views

My checkbox in normal grid view looks like it is grayed but it is not it is enabled.

How do I get checkbox A to look like checkbox B??

checkbox image

thanks for any help!

Grid

answered on 02 Jan 2014

2 answers

240 views

Setting RadGrid (GridBoundColumn) to contain a list in a column

Hi guys,

I'm currently using radgrid to show users these columns: tableName, dataSources, and dataTypes. And in the SQL database one unique dataName is attached to several dataSources/dataTypes. Currently what I can show in the table is 1 tableName and show the first dataSource attach to it in the SQL, and currently I need to show all the sources and types in a column (i.e. tableName: A, dataSource: B,C,D, dataType: E,F,G). Furthermore can I still use the sorting and filtering function for these columns?

Currently I'm using the code below (stored procedure in SQL) to obtain the dataSources by tableName. This will return dataSource1, dataSource2, and so on that is attached to the tableName. However I'm at lost on how to attach these dataSources in the column in radGrid. I searched around and I'm still not sure how to do it.

USE [table]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author: <Author,,Name>

-- Create date: <Create Date,,>

-- Description: <Description,,>

-- =============================================

ALTER PROCEDURE [dbo].[getDataSources_byTableName]

-- Add the parameters for the stored procedure here

@tableName varchar(20)

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

select TableAttributeName,MetadataTableAttributes.TableAttributeId,

MetadataTableAttributeValues.TableAttributeValueId,

MetadataTableAttributeValues.TableAttributeValue

into #tmp2

from MetadataTableAttributeValues

inner join MetadataTableAttributes

on MetadataTableAttributes.TableAttributeId = MetadataTableAttributeValues.TableAttributeId

select distinct MetadataTables.TableName,

#tmp2.*

into #rpt2

from MetadataTables inner join MetadataTableAttributeValues

on MetadataTables.TableId = MetadataTableAttributeValues.TableId

inner join #tmp2 on MetadataTableAttributeValues.TableAttributeValueId = #tmp2.TableAttributeValueId

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[caisis_tmp]') AND type in (N'U'))

DROP TABLE [dbo].[caisis_tmp]

CREATE TABLE [dbo].[caisis_tmp](

ptMRN [nvarchar](255),

dataSource1 [nvarchar](255),

dataSource2 [nvarchar](255),

dataSource3 [nvarchar](255),

dataSource4 [nvarchar](255),

)

ON [PRIMARY]

INSERT INTO [caisis_tmp] (ptMRN)

select distinct TableName from #rpt2

update [caisis_tmp] set [caisis_tmp].dataSource1=

(SELECT TOP 1 #rpt2.TableAttributeValue from #rpt2 where [caisis_tmp].ptMRN = #rpt2.TableName);

update [caisis_tmp] set [caisis_tmp].dataSource2=

(

SELECT TABLEAttributeValue from

(SELECT ROW_NUMBER() OVER (ORDER BY TableAttributeValueID) AS RowNum, * FROM #rpt2 where #rpt2.TableAttributeName='dataSource' and [caisis_tmp].ptMRN = #rpt2.tableName) sub

WHERE RowNum = 2

)

update [caisis_tmp] set [caisis_tmp].dataSource3=

(

SELECT TABLEAttributeValue from

(SELECT ROW_NUMBER() OVER (ORDER BY TableAttributeValueID) AS RowNum, * FROM #rpt2 where #rpt2.TableAttributeName='dataSource' and [caisis_tmp].ptMRN = #rpt2.tableName) sub

WHERE RowNum = 3

)

update [caisis_tmp] set [caisis_tmp].dataSource4=

(

SELECT TABLEAttributeValue from

(SELECT ROW_NUMBER() OVER (ORDER BY TableAttributeValueID) AS RowNum, * FROM #rpt2 where #rpt2.TableAttributeName='dataSource' and [caisis_tmp].ptMRN = #rpt2.tableName) sub

WHERE RowNum = 4

)

select * from [caisis_tmp]

where ptMRN = @tableName

drop table [caisis_tmp],#tmp2,#rpt2

END

Thank you so much :)

Grid

answered on 02 Jan 2014

1 answer

86 views

hide paging when grid in editmode

Hi.
How can we hide paging when grid in editmode?

Grid

answered on 02 Jan 2014

4 answers

67 views

RadAjaxLoadingPanel displays minimized if HorizontalAlign is set on MasterTableView in a RadGrid

I have a perplexing issue. My user control has a RadAjaxManager, RadGrid and RadAjaxLoadingPanel. The loading panel overlays the RadGrid as expected during updates to the grid. The grid is configured to display a hierarchy of a straight forward master detail pattern.

However, if I set the HorizontalAlign property to any value other than NotSet for the MasterTableView of the RadGrid, the loading panel displays as a very narrow control at the top of the RadGrid. Is this a known issue and is there a work around?

<telerik:RadFormDecorator ID="QsfFromDecorator" runat="server" DecoratedControls="Fieldset" EnableRoundedCorners="true" />

<telerik:radajaxmanager ID="RadAjaxManager1" runat="server" OnAjaxRequest="RadAjaxManager1_AjaxRequest"

DefaultLoadingPanelID="RadAjaxLoadingPanel1" EnableHistory="True" ClientEvents-OnRequestStart="RequestStart"

ClientEvents-OnResponseEnd="ResponseEnd" >

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="RadAjaxManager1" >

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="RadGrid1" >

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadGrid1"

LoadingPanelID="RadAjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

<ClientEvents OnResponseEnd="ResponseEnd" OnRequestStart="RequestStart" />

</telerik:radajaxmanager>

<telerik:radajaxloadingpanel ID="RadAjaxLoadingPanel1" runat="server"

Skin="Windows7" EnableAjaxSkinRendering="true" >

</telerik:radajaxloadingpanel>

<telerik:RadGrid ID="RadGrid1" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource"

OnDetailTableDataBind="RadGrid1_DetailTableDataBind" AllowFilteringByColumn="true"

AllowSorting="True" AutoGenerateHierarchy="True" CellSpacing="0" PageSize="25"

Skin="Windows7" ClientSettings-AllowExpandCollapse="true"

GridLines="None" oncolumncreated="RadGrid1_ColumnCreated"

onitemdatabound="RadGrid1_ItemDataBound" OnItemCommand="RadGrid1_ItemCommand"

onitemcreated="RadGrid1_ItemCreated" ondatabound="RadGrid1_DataBound" HorizontalAlign="Right" >

<MasterTableView HorizontalAlign="Right" AllowPaging="true" AllowFilteringByColumn="true" CommandItemDisplay="Top" Caption="Performance Data" >

<DetailTables>

<telerik:GridTableView AllowFilteringByColumn="false" HorizontalAlign="Right" >

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

<RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>

<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn>

<EditFormSettings>

<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>

</EditFormSettings>

</telerik:GridTableView>

</DetailTables>

<CommandItemSettings ShowExportToExcelButton="true" ShowAddNewRecordButton="false" />

<RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>

<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn>

<EditFormSettings>

<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>

</EditFormSettings>

</MasterTableView>

<FilterMenu EnableImageSprites="False"></FilterMenu>

<ExportSettings>

<Excel Format="Biff"></Excel>

</ExportSettings>

<ClientSettings ReorderColumnsOnClient="true">

<Selecting AllowRowSelect="True" />

</ClientSettings>

</telerik:RadGrid>

Ajax

answered on 02 Jan 2014

1 answer

87 views

Cursor Style on Design,html and preview buttons

Hi,
We are using radeditor in asp.net application.Can you provide code for changing the cursor style[i.e hand,] from hand to default on Design,Html and Preview buttons when the editor is disabled.

I need this functionality using javascript and c#.

Please revert back with comments ASAP.

thanks
srikanth

Editor

answered on 02 Jan 2014

1 answer

142 views

Radgrid Export Excel / CSV issue

Hi,

I am facing issue while exporting radgrid into excel format. when i click on export. It will export in excel format but my excel file get crashed after exporting.

Export works fine for 500 record. but if record 1500+ then excel crashed.

Please help
Thanks

Grid

answered on 02 Jan 2014

1 answer

130 views

disable the color when sorting in radgrid

Hi,
Is it possible to disable the color when sorting in radrid?

Grid

answered on 02 Jan 2014

10 answers

189 views

Export Grid to PDF

Hello,

I have a little problem hope that you can help me with this:

I have Rad Grid and I'm trying to export the Grid to PDF by clicking on the button:

Here is my Code:

<telerik:RadGrid

ID="rgActivities"

        runat="server"

        AutoGenerateColumns="False"

        AllowPaging="True"

        AllowSorting="True"

        PageSize="16"

        CellSpacing="0" GridLines="None"

        OnItemCommand="rgActivities_ItemCommand"

        OnSortCommand="rgActivities_OnSortCommand"

        OnPageIndexChanged="rgActivities_OnPageIndexChanged"

        EnableHeaderContextFilterMenu="True"

        Width="933px"

        Height="528px">

******* I have 6 Columns in the Grid *****

<asp:Button ID="mngBtnPDF" runat="server" ToolTip="Export To PDF" Text="" Visible ="false" OnClick="btnpdf_Click" CommandName="btnPDF_Click" />

******Code Behind*****

    Protected Sub btnPDF_Click(ByVal sender As Object, ByVal e As System.EventArgs)

        isExport = True

        rgActivities.ExportSettings.ExportOnlyData = True

        rgActivities.ExportSettings.IgnorePaging = True

        rgActivities.ExportSettings.OpenInNewWindow = True

        rgActivities.ExportSettings.ExportOnlyData = True

        rgActivities.ExportSettings.Pdf.PageWidth = Unit.Parse("297mm")

        rgActivities.ExportSettings.Pdf.PageHeight = Unit.Parse("210mm")

   rgActivities.MasterTableView.ExportToPdf()

    End Sub

Nothing happens Please help me.

Grid

answered on 02 Jan 2014

1 answer

35 views

hide filtering row when grid is in edit mode

Hi.
i want to hide filtering row when grid is in edit mode?

Grid

answered on 02 Jan 2014

1 answer

87 views

Facing error - Telerik.Web.UI.Overlay is undefined for RadMenu placed in user control with OutputCache

Hi Team,

We have used RadMenu in our application. we have override some CSS classes to provide our own images as menu items. It was working good so far. But, from the moment we added below tag in user control (which has Menu placed), menu has stopped drilling down and CSS are not working properly.

<%@ OutputCache Duration="43434" VaryByParam="None" VaryByCustom="abc" Shared="true" %>

We referred to your tutorial from h ere and set the CSS and Script reference accordingly, but even-though, the problem hasn't resolved.

I have observed below errors in the error console of the browser.

TypeError: Telerik.Web.UI.Overlay is undefined NavigationScript.js
ReferenceError: Sys is not defined. - This error has been resolved by placing "<location path="Telerik.Web.UI.WebResource.axd"></location>" tag in web.config. I have refereed this post for the same.

But some how, still my Menu is not behaving as expected.

Please assist ASAP. Let me know if you need more details.

Menu

answered on 02 Jan 2014