Hi there.

I am trying to create a search fucntion.
For that i need to fill a combobox with te returnd values
of a query. I created te following query on my dataset designer.

SELECT DISTINCT ACHTERNAAM FROM TELEFOONLIJST.

If i run this query in the query designer i get al de names in my database. when i insert the following code:

toolStripComboBox1.Items.Add(tELEFOONLIJSTTableAda pter.SelectAchternaam());

Only the fist value form the query result is placed in the combobox.

How do i get all the values from this query in my combobox.
I can´t bind the combobox because it is an toolstripcombobox.

I hope someone can help me.

Greetz

MacDevv

use datareader for fetching say dr

while(dr.Read())
{
toolStripComboBox1.Items.Add(dr.GetValue(0));

}


Bijgupt