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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to save file *.edd to database

Thread ID:





64301 Jul 18,2007 07:37 AM UTC Jul 7,2008 10:35 AM UTC ASP.NET Web Forms (Classic) 6
Tags: DiagramWebControl
Asked On July 18, 2007 07:37 AM UTC

Hi everybody!
Plz help me!
How to save file *.edd to database after create it.

J.Nagarajan [Syncfusion]
Replied On July 23, 2007 11:31 PM UTC

Hi Cuongnq,

Sorry for the delay in getting back to you. The diagram can be serialized in XML format using the Diagram.SaveSoap/LoadSoap methods. You can also save and load the diagram in the database. Please refer to the following code snippet

DataTable dt;
protected void Button1_Click(object sender, EventArgs e)
dt = new DataTable("MyTable");
dt.Columns.Add("Diagram", typeof(object));
DataRow row = dt.NewRow();
row["Diagram"] = this.DiagramWebControl1;

protected void Button2_Click(object sender, EventArgs e)
DiagramWebControl d1 = dt.Rows[0]["Diagram"] as DiagramWebControl;

Please let us know if you have any questions.


Replied On July 26, 2007 03:02 AM UTC

Nice code, Thanks

Replied On October 15, 2007 10:46 AM UTC

You have showed how to store in a memory table.i want to know how to store this into a database table and datatype i need to choose to store the diagram to a database table.
i created a table with a varbinary(max) column type. but i am getting an data type mismatch error when i am trying to save the diagram object to the varbinary column.


Mohamed Suhaib Fahad A. [Syncfusion]
Replied On October 18, 2007 06:51 AM UTC

Hi Balaji,

Thanks for evaluating Syncfusion products.

We have used SQL server 2005 express edition to create the sample for you.

Here are the details about your query,

Saving diagram into Database

You can save the node objects into database. Please follow the steps below for this.
1) First save the diagram in EDD format.
1) Convert diagram(EDD) into bytes using Stream.
2) Insert bytes into table column.

You can use varbinary(max) datatype for inserting diagram since diagram file size will be large to access.

Similarly you can load the diagram from database by reading it from Stream.

Please refer the working sample and let us know if you still face any issues.


Also please let us know if you have any other queries.

You can follow up any other queries in DirectTrac itself (in which you had created an incident earlier).


Karl Kemp
Replied On July 3, 2008 02:31 PM UTC

Just a note to future searchers, I'm pretty sure the code attached to this sample doe NOT do what the author thinks it does.

The code saves and loads a diagram from a file on disk, then reads diagram data from a database but does nothing with it.

It DOES NOT appear to load the diagram data directly from the database, as is claimed.

J.Nagarajan [Syncfusion]
Replied On July 7, 2008 10:35 AM UTC

Hi ,

Sorry for the inconvenience caused. You can get the byte array of saved edd file using SqlDataReader.GetValue(0) method. Then you can convert that byte array to MemoryStream and load the diagram file.

Please refer to the modified sample that demonstrates this completely.


Please refer to it and let me know if this helps.



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.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon 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.Close Icon