Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

adodc control

hi there

i have a adodc cmdtext query that runs the following query

"select * From table1 Where not exists (select * From table2 Where table1.path = table2.path)"

how would i get the results from this to list them in a listbox

please help, this is my only problem i have then my project would be finished

lol

many thanks in advance and thanks to all that help me so often
and those of you that try , thank you too

Rob
[485 byte] By [Spumbu1977] at [2007-11-11 7:46:03]
# 1 Re: adodc control
If you're displaying multiple columns the following code should help:

http://www.freevbcode.com/ShowCode.asp?ID=3680

You won't be able to provide any formatting if you bind directly to the ADODC from a ListBox control when multiple columns are used. A DataGrid would be more appropriate for data binding in this instance.
pclement at 2007-11-11 17:26:24 >