Telerik Forums
UI for ASP.NET AJAX Forum
4 answers
278 views

I have a regular radGrid where I do some data formatting for localization.

 I want to get at the GridDataItem like so:

protected void OnItemDataBound(object sender, GridItemEventArgs e)
       {
           // We need to make sure empty entries are intialized to 0.00 and are set to the correct currency symbol
           if (e.Item is GridDataItem)
           {
               GridDataItem item = (GridDataItem)e.Item;
               FormatItem(item);

I know that a radPivotGrid does not have an OnItemDataBound event. I'm also not certain there is an event that receives the GridItemEventArgs?

It seems like the path I may want to take is to get at the individual cells within the pivot grid. Perhaps through the radPivotGrid1_OnCellDataBound event.

This event receives -> PivotGridCellDataBoundEventArgs

So my question is this. Am I on the right path? If I want to iterate the grid and format the numerical data how would I go about getting at the actual cell?

 Thanks,

julian

Maria Ilieva
Telerik team
 answered on 22 Apr 2015
4 answers
206 views

I was having trouble with the Insert Symbol tool - it would insert (for example) Ω which looks nice. But, after saving a re-opening the editor, the Ω was gone, replaced by an unknown character glyph. I enabled the ConvertCharactersToEntities filter so that the Insert Symbol tool would insert the entity code for the chosen symbol - in this example, Ω

This worked great until I tried to insert some javascript. My script included something like this:

    if (x > 5)

This got converted to:

    if (x > 5)

which doesn't work very well.

How can I keep my entities and still allow javascript?

Ianko
Telerik team
 answered on 22 Apr 2015
3 answers
58 views

using a RadTreeList I wonder how to hide the expand / collaps Icon when there are no records under parent item

What I found within this platform is

http://www.telerik.com/help/aspnet-ajax/grid-hide-expand-collapse-images-when-no-records.html

but as far as I can see this does not work for RadTreeList, doesn't it?

Santi
Top achievements
Rank 1
 answered on 22 Apr 2015
4 answers
264 views

Hi,

I have several InPlace editable RadGrids on my page located in an asp:DetailsView (together with other fields). The problem is when users update the grid(s) and do not commit changes by pressing the small Update button in a grid's row. Then, when they press the Update button of DetailsView all their changes are lost.

Is there any way to determine if a grid has any pending changes? Something like RadGrid.IsDirty property?

Thanks,

Leszek

 

Jaya
Top achievements
Rank 1
 answered on 22 Apr 2015
6 answers
616 views
I have a Radgrid with following items in a row-

GridClientSelectColumn
Several Template column Text Box
Few Template column RadDatePicker

On the client side I want to check "GridClientSelectColumn- checkbox " when a user changes value ( Onchange event ) in the template columns ( textbox/Date field )

How do I achieve it on the client side for multiple controls ( textbox/Date field )

thanks
Jaya
Top achievements
Rank 1
 answered on 22 Apr 2015
3 answers
101 views

I would like to know how to set the defaults of the From and To dates in a GridDateTimeColumn with EnableRangeFiltering="true".

My questions are in particular:

1) how do I set the From and To dates, and which date format should I use when setting them (dd/mm/yyyy, mm/dd/yyyy or yyyy/mm/dd) and which separator (/, - or .)?

2) how do I set the filter to be *between* the From/To dates and don't let the user to change it (not the dates, the type of filter)?

If there is a documentation page where these questions are answered then could you please share the link to it?

Jaya
Top achievements
Rank 1
 answered on 22 Apr 2015
2 answers
183 views

Hi,

 

I have a RadGrid with a GridTemplateColumn that has a label inside it. This label is populated after the initial datatable is bound to the grid.

Is there any way that I can filter on the contents of this label without having it in my initial datatable?

Here is my template column

<telerik:GridTemplateColumn AllowFiltering="true" HeaderText="Type(s)" UniqueName="column10"
                    AutoPostBackOnFilter="true" ShowFilterIcon="false">
    <ItemTemplate>
        <asp:Label ID="LocationTypeLabel" runat="server"></asp:Label>
    </ItemTemplate>
</telerik:GridTemplateColumn>

This is how I populate the label. The datatable _dtTypes is actually the second table returned in the dataset whereas the first table is the datasource of the grid.

For Each dr As DataRow In _dtTypes.Select("CustomerID = " & e.Item.DataItem("CustomerID"))
  lbl.Text = lbl.Text & dr("LocationType") & ", "
Next

Jaya
Top achievements
Rank 1
 answered on 22 Apr 2015
3 answers
434 views

Hi, 

My grid has 2 collumns showing dates from the datasource which is hooked up to the database.

I serached for a fix for this and found alot of diffrent solutions yet none of them seem to work for me.

 

Column in grid:

<telerik:GridBoundColumn DataField="created_date" DataType="System.DateTime" FilterControlAltText="Filter created_date column" HeaderText="created date" SortExpression="created_date" UniqueName="created_date" FilterControlWidth="75px" DataFormatString="{0:yyyy/MM/dd}" meta:resourcekey="GridBoundColumnResource24">
</telerik:GridBoundColumn>

 

DataBase:

 

Output:

 

Any suggestions is much appriciated.

Jaya
Top achievements
Rank 1
 answered on 22 Apr 2015
2 answers
134 views

Hello,

My Radgrod is paged (no custom paging).

On Itemdatabound i am trying to set an url to GridHyperLinkColumn

But ItemDataBound isnt called if I switch to another page.

Is there any way to call ItemDataBound when switching to another page with RadGrid?

 

Thanks in advance.

 

 

Jaya
Top achievements
Rank 1
 answered on 22 Apr 2015
2 answers
268 views

I am trying to recreate the example in the following demo:

http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/exporting/export-word-csv/defaultcs.aspx

In my case filtering by column is allowed and the data source is set in the code behind through the RadGrid1NeedDataSource method.

The data is loaded correctly and shown in the table, sorting by clicking on the column names work, the page navigation at the bottom-left corner works fine.

I am facing two problems:

1) The buttons located at the bottom-center for going to a specific page and changing the page size don't work.

2) None of the filters work, entering any text doesn't have any effect and pressing any filter icon, while using the IE F12 DevTools debugger, shows the following error:

SCRIPT5007: Unable to get property '_showFilterMenu' of undefined or null reference<br>File: script block (377), Line: 3, Column: 1

Do you have any idea how I could fix it?

My source code follows:

<form id="form1" runat="server">
<telerik:RadScriptManager runat="server" ID="RadScriptManager1" EnableScriptCombine="False" />
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" />
<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="RadAjaxLoadingPanel1">
    <asp:button id="Button1" text="Export to CSV" onclick="ExportToCvs" runat="server" />
    <telerik:RadGrid ID="RadGrid1" Skin="Silk" AutoGenerateColumns="false"
        AllowPaging="True" AllowSorting="True" AllowFilteringByColumn="True"
        PageSize="10" OnNeedDataSource="RadGrid1NeedDataSource" EnableLinqExpressions="false" runat="server">
        <ExportSettings HideStructureColumns="true" />
        <MasterTableView Width="100%" AllowFilteringByColumn="True">
            <PagerStyle Mode="NextPrevNumericAndAdvanced"></PagerStyle>
            <Columns>
                <telerik:GridBoundColumn DataField="Column1" HeaderText="Column1" />
                <telerik:GridDateTimeColumn DataField="Column2" UniqueName="Column2" HeaderText="Column2"
                    PickerType="DatePicker" EnableRangeFiltering="true" FilterControlWidth="110px"
                    EditDataFormatString="dd.mm.yyyy" DataFormatString="{0:dd/mm/yyyy}" DataType="System.DateTime"
                    ShowFilterIcon="false" CurrentFilterFunction="Between" />
                <telerik:GridBoundColumn DataField="Column3" HeaderText="Column3" />
            </Columns>
            <ItemStyle BackColor="#DFDFDF" />
            <HeaderStyle BackColor="#FFFFFF" ForeColor="#767676" />
            <AlternatingItemStyle BackColor="#FFFFFF" />
        </MasterTableView>
    </telerik:RadGrid>
</telerik:RadAjaxPanel>
</form>

In the code behind:

protected void RadGrid1NeedDataSource(object source, GridNeedDataSourceEventArgs e) {
    using (SqlConnection conn = new SqlConnection(Settings.Default.ConnectionString)) {
        DataContext db = new DataContext(conn);
        Table<Item> items = db.GetTable<Item>();
        IEnumerable<Item> query = from x in items select x;
        RadGrid1.DataSource = query.ToList();
    }
}

Jaya
Top achievements
Rank 1
 answered on 22 Apr 2015
Narrow your results
Selected tags
Tags
+? more
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?