I have a pair of databound combo boxes on my page. I am
quite unhappy with the time it takes to load them. Is
there a way to speed it up by coding it manually or
is .datasource, .valuemember .displaymember the best?

Thanks,
Aaron

What's the data source for your combobox?
How many records are you loading?

--
Alex Yakhnin .NET CF MVP
http://www.intelliprog.com
http://www.opennetcf.org


>-----Original Message-----
>I have a pair of databound combo boxes on my page. I am
>quite unhappy with the time it takes to load them. Is
>there a way to speed it up by coding it manually or
>is .datasource, .valuemember .displaymember the best?
>
>Thanks,
>Aaron
>.
>

I guess I forgot to ask you on how many records in the
table you're retreiving records from, but regardless make
sure that you have indexes on the fields you using in the
where clause.

-Alex

>-----Original Message-----
>The datasource is a datatable from the local SQL CE DB.
>I am loading about 100 max in each combo. Takes about 20-
>30 secs:
>
>mysql = "select '0' as id, ' --All-- ' as name from misc
>union select id, name from company where accessmfg=1 or
>alarmmfg=1 or cctvmfg=1 or firemfg=1 or powermfg=1 order
>by name"
> sqlCommand.CommandText = mysql
> sqlDA = New SqlCeDataAdapter(sqlCommand)
> sqlDA.Fill(sqlDS, "company")
>
> cmbCategory.DataSource = sqlDS.Tables(0)
> cmbCategory.DisplayMember = "proposalcategory"
> cmbCategory.ValueMember = "id"
>
> Me.cmbMfg.DataSource = sqlDS.Tables(1)
> cmbMfg.DisplayMember = "name"
> cmbMfg.ValueMember = "id"
>
>
>>-----Original Message-----
>>What's the data source for your combobox?
>>How many records are you loading?
>>
>>--
>>Alex Yakhnin .NET CF MVP
>>http://www.intelliprog.com
>>http://www.opennetcf.org
>>
>>
>>>-----Original Message-----
>>>I have a pair of databound combo boxes on my page. I
>am
>>>quite unhappy with the time it takes to load them. Is
>>>there a way to speed it up by coding it manually or
>>>is .datasource, .valuemember .displaymember the best?
>>>
>>>Thanks,
>>>Aaron
>>>.
>>>
>>.
>>
>.
>

Use a datareader, much much faster!

Private Function PopulateCombo1()

sbStatbar.Text = "Loading Comment Defaults"
sbStatbar.Refresh()

Dim strSQL As String = "Select Col1 FROM Table"
Dim cmdSelect As SqlCeCommand = New SqlCeCommand(strSQL,
MasterDBconnection)
cmdSelect.CommandType = CommandType.Text

Try
Dim dtr As SqlCeDataReader = cmdSelect.ExecuteReader
(CommandBehavior.Default)
While (dtr.Read()) ' Populate Comment type combo
cmbCombo1.Items.Add(dtr.GetString(0))
End While
dtr.Close()
dtr.Dispose()

Catch ex As SqlCeException
SQLCEFuncErrorName(ex)
End Try

sbStatbar.Text = "Combo Loaded."
sbStatbar.Refresh()

End Function