WPF - Add Treeview Items Depending On The Field From Database At Runtime

Ghanashyam Nayak
12y
17.3k
0
0
100
Article

This article is related to my previous article which you can see by "Click Here".

In this article we will see how you can use the TreeView & how to add new items at runtime into TreeView from the
database. Here I have taken three radio buttons & they are in a group which means you can select only one radio button
at a time and the three buttons are used for adding values into the TreeView. Depending on the selected radio button it
will add that value into the TreeView at runtime from the database.

MainWindow.xaml Code :

In the above code for the RadioButton you must set the GroupName so It will allow select only one radio button at a one time and for that you must provide the same name for all three radio buttons.

public void BindDataTreeView(string field)
{
            try
            {
                MyTreeView.Items.Clear();
                conn.Open();
                SqlCommand comm = new SqlCommand("SELECT " + field + " FROM Student", conn);
                dr = comm.ExecuteReader();
                while (dr.Read())
                {
                    MyTreeView.Items.Add(dr.GetValue(0).ToString());
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
            finally
            {
                conn.Close();
            }
}

The above function will store the values of the given field into the TreeView from the database at runtime.

One more thing to keep in mind is that before adding new items you must clear your TreeView otherwise it will append the new items into TreeView everytime.

private void RBStudId_Checked(object sender, RoutedEventArgs e)
{
BindDataTreeView("StudId");
}

In the above code it will call the function which will store the values into the TreeView from the database at runtime and in that function when you call it you must pass the argument as a field name which you want to display into the TreeView from the database.

Here on the "Student Id" radio button it will call the function & pass the field name as "StudId", so it will add student id into the TreeView from the database.

Main Code :

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data.SqlClient;
using System.Data;

namespace WPFAllDatabaseOperationApplication
{
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>

    public partial class MainWindow : Window
    {
        SqlConnection conn = new SqlConnection(@"Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDatabase.mdf;Integrated Security=True;User Instance=True");
        SqlDataReader dr;

public MainWindow()
        {
            InitializeComponent();
        }

/// <summary>
        /// Bind the Values into Treeview
        /// </summary>
        /// <param name="field">Pass Feildname from the database to display in treeview</param>
        public void BindDataTreeView(string field)
        {
            try
            {
                MyTreeView.Items.Clear();
                conn.Open();
                SqlCommand comm = new SqlCommand("SELECT " + field + " FROM Student", conn);
                dr = comm.ExecuteReader();
                while (dr.Read())
               {
                    MyTreeView.Items.Add(dr.GetValue(0).ToString());
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
            finally
            {
                conn.Close();
            }
        }

        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            BindMyData();
            //Here by default it will display Student Name when window will be loaded...
            BindDataTreeView("StudName");
        }

       private void RBStudId_Checked(object sender, RoutedEventArgs e)
       {
           BindDataTreeView("StudId");
       }

       private void RBStudResult_Checked(object sender, RoutedEventArgs e)
       {
           BindDataTreeView("StudResult");
       }