<div>
Wonderful! &nbsp;Exactly with I was looking for.<br />
<br />
Thank you very much!<br />
<br />
David
</div>


Wonderful!  Exactly with I was looking for.

Thank you very much!

David

<div>
<div class="content wysiwyg-content">
On a Windows Form I have two DataGridViews, one for each of two related tables. &nbsp;They are related on a common Key_ID field. &nbsp;I want them to always stay linked on that Key_ID so that the selected rows stay in sync and if Key_ID is selected in on DataGridView the row with the same Key_ID is selected in the other DataGridView.<br />
<br />
I'm currently using a ComboBox bound as follows to link them:<br />
Data Source: &nbsp;BindingSource1<br />
Display Member: &nbsp;Some Text<br />
Value Member: Table1.Key_ID<br />
Selected Value: Table2.Key_ID<br />
<br />
The problem with this is that when I scroll down through the rows the textbox I have capturing the information I need is a row behind. &nbsp;It displays the value from the row I have just left not the current row. &nbsp;I have a SQL query run on the ComboBox.SelectedIndexChan<wbr />ged event.<br />
<br />
I'd like to do away with the combobox entirely and just link the two DataGridView directly. &nbsp;Any ideas? &nbsp;<br />
I'm using VB.NET in VS2005, .Net 2.0<br />
<br />
Thanks.<br />
David
</div>
</div>


On a Windows Form I have two DataGridViews, one for each of two related tables.  They are related on a common Key_ID field.  I want them to always stay linked on that Key_ID so that the selected rows stay in sync and if Key_ID is selected in on DataGridView the row with the same Key_ID is selected in the other DataGridView.

I'm currently using a ComboBox bound as follows to link them:
Data Source:  BindingSource1
Display Member:  Some Text
Value Member: Table1.Key_ID
Selected Value: Table2.Key_ID

The problem with this is that when I scroll down through the rows the textbox I have capturing the information I need is a row behind.  It displays the value from the row I have just left not the current row.  I have a SQL query run on the ComboBox.SelectedIndexChanged event.

I'd like to do away with the combobox entirely and just link the two DataGridView directly.  Any ideas?  
I'm using VB.NET in VS2005, .Net 2.0

Thanks.
David

How to link two DataGridViews

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.