DataGridView, TableAdaptor or Binding Source Event?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg P - 24 Aug 2006 18:16 GMT

Ok so I can't change the color of a button, so I want to change the color of
a cell in the same row, based on the argb integer stored in that row
everytime the DataGridView's data is refreshed. I'm looking to have the
color displayed when the user selects the tab page, when data is saved to the
database and even if data is sorted differently by the user. The code I am
using to do this is:

Dim intCount As Integer
For intCount = 0 To TblCompositionDataGridView.RowCount - 2
Dim myColor As Color =
Color.FromArgb(TblCompositionDataGridView.Rows(intCount).Cells(4).FormattedValue)

TblCompositionDataGridView.Rows(intCount).Cells(0).Style.BackColor = myColor
Next

I can put this in the GotFocus event and it fires fine but if I sort I loose
it because the data is changed. If I save changes it is lost becuase the
data is refreshed.

It seems like I want it to fire when on a bindingsource or tableadaptor
event, but I'm not sure?

Thanks again, and by the way you are awsome in your responses.

Reply to this Message

Greg P - 24 Aug 2006 18:33 GMT

AHH HAA, DGV.DataBindingComplete is what I was looking for. I couldn't have
done it with out ya Linda. Please give a response so I can mark it as the
answer. :-)

Greg

> Ok so I can't change the color of a button, so I want to change the color of
> a cell in the same row, based on the argb integer stored in that row
[quoted text clipped - 19 lines]
>
> Thanks again, and by the way you are awsome in your responses.

Reply to this Message

Linda Liu [MSFT] - 25 Aug 2006 04:27 GMT

Hi Greg,

Yes, you are right. Since you have bind the DataGridView to a data source
and the DataBindingComplete event occurs whenever the data source list
changes, you shoud put these code in the DataGridView's DataBindingComplete
event handler to get the correct result.

Sincerely,
Linda Liu
Microsoft Online Community Support

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

DataGridView, TableAdaptor or Binding Source Event?

Free Magazines