Telerik Forums
UI for ASP.NET AJAX Forum
4 answers
179 views
Hello,

We have to deal with a large amount of data from an Nhibernate queryOver (about 40.000 to 1.000.000 rows).
We need to show this data as a pivot grid restitution in our web app, and apparently, that kind of component would suits our needs.

As we have a lot of data : 
- Would it be better to use Server-side pivot grid instead of KendoUI component ?
- Is it possible to do a dynamic skip/take with an Nhibernate query to avoid all data in memory by getting grid current settings like filter, order, paging ?
- If this is not possible with Nhibernate, would it be with a simple SQL query ?

Regards,
Maxime LEMARE.

Au
Top achievements
Rank 1
 answered on 22 Apr 2015
1 answer
235 views

Hi

 This is My code . Here when i enter the Total textbox i need show the footer template for running Total how will do this client side this any one guide me.

 <telerik:RadGrid ID="Grd1" runat="server" AutoGenerateColumns="false" ShowFooter="true">
            <MasterTableView DataKeyNames="EmpId">
                <Columns>
                    <telerik:GridBoundColumn DataField="EmpName" HeaderText="EmpName" UniqueName="EmpName"></telerik:GridBoundColumn>
                    <telerik:GridTemplateColumn HeaderText="Amount" UniqueName="Amount">
                        <ItemTemplate>
                            <asp:TextBox ID="TXTTOTAL" runat="server" Text='<%# Eval("Empamt") %>'></asp:TextBox>
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                </Columns>
            </MasterTableView>
        </telerik:RadGrid>

Eyup
Telerik team
 answered on 22 Apr 2015
4 answers
304 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
245 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, &Omega;

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 &gt; 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
62 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
281 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
645 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
112 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
197 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
441 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
Narrow your results
Selected tags
Tags
+? more
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?