Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Generate XML to a string column in a dataset.
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00745742
Message ID:
00745816
Views:
23
Here is how you can do it.
	DataTable loDT  = new DataTable();
	System.Type myDataType;
	myDataType = System.Type.GetType("System.Object");
	DataColumn loCL = new DataColumn("myColumn",myDataType);
	loDT.Columns.Add(loCL);
	DataRow	 loROW = loDT.NewRow();
	loROW[0] = this.treeView1.Nodes[0];
	loDT.Rows.Add(loROW);

	TreeNode loNewNode = (TreeNode) ((TreeNode) loDT.Rows[0][0]).Clone();
	loNewNode.Text = "New Node";
	this.treeView2.Nodes.Add(loNewNode);
I am adding new node to another TreeView control. You can add it to the same one after removing all nodes from it.

>It appears that your code will allow the save of the nodes but I can't seem to find a way to convert it back to a value the treeview will like. I am using Option strict on which won't convert it implicitly.
>
>
>
>>I guess you can store any kind of "object" to a column in a data table. I tried to store Nodes collection in the following example. In the same fashin, you can either store XML as String of Stream.
>>
>>
>>DataTable loDT  = new DataTable();
>>DataColumn loCL = new DataColumn();
>>loDT.Columns.Add(loCL);
>>DataRow	 loROW = loDT.NewRow();
>>loROW[0] = this.treeView1.Nodes;
>>loDT.Rows.Add(loROW);
>>
>>
>>>Has anyone figured out how to generate a xml stream to a column in a dataset instead of to a file?
>>>
>>>I am saving treeview information to an xml document and do to customer contraints, I need to save the xml to a column in a dataset and be able to read it back to recreate the treeview.
>>>
>>>I am using the following code in VB.Net to accomplish part of the process although it only writes to a file.
>>>
>>>
>>>
>>>        Dim formatter As SoapFormatter = New SoapFormatter()
>>>        Dim stream As Stream = New FileStream("c:\Free.xml", FileMode.Create, FileAccess.Write, FileShare.None)
>>>
>>>        Dim root As New TreeNode()
>>>        Dim node As TreeNode
>>>        For Each node In treForceStructure.Nodes
>>>            root.Nodes.Add(CType(node.Clone(), TreeNode))
>>>        Next node
>>>        formatter.Serialize(stream, root)
>>>        stream.Close()
>>>
>>>
>>>
>>>Any ideas on how to accomplish this? I can't seem to find any info on it.
>>>
>>>Thanks,
>>>Pat.
- Jayesh
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform