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.

Drill Down and Shape custom properties databse persistence

Thread ID:





91540 Nov 23,2009 09:47 AM Dec 1,2009 07:49 AM ASP.NET Web Forms (Classic) 9
Tags: DiagramWebControl
Domenico Mozzone
Asked On November 23, 2009 09:47 AM

Good morning,
I’m evaluating Syncfusion winforms diagram library.
I have some requisites that I could not verify looking at documents and samples.
1. I need to implement a top down diagram structure. The behavior is similar to drill down example. Expanding a node I need to navigate to another diagram persisted on file system or database. Could you help me to understand how to do it?
2. I would like to use diagrams to implement a graphical data input. My idea is to create custom shapes with custom properties, and bind such properties to existing database tables. Have you an example to solve a problem like this?
Thank you very much
Domenico Mozzone

Dinesh M [Syncfusion]
Replied On November 25, 2009 08:16 AM

Hi Domenico,

We will update you with a sample for this requirement in 1 business day.

Thank you for your patience.


Domenico Mozzone
Replied On November 26, 2009 10:17 AM

Thank you Dinesh.
Meanwhile I focused my requisites. As I have an sql database with “nodes” and “connectors” tables I tried in vain to save a custom Symbol (derived by your Syncfusion sample CustomSymbol_2008) into Nodes table. I tried different ways but I did not succeeded in finding the correct way to:
1. Create an sql database table to save custom symbols
2. To extend custom symbol in order to be persisted (I’m using a LINQ to SQL Datacontext)
So my new questions are:
- How can I save (and read into a diagram) custom symbols, with custom properties, to sql database table?
- How can I customize the behavior and properties of a symbol designed with the Essential Diagram symbol designer by subclassifying it at application level? The custom symbol example provided with Syncfusione demo seems to do such, reading explanation, but looking at code I can’t understand how the task is performed: it seems that the custom symbol is build using only code, not subclassifying it using a symbol designer Essential Diagram symbol designer.
These points are key features for my application.
Best Regards

Dinesh M [Syncfusion]
Replied On November 26, 2009 11:30 AM

Hi Domenico,

Sorry for the delay in getting back to you.

I have prepared a sample that meets some of your requirement that you have mentioned in your first post.
1. Gets data required to create nodes from SQL.
2. Position nodes with a top down diagram structure using DirectedTreeLayout Manager.
3. You can drill down a level by means of double clicking it.
4. I have a separate class "Employee", and this acts as a interface between the nodes and database.

I will modify my sample further to use a custom symbol that shows the properties of Employee class in the property editor for a node.
However a symbol designed using SymbolDesigner cannot be made to have custom properties and hence we need to derive existing class as in "CustomSymbols" demo.



Domenico Mozzone
Replied On November 26, 2009 11:59 AM

Thank you very much Dinesh.
I’m examining your example. I think that it will solve part of my needs.
In your further modification mentioned in your reply please take into consideration also that I should save (and read into a diagram) custom symbols, with custom properties, to sql database table. Till now I can’t succeeded in this task. I suppose that I miss something converting the custom symbol (derived from Group) into an object that can be saved in sql database table (I tried byte array).
Thank you Dinesh
Bst Regards,

Domenico Mozzone
Replied On November 27, 2009 06:31 AM

Hi Dinesh,
I succeeded in persisting diagram symbols (Mysymbol object taken from a Syncfusion example) on a SQL Database.
Please see attached solution.
The custom symbol has a simple property that seems not to be correctly: if I change the property (clicking on the symbol) I can see the changed, but when I save and reload from database the property is always set to 0. Where’s my error(s)?
Thank you
Best Regards


Domenico Mozzone
Replied On November 27, 2009 08:39 AM

I'm sorry.
I forgot the override of GetObjectData...
protected override void GetObjectData(SerializationInfo info, StreamingContext context)
base.GetObjectData(info, context);
info.AddValue("clickCount", clickCount, clickCount.GetType());

and modifying serialization constructor
protected MySymbol(SerializationInfo info, StreamingContext context)
: base(info, context)
ClickCount = (int)info.GetValue("clickCount", typeof(int));
aleso the property is correctly persisted into sql database.

Best Regards

Dinesh M [Syncfusion]
Replied On November 30, 2009 07:55 AM

Hi Domenico,

Please check the attached sample which might also help you in making the custom properties to be separated out to a new class.

Let me know if you have any questions.



Domenico Mozzone
Replied On November 30, 2009 09:08 AM

Thank you very much.
I had to modify the serialization constructor of supportive class for the _customValue in
_customValue = float.Parse(entry.Value.ToString());
to avoid a serialization error.
Now I'm trying to binary serialize on sql database table, using you example.
Best Regards

Dinesh M [Syncfusion]
Replied On December 1, 2009 07:49 AM

Hi Domenico,

Thanks for the update.



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.