Hi there,

I have encountered a problem which goes like this:

I put a BO (customers from the sample-db) on a form. Add a Business Binding Source which is connected to the BO. Then I add a grid whose datasource is the BBS. Now I want to test a little row/cell-formatting depending on different values on the database. The first step was to show one field (Last Name) in a correponding textbox. I wrote this code

Private Sub DataGridView1_RowEnter(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.RowEnter

TextBox1.Text = BBS.BusinessObject.Item("cust_lastname")

End Sub

But this does not work. The textbox is always one record behind. For example.

It starts with "Achong". I skip down one record down to "Abel", the textbox still shows "Achong". I skip to the next record "Smith", the textbox now show "Abel". So it seems that the BBS is one record behind the selected row on the grid.

Did I miss something there? If I try this with a dataset bound to the grid, it works correct.

Best regards

Thomas

Well you that will depend on the condition used to change the cell background, if you want to change this during the grid being populated, then yes, you have to look for an event that will trigger during that time, or if you want the change to happen after data has been loaded in the grid in another condition, then you will need to know the cell and row to make the change.

I personally don't use the plain DataGridView, I use the DevExpress controls and they are just fantastic, lot of flexibility to handle all kind of condition at the grid level and most of them with not coding just setting the right properties.  I started using DevExpress controls no long ago, but after testing the grid and replacing some SF Listview and getting the complements from users finding this grid much user friendly and advance than the SF ListView, I am now replacing all SF ListView with the DevExpress grid control.

Edhy Rijo

Hi Edhy,

that is good news as I have just downloaded a trial version of the devexpress-grid. My VFP-Apps which I will replace over the next years with VS/SQL/Strataframe-Apps are very much grid-centric and in some cases I need an editable grid. So to read your enthuasiasm about about the devexpress-controls makes me feel right about this way. Thanks lot for your help.

Best regards

Thomas

You are welcome Thomas, and keep us posted with your improvement on DevExpress controls, there are couple of other SF developers which also use DevExpress.  StrataFrame provides an wrapper class for the most common used DevExpress control which add SF binding and make it easier to work with them.

I moved from VFP and Visual ProMatrix framework couple of years ago, and it was a painful transition since I did not knew anything about .Net and very littler about SQL, so it took many hours of hard dedication and focus on looking forward and not thinking the VFP way.  I review 2 major frameworks, Ideablade and StrataFrame and once decided on StrataFrame, I closed all other framework, tools and VFP mentality and it has been very worthy.  StrataFrame business objects are very, very powerful and flexible, much more than working with VFP aliases you can create them via code to manipulate your data in any possible way, for me, very impressive approach by the SF team.

Again, review all documentation several times, search the forums, there are tons of code samples and the chances that whatever problem you encounter could has been fixed before.  Good luck and welcome to the party

Edhy Rijo