Column names in Dataset

microsoft.public.dotnet.languages.vb

26 Jan 2006 5:23 PM

tshad

Where do I find the column names in a datatable that you get back from an
Sql Select statement, such as Select * from table?

If I had a Dataset as:

Dim ds as dataset

ds.Table(0).?

Thanks,

Tom

26 Jan 2006 5:27 PM

Cor Ligthert [MVP]

Tom,

ds.Table(0).columns(x).Columnname

I hope this helps,

Cor

27 Jan 2006 2:43 AM

tshad

"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:%23CCi$2pIGHA.3984@TK2MSFTNGP14.phx.gbl...
> Tom,
>
> ds.Table(0).columns(x).Columnname

That was what I was looking for. I was actually looking at intellisense to
try to figure it out, but I didn't see Columnname. Maybe I was having a
little brain fade.

Thanks,

Tom
Show quoteHide quote

>
> I hope this helps,
>
> Cor
>