If I have a form with multiple combo boxes and a few list boxes, is there a way to create custom query sources for each one
It would appear that I have to create a query view for each control, even though only this one form will be using it. I'm thinking along the lines of how MS Access can have a custom SQL for each control.
Custom Queries for Combo and Listboxes
Hot Topic
VS Express Editions
- VB express and web service
- Printing in VB! .. No one has tought me!
- How to create a playlist?
- How to make radio buttons in a groupbox unchecked when form loads?
- Help to Convert ASCII to UTF-8 - Should be Simple
- Setting AutoScroll bar's width, height and position
- Newb Question: Opening Forms inside main form
- killing a process in task manager
- First Project
- socket programming... linker error
Custom Queries for Combo and Listboxes
Sudheer_Dhulipalla_MSFT
Reijo Tervonen
protected Function GetTable(byval sql as string) as DataTable
using myconn as new OleDbConnection(myConString)
using myDa as new OleDbDataAdapter(sql,myConn)
Dim dt as new DataTable()
myDa.Fill(dt)
return dt
end using
end using
end Function
usage:
MyCombo.DataSource = GetTable("select items from mytable")
MyCombo.DisplayMember = "items"
MyCombo.ValueMember = "items"