Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: VB6
Expertise: beginner
Feb 19, 2000

Dynamically bind a DataList or DataCombo control to an ADO Recordset

When dynamically changing the bound ADORecordset for a DataCombo or DataList control, the order you follow when assigning the properties is important. This is the correct sequence of operations to perform to change the bound recordset for these controls:


' unbind the current sources
Set DataCombo1.DataSource = Nothing
Set DataCombo1.RowSource = Nothing

' set the new binding - start with the string properties
DataCombo1.DataField = "ProductID"    ' the bound field in master table
DataCombo1.BoundColumn = "ID"         ' the bound field in detail table
DataCombo1.ListField = "ProductName"  ' the display field in detail table
Set DataCombo1.RowSource = rsProducts ' the detail table
Set DataCombo1.DataSource = rsOrder   ' the master table

Francesco Balena
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap