SLOW ddlistbox loading

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've used ddlistboxes before and had no problem but this one loads on the page load event and then takes a VERY long time to display. There are about 2000 records. Can anybody offer some advice on how i can make it more effiecent and speed up the process. I've tested the sql statement on the server and it works fine. Have a look and feel free to comment

ti

If Not IsPostBack The
Dim ds As New DataSe
Dim MyCommand As SqlDataAdapte
Dim strstg As String = "select * from dbo.vw_Subdivisions
MyCommand = New SqlDataAdapter(strstg, dbconn
MyCommand.Fill(ds, "propownerstbl"
cbosubdivision.DataTextField = ("sbd_desc"
cbosubdivision.DataValueField = ("sbd_desc"

cbosubdivision.DataSource = ds.Tables("propownerstbl"
cbosubdivision.DataBind(
cbosubdivision.Items(0).Text = "Select subdivision or T/R
dbconn.Close(
End If
 
Hi John,

Why you do
Dim strstg As String = "select * from dbo.vw_Subdivisions"
Click to expand...

if you are using only the field sbd_desc? and not
"select sbd_desc from dbo.vw_Subdivisions"
 
Back
Top