how to add DataGridComboBoxColumn to datagrid in wpf?

[hasan gol]

I'm using a DataSet and DataGrid.

I bind them like this :

 ObjDataAdapter.Fill(ObjDataSet);
 ObjDataGrid.ItemsSource = ObjDataSet.Tables[0].DefaultView;
 

I want to add DataGridComboBoxColumn to ObjDataGrid and show a ComboBox in each row . how can I do that in wpf?

[Aimee Bailey]

In WPF the solution is a little bit more complex, however with a bit of patience you'll find it's wonderful. Here is an example on how to use it...

XAML:

<Window x:Class="WpfApplication1.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:core="clr-namespace:System;assembly=mscorlib"
        xmlns:local="clr-namespace:WpfApplication1"
        Title="MainWindow" Height="350" Width="525" Loaded="Window_Loaded">
 
    <Window.Resources>
        <ObjectDataProvider x:Key="RecordValues" MethodName="GetValues"
                            ObjectType="{x:Type core:Enum}">
            <ObjectDataProvider.MethodParameters>
                <x:Type Type="local:RecordValues"/>
            </ObjectDataProvider.MethodParameters>
        </ObjectDataProvider>
    </Window.Resources>
 
 
    <Grid>
        <DataGrid AutoGenerateColumns="False" ItemsSource="{Binding}"
                  Margin="10" Name="dataGrid1">
            <DataGrid.Columns>
                <DataGridComboBoxColumn Header="Combo" Width="300"
                     SelectedItemBinding="{Binding Values}" 
                     ItemsSource="{Binding Source={StaticResource RecordValues}}" />
            </DataGrid.Columns>
        </DataGrid>
    </Grid>
</Window>
 

Notice that there are a few things here that need attention, first off, a ObjectDataProvider is requried in your XAML to be able to treat an enum in your project as visible to the combo column. There are one or two namespaces here that you will need to use also, such as xmlns:core and xmlns:local.

Once that is done, the rest is fairly simple, notice i created a DataGridComboBoxColumn in the XAML, and have used the binding properties SelectedItemBinding which should be a binding to the data that is to be displayed and changed, and ItemsSource which is a reference to the enum we adapted with the ObjectDataProvider.

Next is the code...

C#:

    public partial class MainWindow : Window
    {
        ObservableCollection<Record> Records = new ObservableCollection<Record>();
 
        public MainWindow()
        {
            InitializeComponent();
        }
 
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            Records.Add(new Record());
            Records.Add(new Record());
            dataGrid1.DataContext = Records;
        }
    }
 
    public enum RecordValues
    {
        Apple,
        Banana,
        Coconut,
        Dambul
    }
 
    public class Record
    {
        private RecordValues _value = RecordValues.Apple;
        public RecordValues value 
        {
           get { return _value; } set { _value = value; } 
        }
    }
 

For the purposes of this answer, it's not sensible to include data retrieved from a database, instead i've opted for a custom class, it's important to note that you must use properties, just having a public variable inside a class is not good enough, and it's just plain good practice. Here you can also see the little enum i created, this can however be collection of strings if you wished.

Lastly, remember to use the DataContext property to fill your grid rather than ItemsSource.

Hope this helps!

Aimee Bailey.

[hasan gol]

Thanks dear Aimee Bailey, your solution was very useful.
I solve this problem like this:

public List<string> comboboxItemsSource { get; set; }
 
private void BtnSetting_Click(object sender, RoutedEventArgs e)
{
comboboxItemsSource = new List<string>() { "A", "B", "C", "D" };
DataGridComboBoxColumn ObjDataGridComboBoxColumn= new DataGridComboBoxColumn();
 
ObjDataGridComboBoxColumn.ItemsSource = comboboxItemsSource;
 
ObjDataGridComboBoxColumn.Header = "zzz";
ObjDataAdapter.Fill(ObjDataSet);
ObjDataGrid.ItemsSource= ObjDataSet.Tables[0].DefaultView;
ObjDataGrid.Columns.Add(ObjDataGridComboBoxColumn);
}

It works very good. But has some problem:
When i add The ObjDataGridComboBoxColumn , ObjDataGrid shows It at first of columns.
When i look at ObjDataGrid[Counter].Columns.Count property it's equal to 1 so I can't use ObjDataGrid[Counter].Columns.Move(); method to move it.
So I decided to follow your guide and use ObjDataGrid.DataContext property.
I find this http://abitsmart.com/tag/wpf-binding...d-to-datatable
and it's solution is this :

Setting the DataContext to the table and then binding ItemsSource to the DataContext
XAML,

<Window x:Class="WpfDemo.Window1"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:dtgrd=
"clr-namespace:Microsoft.Windows.Controls;assembly=WpfToolkit"
    Title="Window1" Height="400" Width="400">
    <Grid  Name="_maingrid">
        <dtgrd:DataGrid
                         x:Name="_dataGrid"
                         ItemsSource="{Binding Path=.}"
                         ColumnHeaderHeight="25"
                         AutoGenerateColumns="True"
                              >
        </dtgrd:DataGrid>
    </Grid>
</Window>

C#Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data;  
 
namespace WpfDemo
{
    /// <summary>
    /// Interaction logic for Window1.xaml
    /// </summary>
    public partial class Window1 : Window
    {
        private DataSet _ds;  
 
        public Window1()
        {
            InitializeComponent();
        }  
 
        protected override void OnInitialized(EventArgs e)
        {
            base.OnInitialized(e);  
 
            ds = new DataSet();
            DataTable dt = new DataTable();
            ds.Tables.Add(dt);  
 
            DataColumn cl = new DataColumn("Col1", typeof(string));
            cl.MaxLength = 100;
            dt.Columns.Add(cl);  
 
            cl = new DataColumn("Col2", typeof(string));
            cl.MaxLength = 100;
            dt.Columns.Add(cl);  
 
            DataRow rw = dt.NewRow();
            dt.Rows.Add(rw);
            rw["Col1"] = "Value1";
            rw["Col2"] = "Value2";  
 
            _datagrid.DataContext = ds.Tables[0];
        }
    }
}

/////////////////////////////////////////////////////////
It works very good. But my problem is that I can't use xaml and I should do all the things in c# code.
How can I do something like ItemsSource="{Binding Path=.}" in c# code?
Excuse me because of my poor English it's not my native language.

[hasan gol]

your solution is ok. how can i show one of my datagridcombobox items at first ?
and when i choose an item from combobox and go to next row combobox shows me nothing. how can i fix that?