Hi,
In the table generated by the codes below, I'd like to
apply filtering across all columns and also be able to see cell values,
e.g. I cannot see value in the Comment column which have many
characters.
Furthermore: the DateTime column only shows date; and when there is a null value for say 'Unit', the table doesn't get rendered.
EconomicCalendar.cs:
namespace SyncfusionWpfDataGridTest
{
public class EconomicCalendar
{
public string? Title { get; set; }
public string? Country { get; set; }
public string? Period { get; set; }
public DateTime DateTime { get; set; }
public string? Indicator { get; set; }
public int Importance { get; set; }
public string? Actual { get; set; }
public string? Previous { get; set; }
public string? Forecast { get; set; }
public string? RawActual { get; set; }
public string? RawPrevious { get; set; }
public string? RawForecast { get; set; }
public string? Ticker { get; set; }
public string? Category { get; set; }
public string? Currency { get; set; }
public string? Unit { get; set; }
public string? Source { get; set; }
public string? SourceUrl { get; set; }
public string? Comment { get; set; }
}
}
ViewModel.cs:
using System.Collections.ObjectModel;
using Npgsql;
namespace SyncfusionWpfDataGridTest
{
public class ViewModel
{
public ObservableCollection<EconomicCalendar> EconomicCalendars { get; set; }
public ViewModel()
{
EconomicCalendars = new ObservableCollection<EconomicCalendar>();
LoadData();
}
private void LoadData()
{
NpgsqlConnection conn = new NpgsqlConnection("Host=192.168.1.2; Port=5432; Database=tradingapp; Username=vorlket; Password=Vcsokr.");
conn.Open();
string query = "SELECT Title, Country, Period, DateTime, Indicator, Importance, Actual, Previous, Forecast, \"Raw Actual\", \"Raw Previous\", \"Raw Forecast\", " +
"Ticker, Category, Currency, Unit, Source, \"Source URL\", Comment FROM EconomicCalendar WHERE Country = 'United Arab Emirates' AND (DateTime >= '2015-01-01' AND " +
"DateTime < '2016-01-01')";
NpgsqlCommand cmd = new NpgsqlCommand(query, conn);
NpgsqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
EconomicCalendars.Add(new EconomicCalendar
{
Title = reader.GetString(0),
Country = reader.GetString(1),
Period = reader.GetString(2),
DateTime = reader.GetDateTime(3),
Indicator = reader.GetString(4),
Importance = reader.GetInt32(5),
Actual = reader.GetString(6),
Previous = reader.GetString(7),
Forecast = reader.GetString(8),
RawActual = reader.GetString(9),
RawPrevious = reader.GetString(10),
RawForecast = reader.GetString(11),
Ticker = reader.GetString(12),
Category = reader.GetString(13),
Currency = reader.GetString(14),
Unit = reader.GetString(15),
Source = reader.GetString(16),
SourceUrl = reader.GetString(17),
Comment = reader.GetString(18)
});
}
}
}
}
MainWindows.xaml:
<Window
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:local="clr-namespace:SyncfusionWpfDataGridTest"
xmlns:syncfusion="http://schemas.syncfusion.com/wpf" x:Class="SyncfusionWpfDataGridTest.MainWindow"
mc:Ignorable="d"
Title="MainWindow" Height="450" Width="800">
<Window.DataContext>
<local:ViewModel/>
</Window.DataContext>
<Grid x:Name="Root_Grid">
<syncfusion:SfDataGrid x:Name="dataGrid" ItemsSource="{Binding EconomicCalendars}">
<syncfusion:SfDataGrid.SortColumnDescriptions>
<syncfusion:SortColumnDescription ColumnName="DateTime"/>
</syncfusion:SfDataGrid.SortColumnDescriptions>
</syncfusion:SfDataGrid>
</Grid>
</Window>
Mainwindow.xaml.cs:
using System.Windows;
namespace SyncfusionWpfDataGridTest
{
/// <summary>
/// Interaction logic for MainWindow.xaml
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}
}
}
