This is a migrated thread and some comments may be shown as answers.

Connecting RadDiagrams to SQL database

4 Answers 171 Views
Diagram
This is a migrated thread and some comments may be shown as answers.
Application
Top achievements
Rank 1
Application asked on 18 Aug 2017, 10:25 AM

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.

 

4 Answers, 1 is accepted

Sort by
0
Vessy
Telerik team
answered on 21 Aug 2017, 08:00 AM
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.
0
Application
Top achievements
Rank 1
answered on 21 Aug 2017, 08:29 AM

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.

 

0
Vessy
Telerik team
answered on 28 Aug 2017, 08:34 AM
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.
0
Omar
Top achievements
Rank 3
Iron
Iron
Iron
answered on 30 Oct 2023, 10:43 AM

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
Telerik team
commented on 01 Nov 2023, 12:39 PM

Hi, Omar,

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

Tags
Diagram
Asked by
Application
Top achievements
Rank 1
Answers by
Vessy
Telerik team
Application
Top achievements
Rank 1
Omar
Top achievements
Rank 3
Iron
Iron
Iron
Share this question
or