Hello,
I have a datatable like this:
property
private DataTable amortable;
public DataTable Amortable
{
get => amortable;
set => SetProperty(ref amortable, value);
}insert data into datatable
//create datatable and add column Amortable = new DataTable(); Amortable.Columns.Add("Terms", typeof(int)); Amortable.Columns.Add("Principal", typeof(double)); Amortable.Columns.Add("Interest", typeof(double)); Amortable.Columns.Add("Payment", typeof(double)); Amortable.Columns.Add("Balance", typeof(double)); //add row for (int i = 0; i < Convert.ToInt32(off.Terms)*12; i++) { DataRow row = Amortable.NewRow(); row["Balance"] = Convert.ToDouble(off.LoanAmt); row["Terms"] = i+1; row["Payment"] = Convert.ToDouble(off.Payment); row["Interest"] = Convert.ToDouble(off.APR) / 12 / 100 * Convert.ToDouble(row["Balance"]); row["Principal"] = Convert.ToDouble(row["Payment"]) - Convert.ToDouble(row["Interest"]); if (i > 0) { row["Balance"] = Convert.ToDouble(row["Balance"]) - Convert.ToDouble(row["Principal"]); } Amortable.Rows.Add(row);
datagrid(in XAML)
<DataGrid x:Name="AmortizTable" ItemsSource="{Binding Amortable}" Grid.Row="1"> <DataGrid.Resources> <Style TargetType="DataGridCell"> <Setter Property="HorizontalAlignment" Value="Right"/> <Setter Property="HorizontalContentAlignment" Value="Right"/> <Setter Property="Width" Value="90"/> </Style> <Style TargetType="DataGridColumnHeader"> <Setter Property="HorizontalContentAlignment" Value="Center"/> <Setter Property="HorizontalAlignment" Value="Center"/> <Setter Property="Width" Value="90"/> </Style> </DataGrid.Resources> <DataGrid.Columns> <DataGridTextColumn Header="Term" IsReadOnly="True"/> <DataGridTextColumn Header="Principal" IsReadOnly="True"/> <DataGridTextColumn Header="Interest" IsReadOnly="True"/> <DataGridTextColumn Header="Payment" IsReadOnly="True" /> <DataGridTextColumn Header="Balance" IsReadOnly="True" /> </DataGrid.Columns> </DataGrid>
after running above code, I couldn't see data in datagrid.
if someone pick my mistake in this code, I would be very appreciated.
thanks,
c00012