向listviewwpf添加动态创建的列和行

本文关键字：创建 listviewwpf 添加 动态 | 更新日期: 2023-09-27 18:12:41

我试图添加动态列和动态行到列表视图。我只是不明白为什么在wpf中这么难做到。故事如下，我让用户从SQL数据库中选择一些表，例如Table: PgPoints和PgValuesDouble。所以listview应该显示它的列标题为PgPoints和PgValuesDouble。

接下来，从SQLDatabase中根据所选表(PgPoints和PgValuesDouble)的名称抓取数据。该数据作为List返回。

我现在有以下c#代码:

  public partial class Page3 : Page
{
    private List<string> columns = new List<string>();
    /*Variables passed through constructor*/
    private dbConnection connection;
    private List<string> selectedTables;

    public Page3(dbConnection connection, List<string> selectedTables)
    {
        InitializeComponent();
        this.connection = connection;
        this.selectedTables = selectedTables;
        init();
    }
    private void init()
    {
        gridView.Columns.Clear();
        //Loop through selected tables and add them as column names to listview
        foreach(string selectedTableNames in selectedTables)
        {
            GridViewColumn clm = new GridViewColumn();
            clm.Header = selectedTableNames;
            clm.Width = 100;
            gridView.Columns.Add(clm);
            //Loop through the data grabbed from the SQL database
            foreach (string columNames in connection.GetColumnsList(selectedTableNames))
            {
                columnListView.Items.Add(columNames);
            }
        }
    }
    private void button_Click(object sender, RoutedEventArgs e)
    {
        Button b = (Button)sender;
        if (b.Equals(button_back))
        {
            NavigationService.GoBack();
        }
        else
        {
            //Go forward event here!
        }
    }
}
XAML:

和

<Page x:Class="HCCSVExport.Pages.Page3"
  xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
  xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
  xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" 
  xmlns:d="http://schemas.microsoft.com/expression/blend/2008" 
  xmlns:local="clr-namespace:HCCSVExport.Pages"
  mc:Ignorable="d" 
  d:DesignHeight="300" d:DesignWidth="300"
  Title="Page3" MinWidth="519" MinHeight="321">
<Grid x:Name="grid" Background="White">
    <Button x:Name="button_next" Content="volgende" Margin="0,0,10,10" VerticalAlignment="Bottom" Click="button_Click" HorizontalAlignment="Right" Width="86.493"/>
    <Button x:Name="button_back" Content="vorige" Margin="0,0,101,10" VerticalAlignment="Bottom" Click="button_Click" HorizontalAlignment="Right" Width="89" Uid="button_back"/>
    <Label x:Name="label" Content="Selecteer de kolommen uit de tabellen" Margin="10,10,10,0" VerticalAlignment="Top" FontSize="16" HorizontalContentAlignment="Center"/>
    <ListView x:Name="columnListView" HorizontalAlignment="Left" Height="240" Margin="10,46,0,0" VerticalAlignment="Top" Width="499">
        <ListView.View>
            <GridView x:Name="gridView"/>
        </ListView.View>
    </ListView>
</Grid>

结果是从SQL数据库中抓取的所有数据都放在两个列中。我怎么能得到属于PgPoints列下的PgPoints列的数据和属于PgValuesDouble列下的PgValuesDouble列的数据?

截图

正如你所看到的，两列中的单元格是相同的，而不是每列不同的单元格…

编辑:

所以我已经改变到一个数据网格似乎工作。但是我真的想要一个ListView来完成这项工作:(我只是不明白为什么在wpf中这么难做到这一点有点令人沮丧....

public partial class Page3 : Page
{
    /*Variables passed through constructor*/
    private dbConnection connection;
    private List<string> selectedTables;
    public Page3(dbConnection connection, List<string> selectedTables)
    {
        InitializeComponent();
        this.connection = connection;
        this.selectedTables = selectedTables;
        init();
    }
    private void init()
    {
        dataGrid.ItemsSource = createDataTable().DefaultView;
    }
    private DataTable createDataTable()
    {
        DataTable dt = new DataTable();
        bool first = true;
        foreach (string selectedTableNames in selectedTables)
        {
            dt.Columns.Add(new DataColumn(selectedTableNames));
            List<string> tmpList = connection.GetColumnsList(selectedTableNames);
            for (int x = 0; x < tmpList.Count; x++)
            {
                if (first)
                {
                    DataRow row = dt.NewRow();
                    row[selectedTableNames] = tmpList[x];
                    dt.Rows.Add(row);
                }
                else
                {
                    DataRow row = dt.Rows[x];
                    if (row != null)
                    {
                        row[selectedTableNames] = tmpList[x];
                    }
                    else
                    {
                        row = dt.NewRow();
                        row[selectedTableNames] = tmpList[x];
                        dt.Rows.Add(row);
                    }

                }
                dt.AcceptChanges();
            }
            first = false;
            dt.AcceptChanges();

        }
        dt.AcceptChanges();
        return dt;
    }
    private void button_Click(object sender, RoutedEventArgs e)
    {
        Button b = (Button)sender;
        if (b.Equals(button_back))
        {
            NavigationService.GoBack();
        }
        else
        {
            //Go forward event here!
        }
    }
}

和XAML:

<Page x:Class="HCCSVExport.Pages.Page3"
  xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
  xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
  xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" 
  xmlns:d="http://schemas.microsoft.com/expression/blend/2008" 
  xmlns:local="clr-namespace:HCCSVExport.Pages"
  mc:Ignorable="d" 
  d:DesignHeight="300" d:DesignWidth="300"
  Title="Page3" MinWidth="519" MinHeight="321">
<Grid x:Name="grid" Background="White">
    <Button x:Name="button_next" Content="volgende" Margin="0,0,10,10" VerticalAlignment="Bottom" Click="button_Click" HorizontalAlignment="Right" Width="86.493"/>
    <Button x:Name="button_back" Content="vorige" Margin="0,0,101,10" VerticalAlignment="Bottom" Click="button_Click" HorizontalAlignment="Right" Width="89" Uid="button_back"/>
    <Label x:Name="label" Content="Selecteer de kolommen uit de tabellen" Margin="10,10,10,0" VerticalAlignment="Top" FontSize="16" HorizontalContentAlignment="Center"/>
    <DataGrid x:Name="dataGrid" HorizontalAlignment="Left" Margin="10,46,0,0" VerticalAlignment="Top" Width="499" Height="240"/>
</Grid>

向listviewwpf添加动态创建的列和行

也许这可以帮助，我使用的是DataGrid而不是ListView:

在ViewModel中，我使用了一个数据表:

DataTable dt = new DataTable();
DataColumn timeStamp = new DataColumn();
timeStamp.ColumnName = "TimeStamp";
dt.Columns.Add(timeStamp);
//ading a new row
DataRow row = dt.NewRow();

并填充:

row[timeStamp] = "100.2";

等，您添加了许多列和它们的特定值。

每列计数更改后:

LogTable.Clear();
LogTable = null;
LogTable = dt;

优雅与否，它对我来说工作得很好，甚至当我动态添加超过20列时，也没有出现任何故障。

 <DataGrid x:Name="logDataGrid"
           AutoGenerateColumns="True"
           ItemsSource="{Binding LogTable, Mode=TwoWay}"/>

我曾经见过一个用ObservableCollection代替DataTable的例子，但那只是一堆花哨的代码。

相关文章：