populating combo box 1

[dinster]

hi everyone i've managed to be able to put a combo box on the grid.

i used this site and it was quite helpful

http://www.knowdotnet.com/articles/kdngrid.html

how do i use the combo to look up the values in a table currently its using a string?

'ComboBox Column
Dim Items() As String = {"Yes", "No", "Maybe"}
'Dim Filldrugs() As String
Dim cs5 As New CGridComboBoxStyle("Drug_ID", 60, HorizontalAlignment.Left, _
"DrugName", "No", _
Items, ComboBoxStyle.DropDownList)
CGrid.AddColumn(ts, cs5)

Basically i would like the combobox to use an access table called drugs and then fill the combo box when done at runtime?

can someone help me to do this? even an example will do?

 

[SHelton]

Just set the DataSource, ValueMember and DisplayMember properties of the combo column to a DataTable populated from the Access table. Make sure that the ValueMember matches the underlying DataGridView datasource column so that a change in the combo is correctly applied to the grid datasource.