How to use multiple datasources in DataGridViewComboBoxColumn?

Question

0.00/5 (No votes)

See more:

.NET3.5

, +

hey!
in a win forms application, i'm loading a datagridview called dg from a data source called servRet.
the servRet fills in the data grid. after setting the dg.datasource to servRet.value, i'm creating a new column of type DataGridViewComboBoxColumn which future to hold types of coins (e.g: CAD, US, NIS...).
Now, here is the tricky part:
the combo box suppose to display the displayValue from the servRet but when the client open the combo box, he needs to see all the coins list.
the coins list is dragged from another data source called servRet1.
i'm seek to accomplish a state where the combo box display the current value from the current row in the servRet and at the same time fill the item of the combo with the second data source.
unfortunately, i ran into several problems:
1. i tried to pass the servRet1 to a list and the load it to the combo but i cant add items to a binded combo box.
2. i cant load 2 data sources to one combo box.
3. even when loading the servRet to the combo box and on the drag open i'm setting the combo data source to null and load the servRet1, on the selectedIndexChange, it doesn't allow me to choose any other value rather then the first value it held.
here is the code for loading the first data:

C#

public void FillData(IShaarimService service)
{
    List<string> listTeuraMatbea = new List<string>();
    List<string> listKodAndShemMatbea = new List<string>();
    var servRet = service.getNiyarotBeMatbeaShoneMeBank();
    var servRet1 = service.getMatbeaot();

    if (ServiceUtil.IsValid(servRet1))
    {

        foreach (DataRow row in servRet1.Value.Rows)
        {
            listKodAndShemMatbea.Add(row[&quot;KodAndShemMatbea&quot;].ToString());
            listTeuraMatbea.Add(row[&quot;TeuraMatbea&quot;].ToString());
        }
    }

    if (ServiceUtil.IsValid(servRet))
    {
        grdNiyar.SetDataSourceByServerReturn(servRet);
        dg.AutoGenerateColumns = false;
        dg.ColumnCount = 4;
        dg.DataSource = servRet.Value;
        DataGridViewComboBoxColumn cb = new DataGridViewComboBoxColumn();
        cb.DataSource = servRet.Value.DefaultView.ToTable(true, KodAndShemMatbea&);
        //foreach (var item in listKodAndShemMatbea)
        //{
        //    cb.Items.Add(item);
        //}
        cb.HeaderText = &quot;מטבע בבנק&quot;;
        cb.DisplayMember = &quot;123&quot;;
        cb.DataPropertyName = &quot;KodAndShemMatbea&quot;;
        cb.DisplayMember = &quot;KodAndShemMatbea&quot;;
        cb.ValueMember = &quot;KodAndShemMatbea&quot;;
        dg.Columns.Add(cb);

    }</pre>

any help we be appreciate!!!

Posted 30-Nov-15 20:40pm

oron sultan

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

George Jonsson · Answer 1 · 2015-11-30T21:12:00

I think this MSDN example will help you forward
DataGridViewComboBoxColumn.DataSource Property[^]

Basically it works like this.
1. You have a DataGridView where you set the DataSource to a DataTable or BindingSource.
2. You specify that one of the columns should be a DataGridViewComboBoxColumn
This column has a property called DataPropertyName which is set to a column in the DataTable.

Code from the designer module

C#

this.dataSet1 = new System.Data.DataSet();
this.dataTable1 = new System.Data.DataTable();
this.dataColumn1 = new System.Data.DataColumn();
this.dataColumn2 = new System.Data.DataColumn();
this.bindingSource3 = new System.Windows.Forms.BindingSource(this.components);
this.columnSeasons = new System.Windows.Forms.DataGridViewComboBoxColumn();

this.dataGridView1.DataSource = this.bindingSource3;

// 
// dataSet1
// 
this.dataSet1.DataSetName = "NewDataSet";
this.dataSet1.Tables.AddRange(new System.Data.DataTable[] {
this.dataTable1});
// 
// dataTable1
// 
this.dataTable1.Columns.AddRange(new System.Data.DataColumn[] {
this.dataColumn1,
this.dataColumn2});
this.dataTable1.TableName = "Table1";
// 
// dataColumn1
// 
this.dataColumn1.ColumnName = "Column1";
// 
// dataColumn2
// 
this.dataColumn2.ColumnName = "Column2";
// 
// bindingSource3
// 
this.bindingSource3.DataMember = "Table1";
this.bindingSource3.DataSource = this.dataSet1;
// 
// columnSeasons
// 
this.columnSeasons.DataPropertyName = "Column1"; // This comes from the DataSet
this.columnSeasons.HeaderText = "Seasons";
this.columnSeasons.Name = "columnSeasons";
this.columnSeasons.Resizable = System.Windows.Forms.DataGridViewTriState.True;
this.columnSeasons.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic;

3. Now you need to set the data source for the dropdown list of the combo box.
This can be a list of strings or a data table.

C#

DataTable dtSeasons = new DataTable("Seasons");
dtSeasons.Columns.Add("Id", typeof(int));
dtSeasons.Columns.Add("Value", typeof(string));

dtSeasons.Rows.Add(1, "Winter");
dtSeasons.Rows.Add(2, "Spring");
dtSeasons.Rows.Add(3, "Summer");
dtSeasons.Rows.Add(4, "Autumn");

columnSeasons.DataSource = dtSeasons;
columnSeasons.ValueMember = "Id";
columnSeasons.DisplayMember = "Value";

The code sample is not complete but I hope you get the picture.