[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 :ehh:
Re: DataGridViewComboBox problem!
Me again! :D
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)
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.
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 ;)
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! :mad:
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 ¿
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?
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?
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?
Re: DataGridViewComboBox problem!
I hooked up my dgv with a dataset, etc. And it still works :confused:
Is there any piece of code that can influence this ¿
1 Attachment(s)
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 ;)
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.
Re: DataGridViewComboBox problem!
Oh yeah :blush: 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.
:)
Re: DataGridViewComboBox problem!
You could copy it, delete all the data, and type in some non-nonsensical stuff.
2 Attachment(s)
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 . . . . .