2.0 DataGridViewCom boBoxColumn Problem.

[Shawn]

I am trying to use a DataGridView to display one column of textboxes with a
single value from a query and then next to it have a combobox that displays
results from another query. What happens is the second query just returns 1
value to each combobox. So, in other words, for each textbox, the next
result of the second query puts 1 value in the corresponding combobox.

Here is my code... What the heck am I doing wrong????

cmd = frmMainForm.cnn Shared.CreateCo mmand
cmd.CommandText = "select ID, DateEntered, Officer, FireExtID, State, Notes,
FireExtIDNum from FireExtClearing House"
cmd.CommandType = System.Data.Com mandType.Text
da.SelectComman d = cmd
da.Fill(ds, "Checks")

CmdExt = frmMainForm.cnn Shared.CreateCo mmand
CmdExt.CommandT ext = "select ID, Name from FireExtinguishe rs"
CmdExt.CommandT ype = System.Data.Com mandType.Text

da.SelectComman d = CmdExt
da.Fill(dsExt, "Ext")

dgMain.DataSour ce = ds.Tables(0)
dgMain.Columns. Clear()

Dim dgColID As New DataGridViewTex tBoxColumn
dgColID.DataPro pertyName = "FireExtID"
dgColID.HeaderT ext = "Extinguish er ID"
dgColID.SortMod e = DataGridViewCol umnSortMode.Not Sortable
dgMain.Columns. Add(dgColID)

Dim dgColSelect As New DataGridViewCom boBoxColumn
With dgColSelect
..DataPropertyN ame = "ID"
..DataSource = dsExt.Tables("E xt")
..DisplayMember = "Name"
..ValueMember = "ID"
..HeaderText = "Extinguish ers in the database"
..SortMode = DataGridViewCol umnSortMode.Not Sortable
End With
dgMain.Columns. Add(dgColSelect )

[Bart Mermuys]

Hi,

"Shawn" <sh**********@c cci.org> wrote in message
news:ea******** *****@TK2MSFTNG P12.phx.gbl...

I am trying to use a DataGridView to display one column of textboxes with a
single value from a query and then next to it have a combobox that displays
results from another query. What happens is the second query just returns 1
vale to each combobox. So, in other words, for each textbox, the next sult
of the second query puts 1 value in the corresponding combobox.

Here is my code... What the heck am I doing wrong????

cmd = frmMainForm.cnn Shared.CreateCo mmand
cmd.CommandText = "select ID, DateEntered, Officer, FireExtID, State,
Notes, FireExtIDNum from FireExtClearing House"
cmd.CommandType = System.Data.Com mandType.Text
da.SelectComman d = cmd
da.Fill(ds, "Checks")

CmdExt = frmMainForm.cnn Shared.CreateCo mmand
CmdExt.CommandT ext = "select ID, Name from FireExtinguishe rs"
CmdExt.CommandT ype = System.Data.Com mandType.Text

da.SelectComman d = CmdExt
da.Fill(dsExt, "Ext")

dgMain.DataSour ce = ds.Tables(0)
dgMain.Columns. Clear()

Dim dgColID As New DataGridViewTex tBoxColumn
dgColID.DataPro pertyName = "FireExtID"
dgColID.HeaderT ext = "Extinguish er ID"
dgColID.SortMod e = DataGridViewCol umnSortMode.Not Sortable
dgMain.Columns. Add(dgColID)

Dim dgColSelect As New DataGridViewCom boBoxColumn
With dgColSelect
.DataPropertyNa me = "ID"
This should be a column from the "Checks" table that is a foreign key to the
"Ext" table, so:

..DataPropertyN ame = "FireExtID" ' or whatever the fk is
.DataSource = dsExt.Tables("E xt")
.DisplayMember = "Name"
.ValueMember = "ID"
Value- and DisplayMember should come from the "Ext" table and the
ValueMember column should be the pk, so that's ok.

HTH,
Greetings
.HeaderText = "Extinguish ers in the database"
.SortMode = DataGridViewCol umnSortMode.Not Sortable
End With
dgMain.Columns. Add(dgColSelect )