Connecting RadDiagrams to SQL database

4 posts, 0 answers
  1. Application
    Application avatar
    5 posts
    Member since:
    Dec 2013

    Posted 18 Aug Link to this post

    Can anyone help with a database structure to create RadDiagram Shapes and Connectors in the database using co-ordinates to automatically load the diagram.

    I couldn't find anything in the demos or docs. For example on the link beloq the sql connections are shown but not what structure is need to create this?

    http://demos.telerik.com/aspnet-ajax/diagram/examples/databind/defaultcs.aspx  

    Thank you.

     

  2. Vessy
    Admin
    Vessy avatar
    1677 posts

    Posted 21 Aug Link to this post

    Hello,

    Detailed information regarding the Data base structure expected both for shapes and connections in the diagram is available in the following help articles:
    In addition, you can download the whole demos application and examine the used DiagramShapes and DiagramConnecions tables of the used Telerik.mdf database form your Telerik account here:
    https://www.telerik.com/account/product-download?product=RCAJAX

    For convenience, I am also attaching the structure of both used tables to this reply.

    Regards,
    Vessy
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Application
    Application avatar
    5 posts
    Member since:
    Dec 2013

    Posted 21 Aug in reply to Vessy Link to this post

    Thanks for the information that's really helpful, and I'll take a look at the demo.

    Please could you also let me know if what I'm trying to achieve is do-able in Radiagram? I'm trying to create a family tree structure so need to draw a tree structure where a node could have 2 parents in the tree. I've ruled out using RadOrgChart as this can only handle a single parent in the tree, but wondered if RadDiagram had more flexibility. I've been trying different layout types but from what have discovered so far only a single parent node may be possible? 

    Many thanks.

     

  4. Vessy
    Admin
    Vessy avatar
    1677 posts

    Posted 28 Aug Link to this post

    Hi,

    It is possible to have shapes with ore than one roots - you can position them either by specifying the coordinates for each shape specifically, or by choosing a predefined layout type:
    http://docs.telerik.com/devtools/aspnet-ajax/controls/diagram/structure/layout/overview

    For example, you can have a similar configuration:
    <telerik:RadDiagram ID="ModelReport" runat="server">
        <LayoutSettings Enabled="true">
        </LayoutSettings>
        <ShapesCollection>
            <telerik:DiagramShape Id="s1"></telerik:DiagramShape>
            <telerik:DiagramShape Id="s2"></telerik:DiagramShape>
            <telerik:DiagramShape Id="s3"></telerik:DiagramShape>
            <telerik:DiagramShape Id="s4"></telerik:DiagramShape>
        </ShapesCollection>
        <ConnectionsCollection>
            <telerik:DiagramConnection>
                <FromSettings ShapeId="s1" />
                <ToSettings ShapeId="s2" />
            </telerik:DiagramConnection>
            <telerik:DiagramConnection>
                <FromSettings ShapeId="s1" />
                <ToSettings ShapeId="s3" />
            </telerik:DiagramConnection>
            <telerik:DiagramConnection>
                <FromSettings ShapeId="s2" />
                <ToSettings ShapeId="s4" />
            </telerik:DiagramConnection>
            <telerik:DiagramConnection>
                <FromSettings ShapeId="s3" />
                <ToSettings ShapeId="s4" />
            </telerik:DiagramConnection>
        </ConnectionsCollection>
    </telerik:RadDiagram>


    Regards,
    Vessy
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top