Hej!
Jag har en treeview (Microsofts) i asp.net. Jag hämtar information från databasen och denna är i xml-format. Hur gör jag för att fylla trädet med denna information?

Mvh,
Naz

Saxat från annan sida:

Very often applications have need to manage hierarchical data and indeed such that hierarchy is unlimited. This has been a bit problem in databases, although solved using self-referencing tables or alternative solutions. OK, but how to display such data that uses self-referencing table?

With ASP.NET one optional answer is to use TreeView control. TreeView gives developers chance to display hierarchical data as I’ll demonstrate in this article. What makes TreeView so cool is that it can also display elements (tree nodes) based on XML.

Overview of things that developer needs to do to get this feature are:

Get the data from self-referencing table into DataSet
Create DataRelation that corresponds to relation in self-referencing table and add it to DataSet’s Relations collection. DataRelation’s Nested property needs to be true.
Get DataSet’s XML representation and apply XSLT transformation for it so that result corresponds to XML syntax used by TreeView control.
Bind TreeView.

Shortly, CategoryID is the primary key and ParentCategoryID is foreign key referencing to CategoryID with default value NULL. CategoryName represents text I want to display in TreeView.

Get data into DataSet
//Connection to database

OleDbConnection objConn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("db.mdb") + ";Persist Security Info=False");

//SQL query to get data from CATEGORIES table
OleDbCommand objCommand=new OleDbCommand("SELECT * FROM CATEGORIES",objConn);


//OleDbDataAdapter
OleDbDataAdapter objDa =new OleDbDataAdapter(objCommand);

//DataSet
DataSet ds=new DataSet("CATEGORIESDS");

//Fill DataSet
objDa.Fill(ds ,"CATEGORIES");

//Create DataRelation
DataRelation drel=new DataRelation("CATEGORIES_RECURSIVE",
ds.Tables["CATEGORIES"].Columns["CategoryID"],
ds.Tables["CATEGORIES"].Columns["ParentCategoryID"]);

//Make sure relation is nested
drel.Nested =true;

//Add relation to DataSet's Relations collection
ds.Relations.Add(drel);

DataSet’s XML and XSLT transformation [Source XML][XSLT stylesheet]
//XmlDocument to hold XML generated from DataSet
XmlDocument objDoc=new XmlDocument();

//Load XML
objDoc.LoadXml(ds.GetXml());

//Create XslTransform object
XslTransform objXSL=new XslTransform();

//Load XSLT stylesheet
objXSL.Load(Server.MapPath("transformationtemplate.xslt"));

//StringWriter to temporarily hold result of the transformation
StringWriter writer=new StringWriter();

//Apply transformation with no arguments and dump results to StringWriter.
objXSL.Transform(objDoc.CreateNavigator(),null,writer);
Bind TreeView [Result of transformation]

//Set TreeView's TreeNodeSrc property to get XML from StringWriter.
TreeView1.TreeNodeSrc =writer.ToString();

//Bind TreeView
TreeView1.DataBind();

//Close StringWriter
writer.Close();

Länk: http://www.aspalliance.com/joteke/treeviewarticle/article.aspx