Connecting RadDiagrams to SQL database

[Application]

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.

 

[Vessy]

Hello,

Detailed information regarding the Data base structure expected both for shapes and connections in the diagram is available in the following help articles:

• http://docs.telerik.com/devtools/aspnet-ajax/controls/diagram/data-binding/server-side/shapes
• http://docs.telerik.com/devtools/aspnet-ajax/controls/diagram/data-binding/server-side/connections

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

[Application]

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.

 

[Vessy]

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

[Omar]

Hi Vessy,

Please can you help me with my post regarding the diagram, I am trying the examples but the diagram is not displaying.

https://www.telerik.com/forums/diagram-not-displaying#1629051

Thanks,

Omar

[Vessy]

Hi, Omar,

Sure, I will do my best to help you. Please, refer my answers there.