How can I speed up the combobox

[Ivan V via DotNetMonster.com]

Dear All:

I just wrote a code for the combobox to show a list of supplier name from
the sql server. After running the code, it seems to take a least 6 to 10
seconds to activate the combobox, does anyone knows how to speed up the
process?? Following is the code for it.

kn = New SqlConnection("Data Source=NTSVR4;" & _
"Initial Catalog= cashier; User
ID = newapp; Password= newapp2005;")

com1 = New SqlCommand("Select cus_e_name from customer order by
cus_e_name", kn)
kn.Open()
kr = com1.ExecuteReader(CommandBehavior.CloseConnection )

Do While kr.Read()
u_name.Text = kr("cus_e_name")
u_name.Items.Add(u_name.Text)
Loop

kn.Close()
kr.Close()
--
Message posted via http://www.dotnetmonster.com

[Herfried K. Wagner [MVP]]

"Ivan V via DotNetMonster.com" <fo***@DotNetMonster.com> schrieb:

I just wrote a code for the combobox to show a list of supplier name from
the sql server. After running the code, it seems to take a least 6 to 10
seconds to activate the combobox, does anyone knows how to speed up the
process??

Where/when do you add the items to the combobox? How many items are you
displaying?

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Ivan V via DotNetMonster.com]

There are almost 10000 items in there and I add the combo box at the
load_form once the window form pops up.

Herfried K. Wagner [MVP] wrote:

I just wrote a code for the combobox to show a list of supplier name from
the sql server. After running the code, it seems to take a least 6 to 10
seconds to activate the combobox, does anyone knows how to speed up the
process??

Where/when do you add the items to the combobox? How many items are you
displaying?

--
Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/For...b-net/200507/1