CRUD Operation on XML DB in WPF Application


Introduction

In this article we will see how to perform CRUD operation on an XML database in WPF.

Creating WPF Application

Fire up Visual Studio and create a WPF Application, name it as CRUDXmlDbWPF.

We need to design for CRUD operation. I preferred Blend 3 and used Tab Control.

XML Schema in C# Class

Create a class of your xml schema.

   1:  class Movies
   2:  {
   3:  public string Name { get; set; }
   4:  public string Genre { get; set; }
   5:  public string Cast { get; set; }
   6:  public string Year { get; set; }
   7:  }

 

Global Variables

The following are the Global variables I have used.

ObservableCollection<Movies> selectedList = new
ObservableCollection<Movies>();
List<Movies> movieList;
List<string> yearList;

Movies moviesDel;


public Window1()

{

InitializeComponent();

btnUpdate.IsEnabled = false;

btnDelete.IsEnabled = false;

yearList = new
List<string> { “2010”, “2009”, “2008”, “2007”, “2006”, “2005”, “2004”, “2003” };

cmbYear.ItemsSource = yearList;

cmbYearUpdate.ItemsSource = yearList;

LoadData();

}

 

Read Operation

We have an xml file named MovieDB.xml in the root directory. I have created a method to load data from the file.

#region Load Data

void LoadData()
{


XDocument doc = XDocument.Load(@”E:\MovieDB.xml”);

movieList = (from movie in doc.Descendants(“Movie”)


orderby movie.Element(“Name”).Value


select
new
Movies

{

Name = movie.Element(“Name”).Value,

Genre = movie.Element(“Genre”).Value,

Year = movie.Element(“Year”).Value,

Cast = movie.Element(“Cast”).Value,

}).ToList();

lbMovies.ItemsSource = movieList;

ViewDataGrid.ItemsSource = movieList;

}

#endregion

 

Call the method whenever and wherever it is required to Load data.

Create and Update Operation

Create and Update operations are same except that we update an existing data in Update Operation.

So I have created a method called WriteToXml where I am writing to XML file depending on the Create or Update Operation.

#region WriteToXmlFile

void WriteToXmlFile(Movies movies, bool isUpdate)
{

#region Add New


if (!isUpdate)

{


FileStream fs = new
FileStream(@”E:\MovieDB.xml”, FileMode.Open, FileAccess.Read, FileShare.ReadWrite);


XmlDocument xmlDoc = new
XmlDocument();

xmlDoc.Load(fs);

fs.Close();


XmlElement newMovie = xmlDoc.CreateElement(“Movie”);


XmlElement name = xmlDoc.CreateElement(“Name”);

name.InnerText = movies.Name;

newMovie.AppendChild(name);


XmlElement genre = xmlDoc.CreateElement(“Genre”);

genre.InnerText = movies.Genre;

newMovie.AppendChild(genre);


XmlElement year = xmlDoc.CreateElement(“Year”);

year.InnerText = movies.Year;

newMovie.AppendChild(year);


XmlElement cast = xmlDoc.CreateElement(“Cast”);

cast.InnerText = movies.Cast;

newMovie.AppendChild(cast);

xmlDoc.DocumentElement.InsertAfter(newMovie,

xmlDoc.DocumentElement.LastChild);


FileStream fsxml = new
FileStream(@”E:\MovieDB.xml”, FileMode.Truncate,


FileAccess.Write,


FileShare.ReadWrite);

xmlDoc.Save(fsxml);

fsxml.Close();

}

#endregion

#region Update


else

{


XDocument doc = XDocument.Load(@”E:\MovieDB.xml”);


foreach (var item in doc.Descendants(“Movie”))

{


if (item.Element(“Name”).Value == moviesDel.Name)

{

item.Element(“Name”).SetValue(movies.Name);

item.Element(“Genre”).SetValue(movies.Genre);

item.Element(“Year”).SetValue(movies.Year);

item.Element(“Cast”).SetValue(movies.Cast);

doc.Save(@”E:\MovieDB.xml”);


break;

}

}

}

#endregion

}

#endregion

 

On Button Click events of Either Create or Update Operation you can call the above method.

#region Add Operation

private
void btnAdd_Click(object sender, RoutedEventArgs e)
{


string name = txtName.Text.Trim();


string year;


if (cmbYear.SelectedIndex != -1)

{

year = cmbYear.SelectedValue.ToString();

}


else

{

year = “2009”;

}


string genre = txtGenre.Text.Trim();


string cast = txtCast.Text.Trim();


bool isUpdate = false;


if (name.Equals(string.Empty))

name = “Un Named Movie”;


if (year.Equals(string.Empty))

year = “2009”;


if (genre.Equals(string.Empty))

genre = “No Genre”;


if (cast.Equals(string.Empty))

cast = “No Cast”;


Movies newMovie = new
Movies

{

Name = name,

Year = year,

Genre = genre,

Cast = cast,

};

WriteToXmlFile(newMovie, isUpdate);

txtName.Text = string.Empty;

txtGenre.Text = string.Empty;

txtCast.Text = string.Empty;

cmbYear.SelectedIndex = -1;

LoadData();

}

#endregion

#region Update Operation


private
void btnUpdate_Click(object sender, RoutedEventArgs e)

{


if (lbMovies.SelectedIndex != -1)

{


string name = txtNameUpdate.Text;


string year = cmbYearUpdate.SelectedValue.ToString();


string genre = txtGenreUpdate.Text;


string cast = txtCastUpdate.Text;


bool isUpdate = true;


if (name.Equals(string.Empty))

name = “Un Named Movie”;


if (year.Equals(string.Empty))

year = “2009”;


if (genre.Equals(string.Empty))

genre = “No Genre”;


if (cast.Equals(string.Empty))

cast = “No Cast”;


Movies updateMovie = new
Movies

{

Name = name,

Year = year,

Genre = genre,

Cast = cast,

};

WriteToXmlFile(updateMovie, isUpdate);

lbMovies.SelectedIndex = -1;

btnUpdate.IsEnabled = false;

btnDelete.IsEnabled = false;

LoadData();

}

}

#endregion

 

On selection changed of the ListBox perform as below to bind data to the respective fields.

#region ListBox Selection Changed

private
void lbMovies_SelectionChanged(object sender, SelectionChangedEventArgs e)
{

selectedList.Clear();


if (this.lbMovies.SelectedItem is
Movies)

{

selectedList.Add(((Movies)this.lbMovies.SelectedItem));

moviesDel = (Movies)this.lbMovies.SelectedItem;

}


foreach (var item in selectedList)

{

txtNameUpdate.Text = item.Name;

cmbYearUpdate.SelectedValue = item.Year;

txtGenreUpdate.Text = item.Genre;

txtCastUpdate.Text = item.Cast;

}

btnUpdate.IsEnabled = true;

btnDelete.IsEnabled = true;

}

#endregion

 

Delete Operation

On Delete button click event you can add the following code to perform the Delete Operation.

#region Delete Operation

private
void btnDelete_Click(object sender, RoutedEventArgs e)
{


if (moviesDel != null)

{


if (System.Windows.MessageBox.Show(“Do you Really Want To Delete This Movie ?”, “Delete Confirmation”, MessageBoxButton.YesNo) == MessageBoxResult.Yes)

{


XDocument doc = XDocument.Load(@”E:\MovieDB.xml”);


foreach (var item in doc.Descendants(“Movie”))

{


if (item.Element(“Name”).Value == moviesDel.Name)

{

((XElement)item.Element(“Name”)).Parent.Remove();

doc.Save(@”E:\MovieDB.xml”);


break;

}

}

LoadData();

moviesDel = null;

lbMovies.SelectedIndex = -1;

btnDelete.IsEnabled = false;

}


else

{

moviesDel = null;

lbMovies.SelectedIndex = -1;

btnDelete.IsEnabled = false;

}

}

}

#endregion

 

XAML Binding

The following code refers to XAML data binding and control’s properties.

<TabControl Background=”{x:Null}”>
<TabItem Header=”View All”>
<Grid>

<Custom:DataGrid x:Name=”ViewDataGrid” IsReadOnly=”True” GridLinesVisibility=”Horizontal”


AutoGenerateColumns=”False” d:LayoutOverrides=”Width, Height” Background=”{x:Null}”>


<Custom:DataGrid.Columns>


<Custom:DataGridTextColumn Header=”Movie Name” Binding=”{Binding Path=Name}”/>


<Custom:DataGridTextColumn Header=”Year” Binding=”{Binding Path=Year}”/>


<Custom:DataGridTextColumn Header=”Genre” Binding=”{Binding Path=Genre}”/>


<Custom:DataGridTextColumn Header=”Cast” Binding=”{Binding Path=Cast}”/>


</Custom:DataGrid.Columns>

</Custom:DataGrid>

</Grid>

</TabItem>

<TabItem Header=”Add New”>

<Grid>

<Grid.ColumnDefinitions>

<ColumnDefinition Width=”0.217*”/>

<ColumnDefinition Width=”0.783*”/>

</Grid.ColumnDefinitions>

<Grid.RowDefinitions>

<RowDefinition Height=”0.083*”/>

<RowDefinition Height=”0.086*”/>

<RowDefinition Height=”0.147*”/>

<RowDefinition Height=”0.146*”/>

<RowDefinition Height=”0.09*”/>

<RowDefinition Height=”0.095*”/>

<RowDefinition Height=”0.353*”/>

</Grid.RowDefinitions>

<TextBlock HorizontalAlignment=”Right” VerticalAlignment=”Center” Text=”Name :” TextWrapping=”Wrap” Margin=”0,0,5,0″ Grid.Row=”1″/>

<TextBlock HorizontalAlignment=”Right” Margin=”0,0,5,0″ VerticalAlignment=”Center” Text=”Genre :” TextWrapping=”Wrap” Grid.Row=”2″/>

<TextBlock HorizontalAlignment=”Right” Margin=”0,0,5,0″ VerticalAlignment=”Center” Grid.Row=”3″ Text=”Cast :” TextWrapping=”Wrap”/>

<TextBlock HorizontalAlignment=”Right” Margin=”0,0,5,0″ VerticalAlignment=”Center” Text=”Year :” TextWrapping=”Wrap” Grid.Row=”4″/>

<TextBox x:Name=”txtName” Margin=”0,0,5,0″ Grid.Row=”1″ Grid.Column=”1″ VerticalAlignment=”Center” Height=”23″/>

<TextBox x:Name=”txtGenre” Margin=”0,1,5,1″ Grid.Column=”1″ Grid.Row=”2″ TextWrapping=”Wrap” VerticalScrollBarVisibility=”Visible”/>

<TextBox x:Name=”txtCast” Margin=”0,1,5,1″ Grid.Column=”1″ Grid.Row=”3″ TextWrapping=”Wrap” VerticalScrollBarVisibility=”Visible”/>

<ComboBox x:Name=”cmbYear” Margin=”0″ HorizontalAlignment=”Left” Width=”75″ Grid.Column=”1″ Grid.Row=”4″ Height=”20″ VerticalAlignment=”Center”/>

<Button x:Name=”btnAdd” Click=”btnAdd_Click”


HorizontalAlignment=”Left” Margin=”0″ VerticalAlignment=”Center” Width=”100″ Height=”25″ Content=”Add New” Grid.Column=”1″ Grid.Row=”5″/>

</Grid>

</TabItem>

<TabItem Header=”Update”>

<Grid>

<Grid.ColumnDefinitions>

<ColumnDefinition Width=”0.283*”/>

<ColumnDefinition Width=”0.078*”/>

<ColumnDefinition Width=”0.639*”/>

</Grid.ColumnDefinitions>

<Grid.RowDefinitions>

<RowDefinition Height=”0.083*”/>

<RowDefinition Height=”0.086*”/>

<RowDefinition Height=”0.147*”/>

<RowDefinition Height=”0.146*”/>

<RowDefinition Height=”0.09*”/>

<RowDefinition Height=”0.095*”/>

<RowDefinition Height=”0.353*”/>

</Grid.RowDefinitions>

<TextBlock Margin=”5.711,0,5,0″ VerticalAlignment=”Center” Grid.Row=”1″ Text=”Name :” TextWrapping=”Wrap” Grid.Column=”1″ d:LayoutOverrides=”Width”/>

<TextBlock Margin=”4.834,0,5,0″ VerticalAlignment=”Center” Text=”Genre :” TextWrapping=”Wrap” Grid.Row=”2″ Grid.Column=”1″ d:LayoutOverrides=”Width”/>

<TextBlock Margin=”12.884,0,5,0″ VerticalAlignment=”Center” Grid.Row=”3″ Text=”Cast :” TextWrapping=”Wrap” Grid.Column=”1″ d:LayoutOverrides=”Width”/>

<TextBlock Margin=”11.991,0,5,0″ VerticalAlignment=”Center” Text=”Year :” TextWrapping=”Wrap” Grid.Row=”4″ Grid.Column=”1″ d:LayoutOverrides=”Width”/>

<TextBox x:Name=”txtNameUpdate” Margin=”0,0,5,0″ VerticalAlignment=”Center” Height=”23″ Grid.Column=”2″ Grid.Row=”1″/>

<TextBox x:Name=”txtGenreUpdate” Margin=”0,1,5,1″ Grid.Column=”2″ Grid.Row=”2″ TextWrapping=”Wrap” VerticalScrollBarVisibility=”Visible”/>

<TextBox x:Name=”txtCastUpdate” Margin=”0,1,5,1″ Grid.Column=”2″ Grid.Row=”3″ TextWrapping=”Wrap” VerticalScrollBarVisibility=”Visible”/>

<ComboBox x:Name=”cmbYearUpdate” HorizontalAlignment=”Left” Margin=”0″ VerticalAlignment=”Center” Width=”75″ Height=”20″ Grid.Column=”2″ Grid.Row=”4″/>

<Button x:Name=”btnUpdate” Click=”btnUpdate_Click”


HorizontalAlignment=”Left” Margin=”0″ VerticalAlignment=”Center” Width=”100″ Height=”25″ Content=”Update” Grid.Column=”2″ Grid.Row=”5″/>

<Button x:Name=”btnDelete” Click=”btnDelete_Click”


Margin=”108,0,188.819,0″ VerticalAlignment=”Center” Height=”25″ Content=”Delete” Grid.Column=”2″ Grid.Row=”5″ Width=”100″/>


<ListBox x:Name=”lbMovies” SelectionChanged=”lbMovies_SelectionChanged”


Margin=”0,8″ Grid.RowSpan=”7″>


<ListBox.ItemTemplate>


<DataTemplate>


<TextBlock Text=”{Binding Name}”/>


</DataTemplate>


</ListBox.ItemTemplate>


</ListBox>

</Grid>

</TabItem>

</TabControl>

 

That’s it. Run your application and you would achieve the CRUD operation for XML data.