comboboxes

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

Nov 21 '05 #1

Cor Ligthert

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/de...iltertopic.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

Nov 21 '05 #2

Phil

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
"Cor Ligthert" <no************@planet.nl> wrote in message
news:uu*************@TK2MSFTNGP12.phx.gbl...

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/de...us/cpref/html/
frlrfsystemdatadataviewclassrowfiltertopic.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

Nov 21 '05 #3

Cor Ligthert

Phil,

A dataview is a kind of filter that can be used between Datatables and
Controls (datagrid combobox etc). One of the things it does not is holding
data.

Read this first and when you have questions, reply those than
http://msdn.microsoft.com/library/de...classtopic.asp

I hope this helps

Cor

"Phil" <phespe remove this bigpond.net.au>
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
"Cor Ligthert" <no************@planet.nl> wrote in message
news:uu*************@TK2MSFTNGP12.phx.gbl...

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/de...us/cpref/html/
frlrfsystemdatadataviewclassrowfiltertopic.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

Nov 21 '05 #4

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

"Cor Ligthert" <no************@planet.nl> wrote in message
news:ea**************@TK2MSFTNGP15.phx.gbl...

Phil,

A dataview is a kind of filter that can be used between Datatables and
Controls (datagrid combobox etc). One of the things it does not is holding
data.

Read this first and when you have questions, reply those than
http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdatadataviewclasstopic.asp
I hope this helps

Cor

"Phil" <phespe remove this bigpond.net.au>
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
"Cor Ligthert" <no************@planet.nl> wrote in message
news:uu*************@TK2MSFTNGP12.phx.gbl...

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/de...us/cpref/html/ frlrfsystemdatadataviewclassrowfiltertopic.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

Nov 21 '05 #5

Cor Ligthert

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

"Phil" <phespe remove this bigpond.net.au> schreef in bericht
news:%2****************@tk2msftngp13.phx.gbl...

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

"Cor Ligthert" <no************@planet.nl> wrote in message
news:ea**************@TK2MSFTNGP15.phx.gbl...

Phil,

A dataview is a kind of filter that can be used between Datatables and
Controls (datagrid combobox etc). One of the things it does not is
holding
data.

Read this first and when you have questions, reply those than

http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdatadataviewclasstopic.asp

I hope this helps

Cor

>"Phil" <phespe remove this bigpond.net.au>
> 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
> "Cor Ligthert" <no************@planet.nl> wrote in message
> news:uu*************@TK2MSFTNGP12.phx.gbl...
>> 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/de...us/cpref/html/ > frlrfsystemdatadataviewclassrowfiltertopic.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
>>
>>
>
>

Nov 21 '05 #6