如何显示，选择在DataGrid中的项目组合框与WPF C＃，使用MVVM [英] How to Display and select items in a Datagrid ComboBox with WPF C#, using MVVM

问题描述

我希望能够选择任何一种真或假从ComboBox这是一个WPF Datagrid的内能这样的选择保存到我的数据库（布尔）。

I want to be able to choose either "true" or "false"(boolean) from a ComboBox that is within a wpf Datagrid and be able to save that choice to my database.

我希望能够一栏里面，表示该行是有效或不通过保存到我的数据库作为一个位（1 =真; 0 =假）的布尔变量。

I want to be able to indicate inside of a column if the row is "Active" or not through a boolean variable saved to my database as a bit(1 = true; 0 = false).

下面是我创建表的语句：
CREATE TABLE语句（ACCOUNTTYPE）

Here is my create table statement: Create Table Statement(AccountType)

我用填充一个ObservableCollection数据网格如下：

I populate the datagrid using an ObservableCollection as follows:

protected override void Get()
{
    using (var dbContext = new IEMASEntitiesDataContext())
    {
        var accountType = from s in dbContext.AccountTypes select s;
        var observable = new  ObservableCollection<AccountType>(accountType);

        Collection = observable;
    }
}

我的XAML代码如下：

My XAML code is as follows:

<DockPanel DataContext="{StaticResource ResourceKey=AccountTypeViewModel}" LastChildFill="True">
    <ToolBar DockPanel.Dock="Top">
        <Button Content="Display"  Command="{Binding GetCommand}" Width="78"/>
        <Button Content="Save" Command="{Binding SaveCommand}" Width="78"/>
    </ToolBar>

    <Grid>
        <GroupBox x:Name="AccountTypeGroupBox">
            <DataGrid x:Name="DataGridAccountType" ItemsSource="{Binding Collection}" AutoGenerateColumns="False">
                <DataGrid.Columns>
                    <DataGridTextColumn  Header="AccountType" Width="150" Binding="{Binding Path=AccountTypeName, Mode=TwoWay, NotifyOnSourceUpdated=True, UpdateSourceTrigger=PropertyChanged}"/>
                    <DataGridComboBoxColumn  Header="Active" Width="100" SelectedValueBinding="{Binding StatusList, UpdateSourceTrigger=PropertyChanged}" SelectedValuePath="AccountTypeId" DisplayMemberPath="Active"/>                   
                    <DataGridTemplateColumn Width="50" Header="Delete">
                        <DataGridTemplateColumn.CellTemplate>
                            <DataTemplate>
                                <Button x:Name="btnDelete" Content="Delete" Command="{Binding DeleteCommand}"/>
                            </DataTemplate>
                        </DataGridTemplateColumn.CellTemplate>
                    </DataGridTemplateColumn>
                </DataGrid.Columns>
            </DataGrid>
        </GroupBox>          
    </Grid>
</DockPanel>

这是行不通的。不显示任何组合框之内，我不知道如何选择的项目保存到SQL Server数据库时，它显示。我会很感激一些帮助，请。我使用LINQ to SQL的。我是新手： - （

It doesn't work. Nothing displays within the comboboxes, and I don't know how to save the selected item to the SQL Server database when it does display. I'd appreciate some help, please. I am using LINQ TO SQL. I am a newbie :-(.

推荐答案

据我可以理解，问题是如何在一定XAML资源绑定为一个组合的ItemsSource在addtion如何组合的选定值binnd的DataGrid行背后的模型
1.列表项：

As I can understand the problem is how to bind some XAML resource as a combo ItemsSource and in addtion how to binnd the selected value of a combo to the model behind the DataGrid row. 1. List item:

<Window x:Class="SoDataGridProjectsHelpAttempt.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:soDataGridProjectsHelpAttempt="clr-namespace:SoDataGridProjectsHelpAttempt"
    xmlns:system="clr-namespace:System;assembly=mscorlib"
    Title="MainWindow" Height="350" Width="525">
<Window.Resources>
    <x:Array x:Key="CountriesArray" Type="soDataGridProjectsHelpAttempt:Country">
        <soDataGridProjectsHelpAttempt:Country CountryName="Germany" CountryPop="150k"/>
        <soDataGridProjectsHelpAttempt:Country CountryName="France" CountryPop="125k"/>
        <soDataGridProjectsHelpAttempt:Country CountryName="Belarus" CountryPop="165k"/>
    </x:Array>
    <x:Array x:Key="StatusArray" Type="soDataGridProjectsHelpAttempt:ActivityStatus">
        <soDataGridProjectsHelpAttempt:ActivityStatus VerbalStatus="Yes" BoolStatus="True"/>
        <soDataGridProjectsHelpAttempt:ActivityStatus VerbalStatus="No" BoolStatus="False"/>
    </x:Array>
</Window.Resources>
<Window.DataContext>
    <soDataGridProjectsHelpAttempt:DataGridMainDataContext/>
</Window.DataContext>
<Grid>
    <DataGrid ItemsSource="{Binding Collection}" AutoGenerateColumns="False" CanUserAddRows="True">
        <DataGrid.Columns>
            <DataGridTextColumn     Width="Auto" Binding="{Binding UName}"/>
            <DataGridComboBoxColumn Header="Country" DisplayMemberPath="CountryName"
                                    ItemsSource="{StaticResource CountriesArray}" Width="Auto"
                                    SelectedItemBinding="{Binding CountryData}"/>
            <!--<DataGridComboBoxColumn Header="ActivityStatus" Width="Auto" ItemsSource="{StaticResource StatusArray}" 
                                    SelectedValueBinding="{Binding IsActive}" SelectedValuePath="BoolStatus" DisplayMemberPath="VerbalStatus"/>-->
            <DataGridComboBoxColumn Header="ActivityStatus" SelectedItemBinding="{Binding IsActive, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}">
                <DataGridComboBoxColumn.ItemsSource>
                    <x:Array Type="system:Boolean">
                        <system:Boolean>True</system:Boolean>
                        <system:Boolean>False</system:Boolean>
                    </x:Array>
                </DataGridComboBoxColumn.ItemsSource>
            </DataGridComboBoxColumn>
        </DataGrid.Columns>
    </DataGrid>
</Grid>

1. 数据网格视图模型：

1. DataGrid viewmodel:

public class DataGridMainDataContext

{
公共DataGridMainDataContext（）
{
系列=新的ObservableCollection（新表
{
新的UserData
{
的uname =格雷格，
IsActive =假，
}，
新的UserData
{
的uname = 乔，
IsActive =假，
}，
新的UserData
{
的uname =IV，
IsActive =假，
}
}）;

{ public DataGridMainDataContext() { Collection = new ObservableCollection(new List { new UserData { UName = "Greg", IsActive = false, }, new UserData { UName = "Joe", IsActive = false, }, new UserData { UName = "Iv", IsActive = false, } });

}

public ObservableCollection<UserData> Collection { get; set; }

}

}

模型：
公共类的UserData：BaseObservableObject
{
私人字符串_uName;
私有对象_countryData;
私人布尔_isActive;

Models: public class UserData : BaseObservableObject { private string _uName; private object _countryData; private bool _isActive;

public bool IsActive
{
    get { return _isActive; }
    set
    {
        _isActive = value;
        OnPropertyChanged();
    }
}

public string UName
{
    get { return _uName; }
    set
    {
        _uName = value;
        OnPropertyChanged();
    }
}

public object CountryData
{
    get { return _countryData; }
    set
    {
        _countryData = value;
        OnPropertyChanged();
    }
}

}

}

公共类ActivityStatus：BaseObservableObject
{
私人布尔_boolStatus;
私人字符串_verbalStatus;

public class ActivityStatus:BaseObservableObject { private bool _boolStatus; private string _verbalStatus;

public bool BoolStatus
{
    get { return _boolStatus; }
    set
    {
        _boolStatus = value;
        OnPropertyChanged();
    }
}

public string VerbalStatus
{
    get { return _verbalStatus; }
    set
    {
        _verbalStatus = value;
        OnPropertyChanged();
    }
}

}

}

公共类国家：BaseObservableObject
{
私人字符串_countryName;
私人字符串_countryPop;

public class Country : BaseObservableObject { private string _countryName; private string _countryPop;

public string CountryName
{
    get { return _countryName; }
    set
    {
        _countryName = value;
        OnPropertyChanged();
    }
}

public string CountryPop
{
    get { return _countryPop; }
    set
    {
        _countryPop = value;
        OnPropertyChanged();
    }
}

public Country() { }
public Country(string n, string d)
{
    this.CountryName = n;
    this.CountryPop = d;
}

}
希望它会帮助你。

} Hope it will help you.

问候，

这篇关于如何显示，选择在DataGrid中的项目组合框与WPF C＃，使用MVVM的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！