WPF datagrid not showing data after binding it to LINQ join query resu

I have a data grid in WPF that is populated from LINQ join query as follows:

When I bind the data grid to this result, data grid is not showing any data:

var source = InboxTrans.GetAllInboxTransactions();

InboxGrid.ItemsSource = source;

This is the definition of the data grid:

"InboxGrid" AutoGenerateColumns="False" CanUserAddRows="False" CanUserResizeColumns="True" DataContext="{Binding}" FlowDirection="RightToLeft" ItemsSource="{Binding}" Margin="5,94,42,218" Grid.ColumnSpan="3" Grid.Column="2">
"{Binding Trans_Number}" Header="??? ??????" IsReadOnly="True" Visibility="Visible" />
"{Binding Trans_Date}" Header="????? ??????" IsReadOnly="True" Visibility="Visible" />
"{Binding Trans_Description}" Header="???? ??????" IsReadOnly="True" Visibility="Visible" />
"{Binding Site_Name}" Header="????? ?????? ?????" IsReadOnly="True" Visibility="Visible" />
"InboxGrid" AutoGenerateColumns="False" CanUserAddRows="False" CanUserResizeColumns="True" DataContext="{Binding}" FlowDirection="RightToLeft" ItemsSource="{Binding}" Margin="5,94,42,218" Grid.ColumnSpan="3" Grid.Column="2">
"{Binding Trans_Number}" Header="??? ??????" IsReadOnly="True" Visibility="Visible" />
"{Binding Trans_Date}" Header="????? ??????" IsReadOnly="True" Visibility="Visible" />
"{Binding Trans_Description}" Header="???? ??????" IsReadOnly="True" Visibility="Visible" />
"{Binding Site_Name}" Header="????? ?????? ?????" IsReadOnly="True" Visibility="Visible" />
"btnDelete" Click="btnDelete_Click" Content="???" />

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
modify your method as below and it should work.
public List GetAllInboxTransactions()
{
try
{
var result =
(from s in this.InboxContext.Inboxes
join st in this.InboxContext.Sites
on s.Trans_Site equals st.Site_Code
select new InboxTransaction
(
s.Trans_Number,
s.Trans_Date,
s.Trans_Description,
st.Site_Description
).ToList();
return (result);
}
catch(Exception e)
{
MessageBox.Show("??? ??? ???");
throw (e);
}
Jignesh Kumar5y ago
Hi, You have to apply. InboxGrid.ItemsSource = source.ToList();