How to use TreeView in XAML and Windows phone application Part 5?

Question

Part 4: Continues

We will read ContactName, Address, City and Country columns in a WPF TreeView control. The finalTreeView looks as in the following: 



Now let's look at our XAML file. We create a resources DataTemplate type called TreeViewTemplate. A data template is used to represent data in a formatted way. The data template has two dock panels where the first panel shows the name and the second panel shows the address, city and country columns by using TextBlock controls. 

1. <Window.Resources>  
       <DataTemplate x:Key="TreeViewTemplate">  
           <StackPanel Margin="3">  
               <DockPanel >  
                   <TextBlock FontWeight="Bold" Text="Name:"  
                     DockPanel.Dock="Left"  
                     Margin="5,0,10,0"/>  
                   <TextBlock Text="  " />  
                   <TextBlock Text="{Binding ContactName}" Foreground="Green" FontWeight="Bold" />  
               </DockPanel>  
               <DockPanel >  
                   <TextBlock FontWeight="Bold" Text="Address:" Foreground ="DarkOrange"   
                     DockPanel.Dock="Left"  
                     Margin="5,0,5,0"/>  
                   <TextBlock Text="{Binding Address}" />  
                    <TextBlock Text=", " />  
                   <TextBlock Text="{Binding City}" />  
                    <TextBlock Text=", " />  
                   <TextBlock Text="{Binding Country}" />  
               </DockPanel>  
           </StackPanel>  
       </DataTemplate>  
   </Window.Resources>   

Now in our code behind, we define the following variables. 

1. public SqlConnection connection;   
   public SqlCommand command;   
   string sql = "SELECT ContactName, Address, City, Country FROM Customers";  
   string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\NORTHWND.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True";  

On the Windows_Loaded method, we use the BindData method. In the BindData method, we create a connection and a data adapter and fill in the DataSet using the SqlDataAdapter.Fill method.

1. private void Window_Loaded(object sender, RoutedEventArgs e)  
   {  
       BindData();             
   }  
     
   private void BindData()  
   {  
       DataSet dtSet = new DataSet();  
       using (connection = new SqlConnection(connectionString))  
       {  
           command = new SqlCommand(sql, connection);                 
           SqlDataAdapter adapter = new SqlDataAdapter();             
           connection.Open();  
           adapter.SelectCommand = command;  
           adapter.Fill(dtSet, "Customers");  
           TreeView1.DataContext = dtSet;          
       }  
   }  

Now let's look at how to bind XML data to a TreeView control. The XmlDataProvider is used to bind XMLdata in WPF. 

1. <XmlDataProvider x:Key="BooksData" XPath="Inventory/Books">  
       <x:XData>  
           <Inventory xmlns="">  
               <Books>  
                   <Book Category="Programming" >  
                       <Title>A Programmer's Guide to ADO.NET</Title>  
                       <Summary>Learn how to write database applications using ADO.NET and C#.  
                       </Summary>  
                       <Author>Mahesh Chand</Author>  
                       <Publisher>APress</Publisher>  
                   </Book>  
                   <Book Category="Programming" >  
                       <Title>Graphics Programming with GDI+</Title>  
                       <Summary>Learn how to write graphics applications using GDI+ and C#.  
                       </Summary>  
                       <Author>Mahesh Chand</Author>  
                       <Publisher>Addison Wesley</Publisher>  
                   </Book>  
                   <Book Category="Programming" >  
                       <Title>Visual C#</Title>  
                       <Summary>Learn how to write C# applications.  
                       </Summary>  
                       <Author>Mike Gold</Author>  
                       <Publisher>APress</Publisher>  
                   </Book>  
                   <Book Category="Programming" >  
                       <Title>Introducing Microsoft .NET</Title>  
                       <Summary>Programming .NET  
                       </Summary>  
                       <Author>Mathew Cochran</Author>  
                       <Publisher>APress</Publisher>  
                   </Book>  
                   <Book Category="Database" >  
                       <Title>DBA Express</Title>  
                       <Summary>DBA's Handbook  
                       </Summary>  
                       <Author>Mahesh Chand</Author>  
                       <Publisher>Microsoft</Publisher>  
                   </Book>  
               </Books>               
           </Inventory>  
       </x:XData>  
   </XmlDataProvider>