Is there any way to include the Treelist nodes in xml

Engº Silvio Cruz

created 13 years ago

Is there any method extension or smoething to include the Treelist nodes in XML SaveLayoutToStream.
I want this behaviour to preserve both data and layout, because i'm using an treelist as a "Favorites" and as a "Recent Items" implementation.
The goal is to save this to a sql databse. I already save the xml using the refered mrthos, but how can i include data in this method.

Show previous comments (1)

Engº Silvio Cruz 13 years ago

can u please send me a sample of saving nodes to xml and reading nodes to xml from the treelist.
Thanks in Advance…

DevExpress Support Team 13 years ago

Hi Silvio,
Please give me some additional time and I will provide you with an example.
Thanks,
John.

Engº Silvio Cruz 13 years ago

For instance I use this method to save treelist xml layout to database, how can i upgrade use the same method to save the nodes to database.
public static bool GravaConfiguracaoGrelha(TreeList grelha, String nomeGrelha)
        {
            try
            {
                MemoryStream stream = new MemoryStream();
                grelha.SaveLayoutToStream(stream);
                stream.Seek(0, SeekOrigin.Begin);
                StreamReader reader = new StreamReader(stream);
                Plat.PRIConnector.Executa("DELETE FROM TDU_ConfiguracaoGrelhas Where CDU_Grelha='" + nomeGrelha + "' and CDU_Utilizador='" + (Plat.PriLogin == null ? "" : Plat.PriLogin.Utilizador) + "'");
                Plat.PRIConnector.Executa("INSERT INTO TDU_ConfiguracaoGrelhas(CDU_ID, CDU_Grelha, CDU_Config, CDU_Utilizador) VALUES ('" + Guid.NewGuid().ToString() + "', '" + nomeGrelha + "', '" + reader.ReadToEnd() + "', '" + (Plat.PriLogin == null ? "" : Plat.PriLogin.Utilizador) + "')");
            }
            catch (Exception)
            {
                return false;
            }
            return true;
        }

Answers approved by DevExpress Support

DevExpress Support Team

created 13 years ago (modified 9 years ago)

Hi Silvio,
Attached is a small sample project that illustrates how to add datasource data to layout data. I have used LINQ To Xml. I have saved data to a file, but you can also save it to a stream as the XElement object supports different save methods.
Does this solution meet your requirements? If not, please feel free to reactivate ticket.
Thanks,
John.

dxSample.zip

Show previous comments (2)

Engº Silvio Cruz 13 years ago

There was an error in your aproach, in the method: "simpleButton1_Click", it should be:
private void simpleButton1_Click(object sender, EventArgs e)
        {
            MemoryStream LayoutFile = new System.IO.MemoryStream();//(LayoutFileName, System.IO.FileMode.Create);
            treeList1.SaveLayoutToStream(LayoutFile, OptionsLayoutBase.FullLayout);
            LayoutFile.Seek(0,SeekOrigin.Begin);

MemoryStream DataFile = new System.IO.MemoryStream();//(DataFileName, System.IO.FileMode.Create);
            ds.WriteXml(DataFile);
            DataFile.Seek(0,SeekOrigin.Begin);
            XElement LayoutElement = XElement.Load(LayoutFile);
            XElement DataElement = XElement.Load(DataFile);
            LayoutElement.Add(new XElement("DataSet", DataElement));
            LayoutElement.Save("Result.xml");
            DataFile.Close();
            LayoutFile.Close();
        }
Anyways, i was trying to use the same aproach but with MemoryStream and StreamReader's but i can't seem to make it work.
My method is the following (and it gives me no error but also doen't save any data to the column's "CDU_Favoritos", and "CDU_MaisRecentes" whtch are xml(.) type):
What am i doing wrong ?
Please Help me…
public static bool GravaConfiguracaoFavoritosMaisRecentes(TreeList grelhaFavoritos, TreeList grelhaMaisRecentes, String nomeNavegador, bool includeData = false)
        {
            DataTable dtFavoritos = new DataTable();
            DataSet dsFavoritos = new DataSet();
            dsFavoritos.Tables.Add(dtFavoritos);
            DataTable dtMaisRecentes = new DataTable();
            DataSet dsMaisRecentes = new DataSet();
            dsMaisRecentes.Tables.Add(dtMaisRecentes);
            try
            {
                /////////////////////-------------------GRAVAR FAVORITOS-------------------////////////////////////
                MemoryStream streamLayoutFavoritos = new MemoryStream();
                grelhaFavoritos.SaveLayoutToStream(streamLayoutFavoritos);
                streamLayoutFavoritos.Seek(0, SeekOrigin.Begin);
                XElement LayoutElementFavoritos = XElement.Load(streamLayoutFavoritos);
                LayoutElementFavoritos.Name = "Layout";
                if (includeData)
                {
                    dtFavoritos.Columns.Add("Favoritos", typeof(string));
                    dtFavoritos.Columns.Add("Opcao", typeof(string));
                    for (int i = 0; i < grelhaFavoritos.Nodes.Count; i++)
                        dtFavoritos.Rows.Add(new object[] { grelhaFavoritos.Nodes[i].GetValue("Favoritos"), grelhaFavoritos.Nodes[i].GetValue("Opcao") });
                    MemoryStream streamDataFavoritos = new MemoryStream();
                    dsFavoritos.WriteXml(streamDataFavoritos);
                    streamDataFavoritos.Seek(0, SeekOrigin.Begin);
                    XElement DataElementFavoritos = XElement.Load(streamDataFavoritos);
                    LayoutElementFavoritos.Add(new XElement("Dados", DataElementFavoritos));
                }
                MemoryStream mainStreamFavoritos = new MemoryStream();
                LayoutElementFavoritos.Save(mainStreamFavoritos);
                StreamReader readerFavoritos = new StreamReader(mainStreamFavoritos);
                /////////////////////-------------------FIM GRAVAR FAVORITOS-------------------////////////////////////
                /////////////////////-------------------GRAVAR MAIS RECENTES-------------------////////////////////////
                MemoryStream streamLayoutMaisRecentes = new MemoryStream();
                grelhaFavoritos.SaveLayoutToStream(streamLayoutMaisRecentes);
                streamLayoutMaisRecentes.Seek(0, SeekOrigin.Begin);
                XElement LayoutElementMaisRecentes = XElement.Load(streamLayoutMaisRecentes);
                LayoutElementMaisRecentes.Name = "Layout";
                if (includeData)
                {
                    dtMaisRecentes.Columns.Add("Favoritos", typeof(string));
                    dtMaisRecentes.Columns.Add("Opcao", typeof(string));
                    for (int i = 0; i < grelhaMaisRecentes.Nodes.Count; i++)
                        dtMaisRecentes.Rows.Add(new object[] { grelhaMaisRecentes.Nodes[i].GetValue("Favoritos"), grelhaMaisRecentes.Nodes[i].GetValue("Opcao") });
                    MemoryStream streamDataMaisRecentes = new MemoryStream();
                    dsMaisRecentes.WriteXml(streamDataMaisRecentes);
                    streamDataMaisRecentes.Seek(0, SeekOrigin.Begin);
                    XElement DataElementMaisRecentes = XElement.Load(streamDataMaisRecentes);
                    LayoutElementMaisRecentes.Add(new XElement("Dados", DataElementMaisRecentes));
                }
                MemoryStream mainStreamMaisRecentes = new MemoryStream();
                LayoutElementMaisRecentes.Save(mainStreamMaisRecentes);
                StreamReader readerMaisRecentes = new StreamReader(mainStreamMaisRecentes);
                /////////////////////-------------------FIM GRAVAR MAIS RECENTES-------------------////////////////////////
                Plat.PRIConnector.Executa("DELETE FROM TDU_ConfiguracaoNavegador Where CDU_Navegador='" + nomeNavegador + "' and CDU_Utilizador='" + (Plat.PriLogin == null ? "" : Plat.PriLogin.Utilizador) + "'");
                Plat.PRIConnector.Executa("INSERT INTO TDU_ConfiguracaoNavegador(CDU_ID, CDU_Navegador, CDU_Favoritos, CDU_MaisRecentes, CDU_Utilizador) VALUES ('" + Guid.NewGuid().ToString() + "', '" + nomeNavegador + "', '" + readerFavoritos.ReadToEnd() + "', '" + readerMaisRecentes.ReadToEnd() + "','" + (Plat.PriLogin == null ? "" : Plat.PriLogin.Utilizador) + "')");
            }
            catch (Exception)
            {
                return false;
            }
            return true;
        }

Engº Silvio Cruz 13 years ago

Please help me…

DevExpress Support Team 13 years ago

Hi Silvio,
Thank you for your feedback. After data has been saved to a memory stream, the stream current position points to the end of the stream. Try to call the Seek(0, SeekOrigin.Begin) method for all memory streams before saving them to the database.

C#
...  
mainStreamFavoritos.Seek(0, SeekOrigin.Begin);  
 StreamReader readerFavoritos = new StreamReader(mainStreamFavoritos);  
...  
mainStreamMaisRecentes.Seek(0, SeekOrigin.Begin);  
 StreamReader readerMaisRecentes = new StreamReader(mainStreamMaisRecentes);  
...

Please feel free to reactivate this ticket if you need any further assistance on this issue.
Thanks,
John.

Engº Silvio Cruz 13 years ago

Thanks for your support.
Issue Solved.

Engº Silvio Cruz 13 years ago

Thanks for your support.
Issue Solved.

Created: December 3, 2011 5:02 PM

Modified: December 12, 2011 4:22 PM

Platform: WinForms

Product: XtraTreeList Suite

Build: 11.2.5

IDE: Microsoft Visual Studio 2010

Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

Is there any way to include the Treelist nodes in xml

Answers approved by DevExpress Support

Recently viewed tickets