Hi All,

I am able to select to display data in a datagridview. My code:

Public Sub ShowData()

        If conn.State = ConnectionState.Closed Then conn.Open()



        cmd = New SqlCommand("SELECT * FROM ClientPlan", conn)

        myDA = New SqlDataAdapter(cmd)

        myDataSet = New DataSet()

        myDA.Fill(myDataSet, "ClientPlan")

        DGV.DataSource = myDataSet.Tables("clientplan").DefaultView

    End Sub

This code works perfectly fine for displaying my data in the DGV.

However , i would now like to have a combo box column in my DGV.
I want to populate my DGV combo box with data from a table in the database.
(I used cb1.item.add for normal/non DGV combo boxes, but i don't know how to implement it for DGV combo boxes.)
For example -
Column Name : Plans
Items in the Combobox : Plan A, Plan B, Plan C (All in the database)
Can anyone tell me how i can get this to work?

I am coding in Visual Studio 2005(VB.NET exclusive) and working with MS SQL database.

Thanks,
gnxc

Have a look to this sample code may be this can help you:

 With DataGridView1  
 
  
 
 ' Set DataGridView Combo Column for CarID field   
 
 Dim ColumnCar As New DataGridViewComboColumn  
 
 ' DataGridView Combo ValueMember field has name "CarID"  
 
 ' DataGridView Combo DisplayMember field has name "Car"  
 
 With ColumnCar  
 
     .DataPropertyName = "CarID"  
 
     .HeaderText = "Car Name"  
 
     .Width = 80  
 
     ' Bind ColumnCar to Cars table  
 
     .box.DataSource = ds.Tables("Cars")  
 
     .box.ValueMember = "CarID"  
 
     .box.DisplayMember = "Car"  
 
 End With  
 
 .Columns.Add(ColumnCar)  
  
 End With  

---

Please mark the post as answer if it is helpfull to you because it boosts the members to answer more and more.

Have a look to this sample code may be this can help you:

 With DataGridView1  
 
  
 
 ' Set DataGridView Combo Column for CarID field   
 
 Dim ColumnCar As New DataGridViewComboColumn  
 
 ' DataGridView Combo ValueMember field has name "CarID"  
 
 ' DataGridView Combo DisplayMember field has name "Car"  
 
 With ColumnCar  
 
     .DataPropertyName = "CarID"  
 
     .HeaderText = "Car Name"  
 
     .Width = 80  
 
     ' Bind ColumnCar to Cars table  
 
     .box.DataSource = ds.Tables("Cars")  
 
     .box.ValueMember = "CarID"  
 
     .box.DisplayMember = "Car"  
 
 End With  
 
 .Columns.Add(ColumnCar)  
  
 End With  

---

Please mark the post as answer if it is helpfull to you because it boosts the members to answer more and more.

It worked! Thank you so much!
Now to find out how to fill the DGV AND the combo box at the same time =P Thanks again!

Hm,
I actually want the items to be from the Plans table, and the selected item to be from the Policy table, how does it work?

  With ColumnCode
                    .DataPropertyName = "PlanCode"
                    .HeaderText = "Plan Code"
                    .Width = 80
                    ' Bind ColumnCar to Cars table  
                    .DataSource = myDataSet2.Tables("plans")
                    .ValueMember = "planCode"
                    .DisplayMember = "planCode"

That's my code atm, i don't know how to set the selected to a different table or how to get it to show though, can anyone help please?
Thanks!