Using table as cmbo rowsource in .NET
Posted on 2009-04-08
I'm trying to select a couple of columns from a table to display in a combo box.
VBA would be something like me.cbobox.rowsource = "Select something from somewhere"
It's been a WHILE since I've played around with .NET or even VB6 - just trying to get refreshed on some simple functions!
I'm thinking something like:
sSQL = "SELECT EmpID FROM Employees"
me.cboCustodian.rowsource? = sSQL
not exactly of course... Also... What is the method of defining the bound column? I know that you can't specify how many colums are in a combo box or list box in VB or .NET it just displays however many you specify in your select statement.
All help greatly appreciated!!!!