--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP www.betav.com/blog/billva www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
No, because there is no way to get a recordset in ADONET and therefore as
well not a string from it.
The most nearest equivalent of a recordset is a datatable. That you can get
as Bill mentioned with a DataAdapter.Fill, however the datatable are
collections of objects, not values, therefore AFAIK have you to build your
own string or collection of those.
You could use a DataReader object to come close to what you need below.
The only difference will be that you will be responsible for concatenating
the column values yourself rather than have one fuction that does it for
you.
In such concatenation use StringBuilder rather than System.String.