How to set DataReader as ComboBox's datasource property (VB.Net)

[Hardik Shah]

Hi,

Generaly to populate combobox , I use following command :-
Combobox1.datasource = dataset.tablename
combobox1.displaymember = fieldname1
combobox1.valuemember = fieldname2

As I don't want to generate dataset, and instead of it, want to use
datareader , can I give following command
Combobox1.datasource = DataReader
combobox1.displaymember = DataReader.FieldName1
combobox1.ValueMember = DataReader.FieldName2

I also don't want to do like following :-
Do While myReader.Read()

Combobox1.additem (myreader.item(...))

Loop
Is above is possible or is there any other way to populate combobox data ?
Any hints will be sincerely appreciated.
Hardik Shah

[Cor Ligthert [MVP]]

Hardik,

It is possible, however probably with a lot more overhead than using a
dataset (datatable).

What is the reason you don't want that simple dataset/datatable?

Cor

[Hardik Shah]

Simple reason is that ,
As per my knowledge DataReader is faster than dataset and it doesn't occupy
space at client.
I give detail about my project :
In single data entry form there are 8 to 10 ComboBox with different table's
column , I have to create separate dataset for each table, data adapter,
schemas etc..

Am I right , or require to reunderstand the concept.

Please help me to clear above concept.

Hardik Shah.
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:ey*************@tk2msftngp13.phx.gbl...

Hardik,

It is possible, however probably with a lot more overhead than using a
dataset (datatable).

What is the reason you don't want that simple dataset/datatable?

Cor

[Cor Ligthert [MVP]]

Hardik,

How many datatables from your database server are you using?

Cor

"Hardik Shah" <ha********@hotmail.com> schreef in bericht
news:OM**************@TK2MSFTNGP12.phx.gbl...

Simple reason is that ,
As per my knowledge DataReader is faster than dataset and it doesn't
occupy
space at client.
I give detail about my project :
In single data entry form there are 8 to 10 ComboBox with different
table's
column , I have to create separate dataset for each table, data adapter,
schemas etc..

Am I right , or require to reunderstand the concept.

Please help me to clear above concept.

Hardik Shah.
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:ey*************@tk2msftngp13.phx.gbl...

Hardik,

It is possible, however probably with a lot more overhead than using a
dataset (datatable).

What is the reason you don't want that simple dataset/datatable?

Cor

[Hardik Shah]

Hi,

1 or 2 databases

Hardik

"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:uk*************@TK2MSFTNGP09.phx.gbl...

Hardik,

How many datatables from your database server are you using?

Cor

"Hardik Shah" <ha********@hotmail.com> schreef in bericht
news:OM**************@TK2MSFTNGP12.phx.gbl...

Simple reason is that ,
As per my knowledge DataReader is faster than dataset and it doesn't
occupy
space at client.
I give detail about my project :
In single data entry form there are 8 to 10 ComboBox with different
table's
column , I have to create separate dataset for each table, data adapter,
schemas etc..

Am I right , or require to reunderstand the concept.

Please help me to clear above concept.

Hardik Shah.
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:ey*************@tk2msftngp13.phx.gbl...

Hardik,

It is possible, however probably with a lot more overhead than using a
dataset (datatable).

What is the reason you don't want that simple dataset/datatable?

Cor

[Cor Ligthert [MVP]]

Hardik,

I asked tables not databases, however assuming you mean tables in a database
than can it be something as roughly typed here as a kind of pseudo

dim ds as new dataset
dim conn as new sqlconnection(connectionstring)
dim da new dataapter(sqlstring1,conn)
da.fill(ds)
da.selectcommand.commandtext = sqlstring2
da.fill(ds)
dim dv1 as dataview(ds.tables(0)
dim dv2 etc
dim dvt as dataview(ds.tables(1)

combobox1.datasource = dv1
combobox1.displaymember = "whatever"
combobox2.displaymember = "whatelse"
etc etc.

I hope this gives an idea.

Cor

"Hardik Shah" <ha********@hotmail.com> schreef in bericht
news:OZ**************@TK2MSFTNGP14.phx.gbl...

Hi,

1 or 2 databases

Hardik

"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:uk*************@TK2MSFTNGP09.phx.gbl...

Hardik,

How many datatables from your database server are you using?

Cor

"Hardik Shah" <ha********@hotmail.com> schreef in bericht
news:OM**************@TK2MSFTNGP12.phx.gbl...

> Simple reason is that ,
> As per my knowledge DataReader is faster than dataset and it doesn't
> occupy
> space at client.
> I give detail about my project :
> In single data entry form there are 8 to 10 ComboBox with different
> table's
> column , I have to create separate dataset for each table, data
> adapter,
> schemas etc..
>
> Am I right , or require to reunderstand the concept.
>
> Please help me to clear above concept.
>
> Hardik Shah.
>
>
> "Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
> news:ey*************@tk2msftngp13.phx.gbl...
>> Hardik,
>>
>> It is possible, however probably with a lot more overhead than using a
>> dataset (datatable).
>>
>> What is the reason you don't want that simple dataset/datatable?
>>
>> Cor
>>
>>
>
>

[david]

On 2005-09-16, Hardik Shah <ha********@hotmail.com> wrote:

Hi,

Generaly to populate combobox , I use following command :-
Combobox1.datasource = dataset.tablename
combobox1.displaymember = fieldname1
combobox1.valuemember = fieldname2

As I don't want to generate dataset, and instead of it, want to use
datareader , can I give following command
Combobox1.datasource = DataReader
combobox1.displaymember = DataReader.FieldName1
combobox1.ValueMember = DataReader.FieldName2

I also don't want to do like following :-
Do While myReader.Read()

Combobox1.additem (myreader.item(...))

Loop
Is above is possible or is there any other way to populate combobox data ?

Could be I missed a post where somebody said this, but the answer is no.
You can't databind a datareader to a ComboBox. If you want a reader as
the data source, you'll need to loop through the data items. Although
it's pretty trivial to write a function that does this for you.

[Cor Ligthert [MVP]]

David,

Is above is possible or is there any other way to populate combobox data
?

Could be I missed a post where somebody said this, but the answer is no.
You can't databind a datareader to a ComboBox. If you want a reader as
the data source, you'll need to loop through the data items. Although
it's pretty trivial to write a function that does this for you.

Probably you did not think about that and know it, at least do you have to
write an Ilist implementing solution to use the valuemember as the OP is
asking. For me always a kind of masochism if you know that it can be done
with the datatable in some lines of code.

:-)

Cor