Visual Studio 2022 - DataGridView, Cell Value changes during runtime without any command to do so

Dimos Dimosthenous 1

Hello there,

I am playing around with Visual Studio 2022, where I connect my software to a local SQL database.

On my first form, I have a DataGridView and a ComboBox, both bound to same table tblCompanies.
When I select a row from the DataGridView, the value of ComboBox changes as expected.
The strange behavior occurs when I select a value from the ComboBox, which changes all
the values of the DisplayMember with the one selected.
Any ideas on what might be whrong?

Jack J Jun 24,296 Reputation points Microsoft Vendor

2022-12-09T02:23:01.417+00:00

@Dimos Dimosthenous , Welcome to Microsoft Q&A, could you provide some code about your problem with me?
Dimos Dimosthenous 1 Reputation point

2022-12-09T04:58:11.03+00:00

Hello Jack,

I only have the following code related to the DataGridView and the ComboBox.

private void tblCompaniesDataGridView_CellEnter(object sender, DataGridViewCellEventArgs e)
{
MessageBox.Show("Id: " + tblCompaniesDataGridView.Rows[e.RowIndex].Cells[0].Value.ToString() + ", CompanyName: " + tblCompaniesDataGridView.Rows[e.RowIndex].Cells[1].Value.ToString());
}

private void companyNameComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
MessageBox.Show("Id: " + companyNameComboBox.SelectedValue + ", CompanyName: " + companyNameComboBox.DisplayMember.ToString());
}
Jack J Jun 24,296 Reputation points Microsoft Vendor

2022-12-09T05:31:11.73+00:00

@Dimos Dimosthenous , thanks for the feedback, the code you provided can only show two messagebox, which may not match what you described. I recommend that you could provide the code on how to click on the datagirdview to make the combobox changed or how do you bind the database table on datagirdview and combobox.
Dimos Dimosthenous 1 Reputation point

2022-12-09T13:07:12.66+00:00

Dear Jack,

I do not have any other code related to those objects. I bind them through the Design page,
as you can see on the attached pictures.