带有组合框的数据网格 [英] datagrid with combobox

问题描述

大家好，我在使用内置的combobox解决我的数据网格视图时遇到问题。

任何人都可以解决这个问题。



问题：

我有一个datagrid来查看具有特定列的数据库，在Map Table列中我创建了一个组合框，因为Value是legacyclient_maptable_name列中Table的列名在datagrid中。我想告诉主要的事情，datagrid列中的legacyclient_maptable_name是其他数据库中Table的名称。

实际上我只得到了我的Combobox列表中最后一行的列表。我想要的是，根据legacyclient_maptable_name列中的数据，组合框列表是动态的。



感谢您的帮助。

问候，





文件：[ABC.cs]

Hello master, I have a problem in solving on my datagrid view with combobox inside it.
Can anyone solve this problem.

The Problem:
I have a datagrid to view a database with a specific column, in column "Map Table" I created a combobox as the Value are the column name of Table from the column "legacyclient_maptable_name" in datagrid. I want to tell the main thing that inside the datagrid column "legacyclient_maptable_name" are the name of Table in other database.
As in fact I got only the list of last row in my Combobox List. What I want is that the list of combobox is dynamic according the data in column "legacyclient_maptable_name".

Thank for the help.
Regards,


File: [ABC.cs]

//###NEW
                dboperation.open_connection("True");
                DTItems = GetAllItems();
                dataGrid1.ItemsSource = DTItems.DefaultView;
                //###NEW
               
                
                foreach (DataRow row in DTItems.Rows)
                {
                    
                    //foreach (var item in row.ItemArray)
                    //{
                    //    MessageBox.Show("data: " + item.ToString());
                    //MessageBox.Show("data: " + row["legacyclient_maptable_name"]);
                    
                    //##DatagridComboBoxColumn###
                        string qGetDM = "SELECT * FROM " + row["legacyclient_maptable_name"]; //basel_f11_normal
                    //## Get ColumnName from datamart database table
                    //MessageBox.Show(qGetDM);
                        List<string> MapColumn = dboperation.columnNames(qGetDM, "clientLegacyDM");
                        MapColumns = MapColumn;
                        dtcmbTes.ItemsSource = MapColumns;
                    //##DatagridComboBoxColumn###
                    //}
                    
                }

< br $>
文件：[ABC.xaml]

file:[ABC.xaml]

<DataGrid AutoGenerateColumns="False" HorizontalAlignment="Left" Margin="12,123,0,176" Name="dataGrid1" Width="1000"

                  ItemsSource="{Binding Path=.,Mode=TwoWay}" SelectionUnit="Cell" CanUserAddRows="False" PreparingCellForEdit="dataGrid1_PreparingCellForEdit">
           
            <DataGrid.Columns>
                <DataGridTextColumn Binding="{Binding parent_id}" Header="Parent ID" />
                <DataGridTextColumn Binding="{Binding report_code}" Header="Report Code" />
                <DataGridTextColumn Binding="{Binding fieldname}" Header="Field Name" />
                <DataGridTextColumn Binding="{Binding fieldlength}" Header="Field Length" />
                <DataGridTextColumn Binding="{Binding xbrlxmltagmapping}" Header="Xbrl Tag Map" />
                <DataGridTextColumn Binding="{Binding mapfield_supportsystem}" Header="mapfield_supportsystem" />
                <!-- MAP TABLE-->

                <DataGridComboBoxColumn x:Name="dtcmbTes"

                                 Header="Map Table" Width="200"

                                 SelectedItemBinding="{Binding mapfield_supportsystem}"

                                 >
                <!-- ItemsSource="{Binding Path=MapColumns}"
                                 SelectedItemBinding="{Binding mapfield_supportsystem}"-->
                </DataGridComboBoxColumn>
                <DataGridTextColumn x:Name="column1" Binding="{Binding legacyclient_maptable_name}" Header="legacyclient_maptable_name" Visibility="Hidden"/>

            </DataGrid.Columns>
            
        </DataGrid>

数据库模型< br $>


表_主要结构：



| autoid ||父ID || Map Table || legacyclient_maptable_name * |

| 0 || 1 || BlnLaporan || basel_f01 |

| 1 || 2 || UserId || basel_f11_normal |



表basel_f01结构



| autoid || BlnLaporan || BlnLaporan2 || BlnLaporan3 |

| 0 || 1 || 1200 || 22 |

| 1 || 2 || 12 || 12 |



表basel_f11_normal结构



| autoid || UserId || UserId2 || UserId3 |

| 0 || 1 || 1500 || 62 |

| 1 || 2 || 14 || 77 |



*）legacyclient_maptable_name是其他数据库中Table的名称。

＃）在legacyclient_maptable_name

DATABASE MODEL

Table_main structure:

|autoid||Parent ID||Map Table ||legacyclient_maptable_name* |
|0 ||1 ||BlnLaporan||basel_f01 |
|1 ||2 ||UserId ||basel_f11_normal |

Table basel_f01 structure

|autoid||BlnLaporan||BlnLaporan2||BlnLaporan3|
|0 ||1 ||1200 ||22 |
|1 ||2 ||12 ||12 |

Table basel_f11_normal structure

|autoid||UserId ||UserId2 ||UserId3 |
|0 ||1 ||1500 ||62 |
|1 ||2 ||14 ||77 |

*) legacyclient_maptable_name are name of Table in other database.
#) Map Tableare column name of Table in "legacyclient_maptable_name

推荐答案

你可以在Datagrid中更改datasoruce一个DataComboboxCell;



string [] values = new string [] {parviz ，ali，abass};



DataGridViewComboBoxCell M =（DataGridViewComboBoxCell）DgvTable.Rows [n] .Cells [m];

M.datasource = values;



使用可以使用datagridview的valuechanged代码

you can change datasoruce a DataComboboxCell in Datagrid;

string[] values=new string[] { "parviz","ali","abass"};

DataGridViewComboBoxCell M =(DataGridViewComboBoxCell ) DgvTable.Rows[n].Cells[m];
M.datasource = values;

use can that code in valuechanged of datagridview

这篇关于带有组合框的数据网格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！