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

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");
}

private void RBStudName_Checked(object sender, RoutedEventArgs e)
{
BindDataTreeView("StudName");
}
}
}

See the Output In the Images Below:

In the same way depending on the selected radio button it will display the values into the Treeview: