List<T> to datatable returns empty - WPF

本文关键字：returns empty datatable WPF gt lt List to | 更新日期: 2023-09-27 18:18:35

我使用下面的代码从List<double[]> list填充datatable但是数据表没有被填充。

private void LoadThis(object sender, EventArgs e)
        {
            X model = DataContext as X;
            List<double[]> list = new List<double[]>();
            for (int i = 0; i < model.RowFijtable; i++)
            {
                double[] rowdata = new double[model.ColFijtable];
                for (int j = 0; j < model.ColFijtable; j++)
                {
                    rowdata[j] = model.TauTable[i, j];
                }
                list.Add(rowdata);
            }
            DataTable table = ConvertListToDataTable(list);
            dataGridView1.ItemsSource = table.AsDataView(); //Is this correct?
}
  private DataTable ConvertListToDataTable(List<double[]> list)
    {
        DataTable table = new DataTable();
        // Get max columns.
        int columns = 0;
        foreach (var array in list)
        {
            if (array.Length > columns)
            {
                columns = array.Length;
            }
        }
        // Add columns.
        for (int i = 0; i < columns; i++)
        {
            table.Columns.Add();
        }
        // Add rows.
        foreach (var array in list)
        {
            table.Rows.Add(array);
        }
        return table;
    }

这就是我如何将信息放在XAML 

<Grid>
    <DataGrid HorizontalAlignment="Stretch"
     VerticalAlignment="Stretch"
     Name="dataGridView1"
     Loaded="LoadThis"
     ItemsSource="{Binding}"
     AutoGenerateColumns="True"/>
</Grid>

我可以看到，列和行的数量被正确地传递到数据表，但没有数据值，即使列表有完整的数据集!

我也尝试做dataGridView1.DataSource = table;，但这使我的错误为"数据网格不包含数据源的定义"..

List<T> to datatable returns empty - WPF

调用table.Rows.Add(array)似乎将整个数组放入第一列值。要将数组元素放入连续的列中，请尝试这样做:

    private DataTable ConvertListToDataTable(List<double[]> list)
    {
        DataTable table = new DataTable();
        // Get max columns.
        int columns = 0;
        foreach (var array in list)
        {
            if (array.Length > columns)
            {
                columns = array.Length;
            }
        }
        // Add columns.
        for (int i = 0; i < columns; i++)
        {
            // Provide default column name & data type
            table.Columns.Add("Column" + (i+1).ToString(), typeof(double) );
        }
        // Add rows.
        foreach (var array in list)
        {
            // assign each array element to the appropriate column
            var row = table.NewRow();
            for (int i = 0; i < array.Length; ++i )
                row.SetField( i, array[i] );
            table.Rows.Add(row);
        }
        return table;
    }
相关文章：