Datagridviewcomboboxcolumn showing blank

Question

0.00/5 (No votes)

See more:

I have 1 grid view. On gridview cell click, it will show relavant data in another gridview.

Now another gridview has DataGridViewComboBoxColumn

Its data is loading but is is showing when i click on it.

Bu default it is showing blank.

Like this.

https://i.imgur.com/E8CHSBc.png[^][^]

It is showing blank. DataGridViewComboBoxColumn data are fetched is successfully.

They are showing when i click on that DataGridViewComboBoxColumn

Like this

https://i.imgur.com/qG75C5r.png[^]
[^]

what i want that it should also show data in first image

What I have tried:

C#

var cmbContactsName = new DataGridViewComboBoxColumn();

var dt2 = new DataTable();

dt2 = StMethod.GetListDT<InvoiceAddress>("SELECT (FirstName +' '+ LastName) as Contact,EmailAddress ,ContactsID FROM contacts where (IsDelete=0 or IsDelete IS NULL) AND Companyid=" + grdCompany.Rows[grdCompany.CurrentRow.Index].Cells["CompanyID"].Value.ToString());

cmbContactsName.DataSource = dt2;

cmbContactsName.ValueMember = dt2.Columns["ContactsID"].ToString();

cmbContactsName.DisplayMember = dt2.Columns["Contact"].ToString();

cmbContactsName.DataPropertyName = dt2.Columns["ContactsID"].ToString();
                
cmbContactsName.HeaderText = "Contacts Name";

cmbContactsName.ValueType = typeof(String);

cmbContactsName.DefaultCellStyle.NullValue = "";

Posted 5-Oct-21 21:28pm

Devendra Sarang

Updated 6-Oct-21 1:50am

v2

Add a Solution

3 solutions

Add a Solution

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

mirajanata · Answer 1 · 2021-10-05T21:56:00

Solution 1

Try just

cmbContactsName.ValueMember = "ContactsID";

cmbContactsName.DisplayMember = "Contact";

cmbContactsName.DataPropertyName = "ContactsID";

P.S.: "FirstName" is not a member of query column list, you can't address it as a DataTable column. Use "Contact" instead.

Posted 5-Oct-21 21:56pm

mirajanata

Comments

Devendra Sarang 6-Oct-21 5:01am

set the following but not working for me

cmbContactsName.ValueMember = dt2.Columns["ContactsID"].ToString();

cmbContactsName.DisplayMember = dt2.Columns["Contact"].ToString();

cmbContactsName.DataPropertyName = dt2.Columns["ContactsID"].ToString();

CHill60 6-Oct-21 5:35am

"but not working for me" ... That's because you are not following the instructions in the solution. Replace those three lines with the three lines from mirajanata's Solution

Devendra Sarang 6-Oct-21 6:14am

if i am using this

cmbContactsName.ValueMember = "ContactsID";

cmbContactsName.DisplayMember = "Contact";

cmbContactsName.DataPropertyName = "ContactsID";

then it is showing like this

https://i.imgur.com/okPneUy.png

Devendra Sarang 15-Oct-21 23:35pm

i have got answer.

Data is not showing because "cmbContactsName.ValueMember = dt2.Columns["ContactsID"].ToString()"
this one is throwing "Datagridviewcomboboxcell value is not valid" exception.

cmbContactsName.ValueMember = dt2.Columns["ContactsID"].ToString();
so i have commented that line and now data is showing in
but problem is that i have to use ValueMember value for further action

CHill60 · Answer 2 · 2021-10-06T01:05:00

Solution 2

Try this order instead - it's the setting of DataSource that I've moved to after the ValueMember and DisplayMember

C#

cmbContactsName.ValueMember = "ContactsID";
cmbContactsName.DisplayMember = "Contact";
cmbContactsName.DataPropertyName = "ContactsID";
cmbContactsName.DataSource = dt2;

Posted 6-Oct-21 1:05am

CHill60

Comments

Devendra Sarang 6-Oct-21 7:14am

nope bro. same problem.

mirajanata · Answer 3 · 2021-10-06T01:50:00

Solution 3

This is binding problem, maybe this helps:

cmbContactsName.DataSource = dt2.DefaultView;

instead of

cmbContactsName.DataSource = dt2;

Posted 6-Oct-21 1:50am

mirajanata

Comments

CHill60 6-Oct-21 8:00am

Just a comment - it's usually best to use the "Improve solution" link on your first reply to add information / correct information. Otherwise it can be confusing for incoming readers

mirajanata 6-Oct-21 10:00am

OK, understood.

Datagridviewcomboboxcolumn showing blank

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Datagridviewcomboboxcolumn showing blank

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us