How to Save and Reload the filters DataGrid in Silverlight?

3 mins read

SfDataGrid allows you to save and load the grid settings using the SfDataGrid.Serialize and SfDataGrid.Deserialize methods. You can customize this process by passing SerializationOptions and DeserializationOptions as parameters to these methods. SerializationOptions and DeserializationOptions contains a set of properties that is used to customize the serialization/deserialization process.

You can enable or disable the serialization of filters in SfDataGrid by setting SerializationOptions.SerializeFiltering property as illustrated in the following code example.

Serialization in WPF platform

using System.IO;
private void serialization_Click(object sender, RoutedEventArgs e)
{
    if (SfdataGrid == null) return;
    var serializationOptions = new SerializationOptions()
    {
        SerializeFiltering = true,
    };
    using (var file = File.Create("DataGrid.xml"))
    {
        SfdataGrid.Serialize(file, serializationOptions);
    }
}

Serialization in Silverlight platform

using System.IO.IsolatedStorage;
private void serialization_Click(object sender, RoutedEventArgs e)
{
    if (SfdataGrid == null) return;
    var serializationOptions = new SerializationOptions()
    {
        SerializeFiltering = true,
    };
    using (IsolatedStorageFile ISF = IsolatedStorageFile.GetUserStoreForApplication())
    {
        using (IsolatedStorageFileStream ISFstream = ISF.OpenFile("DataGrid.xml", FileMode.Create))
        {
            SfdataGrid.Serialize(ISFstream, serializationOptions);
        }
    }
}

Serialization in WinRT platform

using Windows.Storage;
private async void serialization_Click(object sender, RoutedEventArgs e)
{
    var folder = KnownFolders.DocumentsLibrary;
    var storageFile = await folder.CreateFileAsync("DataGrid.xml", CreationCollisionOption.ReplaceExisting);
    var options = new SerializationOptions() 
    { 
        SerializeFiltering=true,
    };
    options.SerializeFiltering = true;
    this.SfdataGrid.Serialize(storageFile, options);
}

In the same way, you can enable or disable deserialization of serialized filters to SfDataGrid by setting DeserializationOptions.DeserializeFiltering property as illustrated in the following code example.

Deserialization in WPF platform

using System.IO;
private void Deserialization_Click(object sender, RoutedEventArgs e)
{
    if (SfdataGrid == null) return;
    var deserializationOptions = new DeserializationOptions()
    {
        DeserializeFiltering = true,
    };
    using (var file = File.Open("DataGrid.xml", FileMode.Open))
    {
        if (deserializationOptions.DeserializeFiltering == true)
        {
            SfdataGrid.Deserialize(file, deserializationOptions);
        }
    }
}

Deserialization in Silverlight platform

using System.IO.IsolatedStorage;
private void Deserialization_Click(object sender, RoutedEventArgs e)
{
    if (SfdataGrid == null) return;
    var deserializationOptions = new DeserializationOptions()
    {
        DeserializeFiltering = true,
    };
    using (IsolatedStorageFile ISF = IsolatedStorageFile.GetUserStoreForApplication())
    {
        using (IsolatedStorageFileStream ISFstream = ISF.OpenFile("DataGrid.xml", FileMode.Open))
        {
            SfdataGrid.Deserialize(ISFstream, deserializationOptions);
        }
    }
}

Deserialization in WinRT platform

using Windows.Storage;
private async void Deserialization_Click(object sender, RoutedEventArgs e)
{
    var folder = KnownFolders.DocumentsLibrary;
    var storageFile = await folder.GetFileAsync("DataGrid.xml");
    var options = new DeserializationOptions() 
    { 
        DeserializeFiltering=true,
    };
    options.DeserializeFiltering = true;
    this.SfdataGrid.Deserialize(storageFile, options);
}

Did you find this information helpful?

Yes

Comments (0)

How to Save and Reload the filters DataGrid in Silverlight?

Access denied