Deterimine columns of dataset from code - reflection?

[Klaus Jensen]

Hi!

How do I explore in code, which properties (columns) are in a datatable? I
need to run some code for each column.

I guess the answer is reflection somehow, but I dont know where to start.

If someone could point me to a relevant example, I would be most grateful.
:)

Thanks in advance

- Klaus

[Nigel Armstrong]

Hi Klaus...

Reflection isn't necessary in this case - the DataSet / DataTable /
DataColumn object model is sufficient...

Code:

For Each t As DataTable In Me.DataSet1.Tab les
MessageBox.Show (t.TableName)
For Each c As DataColumn In t.Columns
MessageBox.Show (c.ColumnName)
Next
Next

HTH

Nigel Armstrong

"Klaus Jensen" wrote:

Hi!

How do I explore in code, which properties (columns) are in a datatable? I
need to run some code for each column.

I guess the answer is reflection somehow, but I dont know where to start.

If someone could point me to a relevant example, I would be most grateful.
:)

Thanks in advance

- Klaus

[Nigel Armstrong]

Hi Klaus...

Reflection isn't necessary in this case - the DataSet / DataTable /
DataColumn object model is sufficient...

Code:

For Each t As DataTable In Me.DataSet1.Tab les
MessageBox.Show (t.TableName)
For Each c As DataColumn In t.Columns
MessageBox.Show (c.ColumnName)
Next
Next

HTH

Nigel Armstrong

"Klaus Jensen" wrote:

Hi!

How do I explore in code, which properties (columns) are in a datatable? I
need to run some code for each column.

I guess the answer is reflection somehow, but I dont know where to start.

If someone could point me to a relevant example, I would be most grateful.
:)

Thanks in advance

- Klaus

[Cor Ligthert]

Klaus,

Why everybody wants the last times to do latebinding for things which are
free to get at design time, it seems for me if the word "reflection " has
something magical.

To get all columns from a datatable than this is enough

\\\
Public Module main
Public Sub main()
Dim dt As New DataTable
dt.Columns.Add( "Klaus")
dt.Columns.Add( "Cor")
For Each dc As DataColumn In dt.Columns
MessageBox.Show (dc.ColumnName)
Next
End Sub
End Module
///

I hope this helps?

Cor

"Klaus Jensen" <CurseThemNasty Spammers!>

Hi!

How do I explore in code, which properties (columns) are in a datatable? I
need to run some code for each column.

I guess the answer is reflection somehow, but I dont know where to start.

If someone could point me to a relevant example, I would be most grateful.
:)

Thanks in advance

- Klaus

[Cor Ligthert]

Klaus,

Why everybody wants the last times to do latebinding for things which are
free to get at design time, it seems for me if the word "reflection " has
something magical.

To get all columns from a datatable than this is enough

\\\
Public Module main
Public Sub main()
Dim dt As New DataTable
dt.Columns.Add( "Klaus")
dt.Columns.Add( "Cor")
For Each dc As DataColumn In dt.Columns
MessageBox.Show (dc.ColumnName)
Next
End Sub
End Module
///

I hope this helps?

Cor

"Klaus Jensen" <CurseThemNasty Spammers!>

Hi!

How do I explore in code, which properties (columns) are in a datatable? I
need to run some code for each column.

I guess the answer is reflection somehow, but I dont know where to start.

If someone could point me to a relevant example, I would be most grateful.
:)

Thanks in advance

- Klaus

[Klaus Jensen]

"Cor Ligthert" <no************ @planet.nl> wrote in message
news:%2******** **********@TK2M SFTNGP09.phx.gb l...

Why everybody wants the last times to do latebinding for things which are
free to get at design time, it seems for me if the word "reflection " has
something magical.

I should have explained what I wanted to do more specific...

I need to write a macro, which generates code based on the dataset. Ie I
need to mark the dataset (MyData.MyReall yStrongTypedDat aset) and then write
code, which examines the dataset columns, and then generates a template
class exposing each column as a property.

I hope this makes sense, if not, ask me to explain myself again. :)

- Klaus

[Klaus Jensen]

"Cor Ligthert" <no************ @planet.nl> wrote in message
news:%2******** **********@TK2M SFTNGP09.phx.gb l...

Why everybody wants the last times to do latebinding for things which are
free to get at design time, it seems for me if the word "reflection " has
something magical.

I should have explained what I wanted to do more specific...

I need to write a macro, which generates code based on the dataset. Ie I
need to mark the dataset (MyData.MyReall yStrongTypedDat aset) and then write
code, which examines the dataset columns, and then generates a template
class exposing each column as a property.

I hope this makes sense, if not, ask me to explain myself again. :)

- Klaus

[Cor Ligthert]

Klaus,

When you use the standard by VBNet generated strongly typed dataset, you can
forever reach the base dataclass from which it inherits.

However I cannot find for you how that is done in your
MyData.MyReally StrongTypedData set

In fact is Nigel showing to you when you have that base dataset, how you can
do it. I saw his sample after that I had sand mine.

Cor

[Cor Ligthert]

Klaus,

When you use the standard by VBNet generated strongly typed dataset, you can
forever reach the base dataclass from which it inherits.

However I cannot find for you how that is done in your
MyData.MyReally StrongTypedData set

In fact is Nigel showing to you when you have that base dataset, how you can
do it. I saw his sample after that I had sand mine.

Cor

[Klaus Jensen]

"Cor Ligthert" <no************ @planet.nl> wrote in message
news:eG******** ******@TK2MSFTN GP14.phx.gbl...

In fact is Nigel showing to you when you have that base dataset, how you
can do it. I saw his sample after that I had sand mine.

Maybe I am missing a point, but I still dont know how to come from the
string "Mydata.MyStron gtypedDataset" to an object of that type. When I have
the dataset as a correctly typed dataset, Nigels og your code is great for
displaying all columns... But the first part - I still dont know. :-S

- Klaus