We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

TreeGrid not work correctly

Thread ID:

Created:

Updated:

Platform:

Replies:

120253 Sep 14,2015 05:37 PM Sep 29,2015 08:22 AM ASP.NET Web Forms 7
loading
Tags: TreeGrid
Roimer Machacón Otero
Asked On September 14, 2015 05:37 PM

Hi we're using syncfusion treegrid. Now this don't work correctly.

Attached image with the presentation of the treegrid. We're using the syncfusion version number 12.2.0.36 for more information

The query that we use for the datasource is this:

select '' AS Id, LTRIM(RTRIM(Lote)), '' AS Uma, Lote.Siembra, NULL AS ParentId
from Tlote
Union
select '' AS Id, LTRIM(RTRIM(Lote)), Uma, Lote.Siembra, LTRIM(RTRIM(IdLote)) AS ParentId
from Lote inner join UmaLote on Lote.Lote = Uma.Lote
order by Id asc

After by code we put an id numeric in the column id

Another question how to put a scrollbar for that the treegrid not expand the page??

Attachment: error_treegrid_eeec0edc.rar

Mahalakshmi Karthikeyan [Syncfusion]
Replied On September 15, 2015 09:08 AM

Hi Roimer,

Thanks for contacting Syncfusion support,

We have analyzed the query you have provided and came to know that the table name you are using in the inner join condition is miss matching (UmaLote on Lote.Lote = Uma.Lote)  here it must be UmaLote on Lote.Lote = UmaLote.Lote   

And also please check the code you are using for id. Since it is a self-reference data source the IdMapping and parentIdMapping must be in proper way to make a hierarchy grid. Please refer the below query for details.

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

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

            SelectCommand="select Id,Lote.Lote, null as ParentId, '' as Siembra

             from [Tlote] Lote UNION select '' as Id, Lote.Lote, idLote as ParentId, Siembra from [Lote] Lote inner join [UmaLote] on Lote.Lote = UmaLote.Lote order by Id asc">

        </asp:SqlDataSource>

We have also prepared sample based on your requirement for your convenience. You can find the sample under the following location.

Sample: http://www.syncfusion.com/downloads/support/forum/120253/ze/JoinQuery1395024520

Regards,

Mahalakshmi K.


Roimer Machacón Otero
Replied On September 23, 2015 05:29 PM

Hi, I downloaded the example and this not work. Attached image with the error message.

Another question I have the treegrid in a second tab of Jquery UI, in this tab for the treegrid only appear the row title, without data

Attachment: errortreegrid_34fdad83.rar

John Rajaram [Syncfusion]
Replied On September 24, 2015 01:03 PM

Hi Roimer,

Query 1: I downloaded the example and this not work. Attached image with the error message

Solution: we were unable to reproduce the reported issue in the sample. Could you please check your assembly reference and the script you are using in your sample? If you still face any issue please get back to us by modifying the attached sample to reproduce it.

Query 2: Another question I have the treegrid in a second tab of Jquery UI, in this tab for the treegrid only appear the row title, without data

Solution: We suggest you to render the Tab control inside a div element to avoid such alignment issues . Please refer the below code example for details.

<form id="form1" runat="server" style="overflow: hidden; padding:0; margin: 0;height:100%;width:100%;">

       <div>

           <ej:Tab ID="Controls" runat="server">

           <Items>

               <ej:TabItem ID="Chartctrl" Text="Chart Control">

                   <ContentSection>

                        <div>

                            <ej:Chart runat="server"></ej:Chart>

                        </div>

                       </ContentSection>

                 

               </ej:TabItem>

               <ej:TabItem ID="Treegridctrl" Text="TreeGrid Control">

                   <ContentSection>

                   <ej:TreeGrid ID="TreeGrid" runat="server"

                   //…

                   </ej:TreeGrid>

                   </ContentSection>

                </ej:TabItem>

              

             </Items>

             </ej:Tab>


          </div>

    </form>

We have also prepared a sample based on your query, you can find the sample under the following location.

Sample: http://www.syncfusion.com/downloads/support/forum/120253/ze/JoinQuery471371695

If you are still facing the issues, please get back to us by modifying the sample according to your requirement.

Regards,

John R


Roimer Machacón Otero
Replied On September 28, 2015 10:45 AM

Hi, the problem persist, in the funcionality of the treegrid

Roimer Machacón Otero
Replied On September 28, 2015 10:58 AM

Watching the example of the treegrid in the syncfusion dashboard exist in the definition of the treegrid ChildMapping="SubTasks" and in the table where extract the data "SubTasks" not is a columns of the table in the database. What mean this ChildMapping ??

Roimer Machacón Otero
Replied On September 28, 2015 12:30 PM

Hi, Another problem observed is that the treegrid fail when this is in updatePanel from asp.net

Dinesh Kumar Nagarathinam [Syncfusion]
Replied On September 29, 2015 08:22 AM

Hi Roimer,

Query 1: The problem persist, in the funcionality of the treegrid

Solution: we were unable to reproduce the reported issue in the sample. Could you please check your assembly reference and the script you are using in your sample? If you still face any issue please get back to us by modifying the attached sample to reproduce it , or can you please share more details regarding which functionality is not working in TreeGrid.

Query 2: Watching the example of the treegrid in the syncfusion dashboard exist in the definition of the treegrid ChildMapping="SubTasks"and in the table where extract the data "SubTasks" not is a columns of the table in the database. What mean this ChildMapping ??

Solution: It is not mandatory to define the ChildMapping property to render TreeGrid, while using SQL database or self-referential datsource. We have mapped ‘ChildMapping’ property to identify the child items of a parent , but we can still identify the child items with ‘record.childRecords’ object. We should provide ChildMapping property only when rendering TreeGrid with JSON data.

Query 3: Another problem observed is that the treegrid fail when this is in updatePanel from asp.net.

Solution: We are not reproduce this issue from our side. We suggest you to define ScriptManager tag before defining the UpdatedPanel tag.

Code Snippet:

<form id="form1" runat="server" style="overflow: hidden; padding:0; margin: 0;height:100%;width:100%;">

<asp:ScriptManager ID="ScriptManager" runat="server" EnablePageMethods="True" />

  <asp:UpdatePanel ID="UpdatePanel" UpdateMode="Conditional" runat="server">

          <ContentTemplate>

            <ej:TreeGrid ID="TreeGrid" runat="server">

                   //...

            </ej:TreeGrid>

            </ContentTemplate>

  </asp:UpdatePanel>

</form>



We have prepared a sample based on this and you can find the sample under the following location,
Sample: http://www.syncfusion.com/downloads/support/forum/120253/ze/TreeGridSample1532647062 
 
Regards,
Dinesh kumar.N


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;