Populate collection object with field names from SQL table?

[HillBilly]

I could use a little help on this seemingly arcane objective.

[zacks]

On Aug 11, 1:51*pm, "HillBilly" <[e-mail]:

I could use a little help on this seemingly arcane objective.

I am assuming you are using some flavour of Microsoft SQL.

There are a couple of ways I have heard of to get the column names
from SQL. If you are trying to get the column names from a table
without actually getting any data, you can run a select query on the
INFORMATION_SCHEMA.Columns view. But if you are running a select on a
table, say like a SELECT * ..., and you want the column names in the
resultset, you can use either the GetSchema method, or you can load
the data from a DataAdapter to a DataSet, and then to a DataTable,
where the DataTable object has a collection of Columns and it has a
Name property.

[HillBilly]

Thanks for the leads...

<za***@construction-imaging.comwrote in message
news:7a**********************************@m73g2000 hsh.googlegroups.com...
On Aug 11, 1:51 pm, "HillBilly" <[e-mail]:

I could use a little help on this seemingly arcane objective.

I am assuming you are using some flavour of Microsoft SQL.

There are a couple of ways I have heard of to get the column names
from SQL. If you are trying to get the column names from a table
without actually getting any data, you can run a select query on the
INFORMATION_SCHEMA.Columns view. But if you are running a select on a
table, say like a SELECT * ..., and you want the column names in the
resultset, you can use either the GetSchema method, or you can load
the data from a DataAdapter to a DataSet, and then to a DataTable,
where the DataTable object has a collection of Columns and it has a
Name property.

[HillBilly]

How To Retrieve Column Schema by Using the DataReader GetSchemaTable Method
and Visual C# .NET
http://support.microsoft.com/kb/310107
<za***@construction-imaging.comwrote in message
news:7a**********************************@m73g2000 hsh.googlegroups.com...
On Aug 11, 1:51 pm, "HillBilly" <[e-mail]:

I could use a little help on this seemingly arcane objective.

I am assuming you are using some flavour of Microsoft SQL.

There are a couple of ways I have heard of to get the column names
from SQL. If you are trying to get the column names from a table
without actually getting any data, you can run a select query on the
INFORMATION_SCHEMA.Columns view. But if you are running a select on a
table, say like a SELECT * ..., and you want the column names in the
resultset, you can use either the GetSchema method, or you can load
the data from a DataAdapter to a DataSet, and then to a DataTable,
where the DataTable object has a collection of Columns and it has a
Name property.