SANCHIT SHARMA
Active member
- Joined
- Jul 15, 2005
- Messages
- 38
- Programming Experience
- 10+
Dear jmcilhinney and kulrom,
I am having multiple comboboxes on Vb.Net windows form. In these comboboxes we are using both Displaymember and Valuemember. my query is : What the way i should adopt to make the things faster.
On load event of the form we have written
Dim Dread_LS_PR As OleDbDataReader = Nothing
Dread_LS_PR = OBJ_QRY_LS_MINEPR.ExecuteReader_Cmd("SELECT CD_CLIE.CLIEDescription,CD_CLIE.CLIEID FROM CD_CLIE WHERE (CD_CLIE.LOGICALDELETE = 0 OR ISNULL(CD_CLIE.LOGICALDELETE)) and (CD_CLIE.MERGED = 0 OR ISNULL(CD_CLIE.MERGED)) and not CD_CLIE.CLIEDescription Like '00%' ORDER BY CD_CLIE.CLIEDescription ;")
DT_CD_CLIE.Load(Dread_LS_PR)
This table pertains approx 10000 records.
Here C_Clieid is a combobox
C_CLIEID.DataSource = DT_CD_CLIE 'DS_LS_ACTI.Tables("Union_CD_CLIE")
C_CLIEID.DisplayMember = "CLIEDescription"
C_CLIEID.ValueMember = "CLIEID"
C_CLIEID.MaxDropDownItems = 10
C_CLIEID.SelectedIndex = -1
'finally implemented column headers
C_CLIEID.ShowColumnHeader = False
C_CLIEID.ShowColumns = True
C_CLIEID.MaxDropDownItems = 9
C_CLIEID.ForeColor = Color.DarkBlue
C_CLIEID.ColumnHeaderBorderStyle = Border3DStyle.RaisedInner Or Border3DStyle.SunkenOuter Or Border3DStyle.Adjust
C_CLIEID.AutoCompleteMode = System.Windows.Forms.AutoCompleteMode.SuggestAppend
C_CLIEID.AutoCompleteSource = System.Windows.Forms.AutoCompleteSource.ListItems
This is taking a good amount while Extracting data and population the Combobox.
Is there any faster way to do the same.
I am having multiple comboboxes on Vb.Net windows form. In these comboboxes we are using both Displaymember and Valuemember. my query is : What the way i should adopt to make the things faster.
On load event of the form we have written
Dim Dread_LS_PR As OleDbDataReader = Nothing
Dread_LS_PR = OBJ_QRY_LS_MINEPR.ExecuteReader_Cmd("SELECT CD_CLIE.CLIEDescription,CD_CLIE.CLIEID FROM CD_CLIE WHERE (CD_CLIE.LOGICALDELETE = 0 OR ISNULL(CD_CLIE.LOGICALDELETE)) and (CD_CLIE.MERGED = 0 OR ISNULL(CD_CLIE.MERGED)) and not CD_CLIE.CLIEDescription Like '00%' ORDER BY CD_CLIE.CLIEDescription ;")
DT_CD_CLIE.Load(Dread_LS_PR)
This table pertains approx 10000 records.
Here C_Clieid is a combobox
C_CLIEID.DataSource = DT_CD_CLIE 'DS_LS_ACTI.Tables("Union_CD_CLIE")
C_CLIEID.DisplayMember = "CLIEDescription"
C_CLIEID.ValueMember = "CLIEID"
C_CLIEID.MaxDropDownItems = 10
C_CLIEID.SelectedIndex = -1
'finally implemented column headers
C_CLIEID.ShowColumnHeader = False
C_CLIEID.ShowColumns = True
C_CLIEID.MaxDropDownItems = 9
C_CLIEID.ForeColor = Color.DarkBlue
C_CLIEID.ColumnHeaderBorderStyle = Border3DStyle.RaisedInner Or Border3DStyle.SunkenOuter Or Border3DStyle.Adjust
C_CLIEID.AutoCompleteMode = System.Windows.Forms.AutoCompleteMode.SuggestAppend
C_CLIEID.AutoCompleteSource = System.Windows.Forms.AutoCompleteSource.ListItems
This is taking a good amount while Extracting data and population the Combobox.
Is there any faster way to do the same.