TreeView width ASP.NET V2 – Whidbey [20 mn de lecture - paru le 11/17/2004 3:27:26 PM - Public : Débutant]

Auteur

Michel DEGREMONT Elève-Ingénieur Supinfo Paris Promotion SUPINFO 2006    Lui écrire    Tous les projets de cet auteur    Le mini-CV de cet auteur

5. TreeView and data source DataSet

5.1. To fill DataSet

We have two tables. LuxuryCarVehicule which contact characteristics of the vehicle of which the Model field. And in our second luxuryCarMarque table which contact the mark of different conveys. These two tables are réliées between them by the key marqueID.

The TreeViewDataSet() method goes seeks the data in my data base SQLserver.

DataSet TreeViewDataSet() {     SqlConnection myConnection = new SqlConnection(ConfigurationSettings.ConnectionStrings["AppConnectionStringCars"].ConnectionString);         SqlDataAdapter dbLuxuryCarMarque = new SqlDataAdapter("SELECT dbo.luxuryCarMarque.marqueID ,dbo.luxuryCarMarque.marque FROM dbo.luxuryCarMarque WHERE (marqueID IN (SELECT dbo.luxuryCarVehicule.marqueID FROM dbo.luxuryCarVehicule GROUP BY dbo.luxuryCarVehicule.marqueID)) GROUP BY dbo.luxuryCarMarque.marque,dbo.luxuryCarMarque.marqueID ORDER BY dbo.luxuryCarMarque.marque ", myConnection);       SqlDataAdapter dblLuxuryCarVehicule = new SqlDataAdapter("SELECT marqueID, model FROM luxuryCarVehicule", myConnection);          DataSet dst = new DataSet(); dbLuxuryCarMarque.Fill(dst, "Marque");      dblLuxuryCarVehicule.Fill(dst, "Vehicule");      dst.Relations.Add("Children", dst.Tables["Marque"].Columns["marqueID"],dst.Tables["Vehicule"].Columns["marqueID"]);     return dst; }

5.2. Creating TreeView Node 

The method void vehiculeNodes() goes contruire TreeView and its nodes.
The node child, represents the models of each Mark. The marks correspond to the main nodes.

The nodes children redirect on a URL.

To slip TreeView into the zone Design. You can now compile.