An extra identical grid appear on click (multi-level databound grid).

[Khoi Phan]

Hi,

I have a problem with the display of the 2-level databound grid.

My dataset has 2 tables (''Vendors'' and ''Contacts'') and a relation ''VendorContact'' which relates ''Vendors'' and ''Contacts'' based on VendorId column. I then set the grid''s data source to that data set.

Everything works just fine until I hide some extra columns (column 2 and 3). When I click on any row, I would see a portion of the extra column shows up right under the first column of the grid. When I mouse over that extra column, it shifted to the end of the grid and then disappear and everything is back to normal.

If I resize the plus/minus sign column big enough, and then click on any row, I would see another identical grid appear right next to my original one. The only difference is that I can only click on the original but not the second one.

I noticed that when I try to resize the column a couple time when the problem occured, the problem then just went away.

I''ve tried to fix the prob, but nothing worked. Please help me.

Thanks in advance.

Khoi

[Administrator]

After you hide the columns, try calling grid.Refresh() to see if that takes care of this problem.

[Khoi Phan]

I tried it out, and the problem still there.

Correction for the original post:
- Everything works just fine until I hide some extra columns (column 2 and 3). When I click on any row, I would see a portion of the extra column shows up right under the first column of the grid. When I mouse over that extra column, it shifted to the end of the grid and then STAYED AT THE LAST COLUMN.

>After you hide the columns, try calling grid.Refresh() to see if that takes care of this problem.
>

[Administrator]

I don''t really have any insight into what might be going on. Can you post a sample here showing the problem, or submit a Direct Trac support incident with a sample? That way, we can try to spot the problem here?

[Khoi Phan]

I''m trying to recreate the problem in my application, but the problem doesn''t come up in the sample project. But if you look at the code, you''ll see what I''m trying to do. I also attach some pictures to illustrate the problems. - Picture 1.jpg: First start - No problem - Picture 2.jpg: Click on any row - Problem: A portion of a column appear right in between ''Vendor/Contact Name'' and ''Type'' columns - Picture 3.jpg: To see the the problem better in picture 2.jpg, I expand the plus/minus column big enough. I then clicked on any row and the duplicate grid appears. Note: The problem seem to disappear when the Windows repaints. For example when the problem happen and if I go to any other application which pops up some window and come back, the problem is gone. >I don''t really have any insight into what might be going on. Can you post a sample here showing the problem, or submit a Direct Trac support incident with a sample? That way, we can try to spot the problem here? GridProbs_9018.zip

[Administrator]

Do you see any exceptions being noted in the output window?

Something to try. Instead of using Me.gdbVendorContact.Model.Cols.Hidden to hide columns, try just not including those columns in your two LayoutColumns calls.

[Khoi Phan]

There''s no exception in the output window. I did a trace and it ran all the way without throwing any exception.

I''ve tried to hide the columns using the LayoutColumns calls. It did fix the problem, however there''s another problem. The ''Active'' column now cannot be shown or hidden like it''s supposed to be anymore.

>Do you see any exceptions being noted in the output window?
>
>Something to try. Instead of using Me.gdbVendorContact.Model.Cols.Hidden to hide columns, try just not including those columns in your two LayoutColumns calls.

[Administrator]

Instead of hiding the column, maybe setting its width to zero will make it work in your code.

If Not Me.chkShowAll.Checked Then
                Me.gdbVendorContact.Model.ColWidths(3) = 70
            Else
                Me.gdbVendorContact.Model.ColWidths(3) = 0
            End If

[Khoi Phan]

Very good suggestion, Clay. I set the size of the supposedly hidden columns to 0 instead of hiding it. The grid displays correctly now. Thank you very much.

>Instead of hiding the column, maybe setting its width to zero will make it work in your code.
>

>If Not Me.chkShowAll.Checked Then
>                Me.gdbVendorContact.Model.ColWidths(3) = 70
>            Else
>                Me.gdbVendorContact.Model.ColWidths(3) = 0
>            End If
>