Hi,

I am trying to create a basic quoting tool but got stuck on how to clear and change the item collection from within a combobox for a datagrid.

What we have is a list of 4 columns like
a. Device b.TypeofService c.State d.Price
Inside a sql database. Data is also structure like above as well.

I have a datagridview where the user will populate a,b,c and the price will be display and a total at the end. However a,b, and c aren't related in my current application. The combobox will show all possible dinstinct values for each column.

This works fine but I want to refine the application to only show the values of b. which are in the database after the user select the value for a. I have tried searching on how to do this as I assume to the Contry/State/City situation but could not find anything for a datagridview control in VB.NET.

Can anyone point me in the right direction? If I cannot do this dynamically from within a datagridview I was thinking of maybe creating three combo box outside and having it populating the datagridview afterwards but it wouldn't be as nice.