CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    Join Date
    Dec 2002
    Location
    Tenby, Wales
    Posts
    277

    [RESOLVED] DataGridViewComboBox problem!

    Hi

    I have a DataGridView and am adding columns at runtime. One particular column is a ComboBox column. I have populated it but when I come to run the program, the ComboBoxes are in the relevant cells but don't drop down when you click on them! My code is below:
    Code:
      With DataGridView1
                Dim Penalty As New DataGridViewComboBoxColumn
    
                With Penalty
                    .Name = "Penalty"
                    .HeaderText = "Penalty"
                    .Width = 40
                    .Visible = True
                    .ReadOnly = False
                    .Items.Add("1")
                    .Items.Add("3")
                    .Items.Add("4")
                    .Items.Add("5")
                    .Items.Add("6")
                    .Items.Add("7")
                    .Items.Add("8")
                    .Items.Add("11")
                End With
    
                DataGridView1.Columns.Insert(6, Penalty)
    
            End With
    Any help would be great! Thanks

  2. #2
    Join Date
    Aug 2005
    Location
    Imperial College London, England
    Posts
    490

    Re: DataGridViewComboBox problem!

    Me again!
    Ok, firstly, don't nest With statements. I'm surprised that compiled, as .Name could a property of either. The following code (which is essentially the same) works on my computer:
    Code:
                    Dim Penalty As New DataGridViewComboBoxColumn With {.Name = "Penalty", .ReadOnly = False, .HeaderText = "Penalty", .Width = 40, .Visible = True}
    
                    With Penalty.Items
                            .Add("1")
                            .Add("3")
                            .Add("4")
                            .Add("5")
                            .Add("6")
                            .Add("7")
                            .Add("8")
                            .Add("11")
                    End With
    
                    DataGridView1.Columns.Insert(6, Penalty)
    Help from me is always guaranteed!*
    VB.NET code is made up on the spot with VS2008 Professional with .NET 3.5. Everything else is just made up on the spot.
    Please Remember to rate posts, use code tags, send me money and all the other things listed in the "Before you post" posts.

    *Guarantee may not be honoured.

  3. #3
    Join Date
    Dec 2002
    Location
    Tenby, Wales
    Posts
    277

    Re: DataGridViewComboBox problem!

    Why hello again - thanks for the help!
    Code:
            Dim Penalty As New DataGridViewComboBoxColumn with{.Name = "Penalty", .ReadOnly = False, .HeaderText = "Penalty", .Width = 40, .Visible = True}
    didn't work - it had blue curly lines from the 'with' part onwards and the error said that End of statement was expected.

  4. #4
    Join Date
    Jul 2001
    Location
    Sunny South Africa
    Posts
    11,283

    Re: DataGridViewComboBox problem!

    You could try :
    Code:
    Dim Penalty As New DataGridViewComboBoxColumn 
            With Penalty : .Name = "Penalty" : .ReadOnly = False : .HeaderText = "Penalty" : .Width = 40 : .Visible = True : End With
    You use the colon ( : ) to chain multiple statements onto one line.
    Very Bad practice IMHO, though - and, doesn't address your actual problem
    Last edited by HanneSThEGreaT; July 29th, 2008 at 09:24 AM.

  5. #5
    Join Date
    Dec 2002
    Location
    Tenby, Wales
    Posts
    277

    Re: DataGridViewComboBox problem!

    HanneSThEGreaT

    Have you any idea why the values are not showing up in my ComboBoxes?

    I have been looking over it for about 45mins now with no joy!
    Visual Basic 2005 ver. 8.0.50727.867

  6. #6
    Join Date
    Jul 2001
    Location
    Sunny South Africa
    Posts
    11,283

    Re: DataGridViewComboBox problem!

    I was curious...

    Hi brjames32!

    Well, I took your code exactly as it is on post#1, and it worked - just changed the column index. OK, my DataGridView was not bound to any datasource, but it works, as in the pic.

    So, perhaps your problem is elsewhere ¿
    Last edited by HanneSThEGreaT; June 14th, 2010 at 05:40 AM.

  7. #7
    Join Date
    Dec 2002
    Location
    Tenby, Wales
    Posts
    277

    Re: DataGridViewComboBox problem!

    Yep - I thought it should work!

    Right then - I shall continue to TRY to find out what is stopping the ComboBoxes populating. The boxes are there in each row but have nothing in them.

    Surely the DataGridView being populated at runtime shouldn't stop this working?
    Visual Basic 2005 ver. 8.0.50727.867

  8. #8
    Join Date
    Aug 2005
    Location
    Imperial College London, England
    Posts
    490

    Re: DataGridViewComboBox problem!

    It might do if the program thinks that the column is bound at all. Are you populating manually or from a dataset?
    Help from me is always guaranteed!*
    VB.NET code is made up on the spot with VS2008 Professional with .NET 3.5. Everything else is just made up on the spot.
    Please Remember to rate posts, use code tags, send me money and all the other things listed in the "Before you post" posts.

    *Guarantee may not be honoured.

  9. #9
    Join Date
    Dec 2002
    Location
    Tenby, Wales
    Posts
    277

    Re: DataGridViewComboBox problem!

    I am populating manually at runtime so it can't be that the column thinks it's already bound.

    It's a strange one ain't it?
    Visual Basic 2005 ver. 8.0.50727.867

  10. #10
    Join Date
    Jul 2001
    Location
    Sunny South Africa
    Posts
    11,283

    Re: DataGridViewComboBox problem!

    I hooked up my dgv with a dataset, etc. And it still works

    Is there any piece of code that can influence this ¿

  11. #11
    Join Date
    Dec 2002
    Location
    Tenby, Wales
    Posts
    277

    Re: DataGridViewComboBox problem!

    I have attached the whole project to this reply. I can't find out what it could be! would be greatful if any of you can! The part we are discussing is in:
    Code:
    Private Sub cmdShow_Click
    section.

    Thanks a lot
    Attached Files Attached Files
    Last edited by HanneSThEGreaT; July 30th, 2008 at 05:15 AM. Reason: Tried to edit Rar into Zip, but failed
    Visual Basic 2005 ver. 8.0.50727.867

  12. #12
    Join Date
    Aug 2005
    Location
    Imperial College London, England
    Posts
    490

    Re: DataGridViewComboBox problem!

    Without the database, it's kinda hard to run. I can spot anything wrong with that section, although with Option Strict, there a few warnings about (a couple of unused variables, which I think will get, and some functions that don't return values). Wish I could be of more help.
    Help from me is always guaranteed!*
    VB.NET code is made up on the spot with VS2008 Professional with .NET 3.5. Everything else is just made up on the spot.
    Please Remember to rate posts, use code tags, send me money and all the other things listed in the "Before you post" posts.

    *Guarantee may not be honoured.

  13. #13
    Join Date
    Dec 2002
    Location
    Tenby, Wales
    Posts
    277

    Re: DataGridViewComboBox problem!

    Oh yeah forgot about the Database. It's 4.9 meg at the moment and contains sensitive student data as it's for a school admin system.

    Will see if I can strip some stuff out of it and maybe password protect it too.

    Last edited by brjames32; July 30th, 2008 at 02:23 AM.
    Visual Basic 2005 ver. 8.0.50727.867

  14. #14
    Join Date
    Aug 2005
    Location
    Imperial College London, England
    Posts
    490

    Re: DataGridViewComboBox problem!

    You could copy it, delete all the data, and type in some non-nonsensical stuff.
    Help from me is always guaranteed!*
    VB.NET code is made up on the spot with VS2008 Professional with .NET 3.5. Everything else is just made up on the spot.
    Please Remember to rate posts, use code tags, send me money and all the other things listed in the "Before you post" posts.

    *Guarantee may not be honoured.

  15. #15
    Join Date
    Dec 2002
    Location
    Tenby, Wales
    Posts
    277

    Re: DataGridViewComboBox problem!

    WOW - Access Database .rar well - it shrank from 5.9MB to 436KB!!! Also, I have attached the spreadhseets that the info is saved to - there is no problem saving though.

    Anyway, here it is attached to this post . . . . .
    Attached Files Attached Files
    Visual Basic 2005 ver. 8.0.50727.867

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured