How to set target null value for a column in SfDataGrid?

Question

Hello, I'd like to ask if there is a way to set TargetNullValue for a column in SfDataGrid. Currently, if a property of an object model is null or empty then the whole column will be blank. Can I set the character "-" to replace the empty field? Thank you.

Suja Venkatesan · Accepted Answer

Hi Josh,We would like to let you know that you can achieve your requirement
by setting DisplayBinding for the columns in GridLoaded event as like below code
snippet.Code Snippet:XAML:

<sfgrid:SfDataGrid x:Name="sfGrid" 
                     AllowSorting="True"
                     GridLoaded="sfGrid_GridLoaded"
                     ItemsSource="{Binding OrdersInfo}">

C#:

public partial class DataGridPage : ContentPage
  {
    public DataGridPage()
    {
      InitializeComponent();
    }
    private void
  sfGrid_GridLoaded(object sender, GridLoadedEventArgs e)
    {
      var columns = (sender as SfDataGrid).Columns;
      foreach(var col in
  columns)
      {
        col.DisplayBinding= new Binding(col.MappingName,
  BindingMode.OneWay, new CustomConverter());
      }
    }
  }
   
  public class CustomConverter : IValueConverter
  {
     public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
     {
      if(value ==null)
      {
        return "-";
      }
      return value;
     }
   
     public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
     {
       return value;
     }
  }

We have attached a sample based on your requirements. Please
let us know if you need any further assistance.Regards,Suja.Attachment: GettingStarted_8152483c.zip