comboboxes

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hi all
I'm new to vb but have a little experience in vba
im using vb.net
my question is with comboboxes
the fist combo box lists the manufactures when a selection is made the
second combox populates with the available products and when a selection is
made here then next combobox will be populated with model numbers and so on
can someone point me in the direction for this information and also does
information get stored in a data base or just within the code files
thanks Phil
 
Phil,

Next time don't use a name like comboboxes, a lot of (most) users use
Outlook Express to see newsgroups. It will search to a subject like yours
and your message will be connected to an older one, therefore in your
subject "Needs help with 3 comboboxes for 3 tables" will set this appart.

Your question, Yes that is easy to do.

What you need is 3 dataviews.
With rowfilters wich you make the datasources of your comboboxes.

When combobox 1 changes, you use the indexchange event of that combobox,
toset the rowfilter of the dataview to the selectedtext (or value) and so on
to the next combobox.

http://msdn.microsoft.com/library/d...rlrfsystemdatadataviewclassrowfiltertopic.asp

It is as well possible with datareleations, however to get it fire you need
again the same procedure and therefore I see no benefit for that.

I hope this helps?

Cor
 
hi cor
my understanding of dataviewer is that it holds the data within the code
the solution I need will need a data base that is easy to up date like a
excel spreadsheet or something simular as the project information will be
undated every 6 months with numerous changes. Am I correct in my
understanding of dataview or have I totally confused myself
thanks Phil
 
Hi cor
im starting to understand the concept but i'm confunsed on where to start
do i create a datatable through "add dataset" and which data set should i
use typed or untyped
and where do i add the contents to the tables
thanks phil
 
Phil,

A typed dataset and a untyped dataset are both dataset. The last one is
inherited from a dataset as well.

To create a dataview it is the most simple done with
dim dv as new dataview(mydataset.tables("mytable"))
in the non typed version
dim dv as new dataview(mydataset.mytable)
in the typed version.

I would start for learning with the non typed version, because than you
better understand what happens.

I hope this helps?

Cor
 
Back
Top