Combo Box in Datagrid (vb.net)

I am using a sql statement to fill a dataset which I use as a data source for a grid.  There are 2 columns, seq_no, product.  The product column I would like to be a combobox which has the selected value property assigned by what is returned from the query. the combobox values list I will populate another way.  If i use something like:
dim dt as data table
dim ds as dataset
 ds1 = FillGrid1()
        dt = ds1.Tables(0)
        With DataGrid1
            .DataSource = dt
        End With
(where FillGrid1 is a function that passes a dataset filled with the results of the query)

How do I turn the "product"  column into a combobox?
   
garyinmiami2003Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Éric MoreauSenior .Net ConsultantCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
garyinmiami2003Author Commented:
emoreau:

Thank you for the input.  There are 46 pages in that FAQ.  It is informative and it may lead to the solution, some day.  I have to read it, set up a little test and when I get it right copy it into my program.  That is fair but not what I was hoping for.  What I would like to have is something I can relate to the specific problem I put in my question, a code snippet I can plug in test, tweek a little but not research it too much.
I know you have the knowledge but I need it applied to my problem unless you have a faq with examples included.
 
0
Éric MoreauSenior .Net ConsultantCommented:
but the link I have provided should have bring you directly to "5.9 How can I put a combobox in a column of a datagrid?"
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

NetminderCommented:
Grade changed by asker request.

Netminder
Site Admin
0
Éric MoreauSenior .Net ConsultantCommented:
I originally got a C. Where can I see what is the grade now?
0
NetminderCommented:
We always increase by one level. There isn't any place you can actually see it though; I can send you a screen shot if you like.

N
0
garyinmiami2003Author Commented:
emoreau:

The C was a mistake on my part.  The B was what I intended.  I am truly sorry if that offended you as I have gotten numerous questions answered in the past.  Some by you.  It is not my mission in life to insult anyone and especially not you.  If you feel that this is what has happened, let me know and I will see what I can do about it.  In this instance, I was hoping for a code snippet or something that I did not have to study a faq to get.  That was lazy on my part and I did not spend much time to compose  the question to offer a better chance to get what I was looking for.  



 
0
Éric MoreauSenior .Net ConsultantCommented:
>>If you feel that this is what has happened

I do not feel insulted. I just wanted to know what was the new grade since it is not visible on this question.

>>I was hoping for a code snippet

I think the link provide a better answer then a code snippet. It has a complete sample (in both VB and C#)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.