mocaiv
asked on
VB.Net - Loading large amounts of data into a combobox.
Hello,
I have a VB.Net application in which I have several comboboxes on a form that contain a large about of data, about 13,000 rows each. The query which retrieves the data is very fast. Here is an example of my code that populates 8 combo boxes.
dsDxs = cCSharedFunction.getDx()
dsDX1 = dsDxs.Copy()
dsDX2 = dsDxs.Copy()
dsDX3 = dsDxs.Copy()
dsDX4 = dsDxs.Copy()
With UcDx1.cmbDX1
.DataSource = dsDX1.Tables(0)
.DisplayMember = "Dx"
.ValueMember = "Description"
End With
With UcDx1.cmbDX1Desc
.DataSource = dsDX1.Tables(0)
.DisplayMember = "Description"
.ValueMember = "Dx"
End With
With UcDx1.cmbDX2
.DataSource = dsDX2.Tables(0)
.DisplayMember = "Dx"
.ValueMember = "Description"
End With
With UcDx1.cmbDX2Desc
.DataSource = dsDX2.Tables(0)
.DisplayMember = "Description"
.ValueMember = "Dx"
End With
With UcDx1.cmbDX3
.DataSource = dsDX3.Tables(0)
.DisplayMember = "Dx"
.ValueMember = "Description"
End With
With UcDx1.cmbDX3Desc
.DataSource = dsDX3.Tables(0)
.DisplayMember = "Description"
.ValueMember = "Dx"
End With
With UcDx1.cmbDX4
.DataSource = dsDX4.Tables(0)
.DisplayMember = "Dx"
.ValueMember = "Description"
End With
With UcDx1.cmbDX4Desc
.DataSource = dsDX4.Tables(0)
.DisplayMember = "Description"
.ValueMember = "Dx"
End With
Any help to speed up the load of these controls would be greatly appreciated.
Thanks in advance.
I have a VB.Net application in which I have several comboboxes on a form that contain a large about of data, about 13,000 rows each. The query which retrieves the data is very fast. Here is an example of my code that populates 8 combo boxes.
dsDxs = cCSharedFunction.getDx()
dsDX1 = dsDxs.Copy()
dsDX2 = dsDxs.Copy()
dsDX3 = dsDxs.Copy()
dsDX4 = dsDxs.Copy()
With UcDx1.cmbDX1
.DataSource = dsDX1.Tables(0)
.DisplayMember = "Dx"
.ValueMember = "Description"
End With
With UcDx1.cmbDX1Desc
.DataSource = dsDX1.Tables(0)
.DisplayMember = "Description"
.ValueMember = "Dx"
End With
With UcDx1.cmbDX2
.DataSource = dsDX2.Tables(0)
.DisplayMember = "Dx"
.ValueMember = "Description"
End With
With UcDx1.cmbDX2Desc
.DataSource = dsDX2.Tables(0)
.DisplayMember = "Description"
.ValueMember = "Dx"
End With
With UcDx1.cmbDX3
.DataSource = dsDX3.Tables(0)
.DisplayMember = "Dx"
.ValueMember = "Description"
End With
With UcDx1.cmbDX3Desc
.DataSource = dsDX3.Tables(0)
.DisplayMember = "Description"
.ValueMember = "Dx"
End With
With UcDx1.cmbDX4
.DataSource = dsDX4.Tables(0)
.DisplayMember = "Dx"
.ValueMember = "Description"
End With
With UcDx1.cmbDX4Desc
.DataSource = dsDX4.Tables(0)
.DisplayMember = "Description"
.ValueMember = "Dx"
End With
Any help to speed up the load of these controls would be greatly appreciated.
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.