Questions on UI for ASP.NET AJAX Forum

1 answer

123 views

Exporting to xlsx also export GridEditCommandColumn but should not

Until recently I was exporting to Excel using ExcelML format. The GridEditCommandColumn was not exported (ExportOnlyData is set to true).
I am now exporting using XLSX format. Since then, the GridEditCommandColumn is exported along with data.
I would expect the same behaviour (no edit column).

Is it a bug ?
Is there an option to hide GridEditCommandColumn when exporting to xlsx ?

<telerik:RadButton ID="ButtonExportExcelML" runat="server" Text="Export to ExcelML" OnClick="ButtonExportExcelML_Click" />

<telerik:RadButton ID="ButtonExportXLSX" runat="server" Text="Export to XLSX" OnClick="ButtonExportXLSX_Click" />

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="true" ExportSettings-ExportOnlyData="true" OnNeedDataSource="RadGrid1_NeedDataSource">

<MasterTableView>

<Columns>

<telerik:GridEditCommandColumn ButtonType="ImageButton" />

</Columns>

</MasterTableView>

</telerik:RadGrid>

protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

RadGrid1.DataSource = new List<int> { 1,2,3,4,5,6};

}

protected void ButtonExportExcelML_Click(object sender, EventArgs e)

{

RadGrid1.ExportSettings.FileName = "TestExcelML";

RadGrid1.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;

RadGrid1.ExportToExcel();

}

protected void ButtonExportXLSX_Click(object sender, EventArgs e)

{

RadGrid1.ExportSettings.FileName = "TestXlsx";

RadGrid1.ExportSettings.Excel.Format = GridExcelExportFormat.Xlsx;

RadGrid1.ExportToExcel();

}

Grid

answered on 23 Aug 2016

3 answers

111 views

Database Pagination for RadGrid, not Page UI Pagination

Hi,

Does RadGrid has built-in Database Pagination in addition to the standard Grid UI Pagination?

For example:

In RadGrid standard Page UI Pagination, if you have page size of 25, when the data source is bound then the whole dataset (e.g. 500 member records) is retrieved from the database, but only renders the first 25 records. When the user clicks to go to page 2 the query is run to get the 500 records again and the telerik control will then render the next batch of 25 records in order. Does RadGrid has built-in Database Pagination in addition to the standard Grid UI Pagination that can limit the records retrieved from the database to, say 100 records rather than retrieving 500 records?

Grid

answered on 23 Aug 2016

3 answers

615 views

Database Pagination for RadGrid, not Page UI Pagination

Hi,

Does RadGrid has built-in Database Pagination in addition to the standard Grid UI Pagination?

For example:

In RadGrid standard Page UI Pagination, if you have page size of 25, when the data source is bound then the whole dataset (e.g. 500 member records) is retrieved from the database, but only renders the first 25 records. When the user clicks to go to page 2 the query is run to get the 500 records again and the telerik control will then render the next batch of 25 records in order. Does RadGrid has built-in Database Pagination in addition to the standard Grid UI Pagination that can limit the records retrieved from the database to, say 100 records rather than retrieving 500 records?

Grid

answered on 23 Aug 2016

30 answers

535 views

HeaderContextMenu add/remove items vb.net

I have successfully been able to hide items from the context menu. Is it possible to remove the separator bars that also appear in the menu? Also I am struggling to be able to add my own items. I have seen the examples in c#, however these do not translate well to vb. Below is the code I am using to hide the items. It would be much appreciated if someone could show me how to add new items. Once added I would also need to know how to capture the fired event when the menu item is clicked.

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

AddHandler RadGrid1.HeaderContextMenu.ItemCreated, AddressOf Me.HeaderContextMenu_ItemCreated

...

End Sub

Private Sub HeaderContextMenu_ItemCreated(ByVal sender As Object, ByVal e As RadMenuEventArgs)

Select Case (e.Item.Text)

Case "Clear Sorting"

e.Item.Visible = False

Case "Sort Ascending"

e.Item.Visible = False

Case "Sort Descending"

e.Item.Visible = False

End Select

End Sub

Grid

answered on 23 Aug 2016

1 answer

137 views

Add a task programmatically (Server Side)

Hi,

Beside data binding, is there any way to create a task programmatically with code?

Andy Ho

Gantt

answered on 23 Aug 2016

1 answer

208 views

[Solved] Combobox and Checkbox with Webservice

Hi

In below link, we can see combo-box with checkbox.

http://demos.telerik.com/aspnet-ajax/combobox/examples/functionality/checkboxes/defaultcs.aspx

When Page load i will use loop to mark selected items like below

RadComboBoxItem item = ComboBox.FindItemByValue(myValue);
if (item != null)
{ item.Checked = true; }

My Requirement:

Use ComboBox - Load on Demand Modes and use web service to load data

When Page load, how to show items initially (if it is a web service call)?

Can we do this? as in my project, i have userlist in drop down as webservice (normal combo box) and i need to change with combobox with checkbox functionality

Senthil

ComboBox

answered on 23 Aug 2016

6 answers

282 views

Print RadGrid contents

I tried the following solution but unfortunately, only the visible rows - displayed at the top of the grid - are printed, not those that you see on the screen after scrolling down. AutoGenerateColumns and AllowPaging are set to false.

http://www.telerik.com/community/code-library/aspnet-ajax/grid/print-radgrid-contents.aspx

    
            function PrintRadGrid() 
        
            { 
        
                var previewWnd = window.open('about:blank', '', '', false); 
        
                var sh = '<%= ClientScript.GetWebResourceUrl(radGrid1.GetType(),String.Format("Telerik.Web.UI.Skins.{0}.Grid.{0}.css",radGrid1.Skin)) %>'; 
        
                var styleStr = "<html><head><link href = '" + sh + "' rel='stylesheet' type='text/css'></link></head>"; 
        
                var htmlcontent = styleStr + "<body>" + $find('<%= radGrid1.ClientID %>').get_element().outerHTML + "</body></html>"; 
        
                previewWnd.document.open(); 
        
                previewWnd.document.write(htmlcontent); 
        
                previewWnd.document.close(); 
        
                previewWnd.print(); 
        
                previewWnd.close(); 
        
            }

I'm using Visual Studio 2008 / .Net 3.5 along with Telerik RadControls for ASP.NET AJAX 2009.3.1103.35

Any thoughts?

Thanks

Grid

answered on 23 Aug 2016

1 answer

141 views

Can RadEditor display Google Fonts?

I am using RadEditor with DNN Evoq Content 8.0.3. Is there a way to load Google fonts in the editor? I've included the following in my custom CSS file:

@import url(https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i,800,800i);

but, the editor is not loading the fonts in the iframe. Can anyone assist? Thank you.

Editor

answered on 23 Aug 2016

4 answers

99 views

Isssue with form element

Hi,

We are using the full featured RAD Editor for MOSS for one of our clients who want to use "Form element". It seems to work fine, except that it does not save everything. We can add a text input and then add a name attribut to it, but when we check in the page the attribute is removed (and we need to be able to add the name attribute). I think it might be Sharepoint who validates the html code and removes it somehow(?), but how should we go around this? Is "Form element" not suppose to work in RAD editor for MOSS (even though you can add it)?

For now we have added a javascript, setting the name attribute to the same as the id attribute (that we can save with the page). But this does not work for radiobuttons.

Best regards
Maria

WebParts for SharePoint

answered on 23 Aug 2016

2 answers

114 views

RadGrid and AjaxLoadingPanel

I have an ASP.Net with a RadGrid. VB.Net is the code-behind.

In the RadGrid, one of the columns is a hyperlink column. When the user clicks on that column, it brings them to an ASP.Net page to display the details of the item they clicked on.

When the user clicks on the hyperlink column, is there a way to show the AjaxLoadingPanel on the RadGrid since loading the page with the details may take more than a few seconds?

Please help!

Thanks!

Sincerely,

Keith Jackson

Grid

answered on 22 Aug 2016