Discrepancy in DataGridView column order & databound DataTable

[Mike]

Dear group,

I'm currrently investigating a bug within a piece of our software whereby if
a DataGridView (bound directly to a DataTable) is ordered by column headers
(containing lookup combo boxes where the value is the foreign key of another
table), although the DataGridView is ok, the DataTable becomes out of sync.

In other words, I have a Grid of customers, and if a customer name column
header is clicked - the data moves in the DataGridView, but previous data is
still held for the original row positions in the DataTable.

This throws off row calculations quite considerably, and is a particularly
fustrating bug to debug.

Any ideas are most welcome, and thanks in advance for any advice.

Regards,

Mike

[Ken Tucker [MVP]]

Mike,

The datagridview is actually bound to the datatable's defaultview.
That will have the records in the right order.

Ken
----------------------------
"Mike" <nonewrote in message news:uv******** ******@TK2MSFTN GP02.phx.gbl...

Dear group,

I'm currrently investigating a bug within a piece of our software whereby
if a DataGridView (bound directly to a DataTable) is ordered by column
headers (containing lookup combo boxes where the value is the foreign key
of another table), although the DataGridView is ok, the DataTable becomes
out of sync.

In other words, I have a Grid of customers, and if a customer name column
header is clicked - the data moves in the DataGridView, but previous data
is still held for the original row positions in the DataTable.

This throws off row calculations quite considerably, and is a particularly
fustrating bug to debug.

Any ideas are most welcome, and thanks in advance for any advice.

Regards,

Mike

[Brian Tkatch]

Ken Tucker [MVP] wrote:

Mike,

The datagridview is actually bound to the datatable's defaultview.
That will have the records in the right order.

Ken
----------------------------
"Mike" <nonewrote in message news:uv******** ******@TK2MSFTN GP02.phx.gbl...

Dear group,

I'm currrently investigating a bug within a piece of our software whereby
if a DataGridView (bound directly to a DataTable) is ordered by column
headers (containing lookup combo boxes where the value is the foreign key
of another table), although the DataGridView is ok, the DataTable becomes
out of sync.

In other words, I have a Grid of customers, and if a customer name column
header is clicked - the data moves in the DataGridView, but previous data
is still held for the original row positions in the DataTable.

This throws off row calculations quite considerably, and is a particularly
fustrating bug to debug.

Any ideas are most welcome, and thanks in advance for any advice.

Regards,

Mike

Wow, thanx, that clears something up for me too.

BTW, a way to simply test this would be to add a DataGridView, three
textboxes and a button. Then the following code:

Dim table As New DataTable

Private Sub Form1_Load(ByVa l sender As Object, ByVal e As
System.EventArg s) Handles Me.Load

Dim row As DataRow

table.Columns.A dd()

row = table.NewRow
table.Rows.Add( row)
row(0) = "A"

row = table.NewRow
table.Rows.Add( row)
row(0) = "B"

DataGridView1.D ataSource = table

End Sub
Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button1.Click
TextBox1.Text = DataGridView1.I tem(0, 0).Value.ToStri ng
TextBox2.Text = table.Rows(0)(0 ).ToString
TextBox3.Text = table.DefaultVi ew.Item(0)(0).T oString
End Sub

B.

[Mike]

"Brian Tkatch" <Ma***********@ ThePentagon.com wrote in message
news:11******** ************@m7 9g2000cwm.googl egroups.com...

>
Ken Tucker [MVP] wrote:

>Mike,

The datagridview is actually bound to the datatable's
defaultview.
That will have the records in the right order.

Ahhh, thank you. I think that will solve it.

>----------------------------
"Mike" <nonewrote in message
news:uv******* *******@TK2MSFT NGP02.phx.gbl.. .

Dear group,

I'm currrently investigating a bug within a piece of our software
whereby
if a DataGridView (bound directly to a DataTable) is ordered by column
headers (containing lookup combo boxes where the value is the foreign
key
of another table), although the DataGridView is ok, the DataTable
becomes
out of sync.

In other words, I have a Grid of customers, and if a customer name
column
header is clicked - the data moves in the DataGridView, but previous
data
is still held for the original row positions in the DataTable.

This throws off row calculations quite considerably, and is a
particularly
fustrating bug to debug.

Any ideas are most welcome, and thanks in advance for any advice.

Regards,

Mike

Wow, thanx, that clears something up for me too.

Private Sub Button1_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button1.Click
TextBox1.Text = DataGridView1.I tem(0, 0).Value.ToStri ng
TextBox2.Text = table.Rows(0)(0 ).ToString
TextBox3.Text = table.DefaultVi ew.Item(0)(0).T oString
End Sub

^ Great example too. I'll have to do some recoding tonight. If any MSDN
article authors are reading this; this has got to be somewhere that a LOT of
people trip up on, but very little example documentation alludes to using
the .DefaultView.

Thanks!

Mike