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

[Cor Ligthert]

Klaus,

I made a strongly typed dataset and retrieved the columns names from it,
what do you mean with a strongly typed dataset?

Only the first part is the sample how to do it, I needed a strongly typed
dataset to show, therefore I made the most simple one I could make.

Cor

"Klaus Jensen"

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

For me the answer you describe stays the same as the first
See this
I hope this helps anyway?

I am afraid you do not understand, what I want to accomplish... I am not
sure how I can explain it differently...

The code you show me generates a dataset. I want code that dynamicly
examines any strong typed dataset, and generates some code/text from the
columns, that are in the strong typed dataset.

I really don't know how I can explain it differently... But I appreciate
your effort to help me. :)

- Klaus

[james]

Klaus, maybe, the following link will give you some ideas:

http://www.smithvoice.com/vbfun.htm

On the left side bar select: VB.NET and then DB Copier.net
There is a program there that generates code from a database. He will send you the source code ot his program if you email him
directly. Maybe this is what you are looking for.
james


"Klaus Jensen" <CurseThemNasty Spammers!> wrote in message news:uv******** ******@tk2msftn gp13.phx.gbl...

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

For me the answer you describe stays the same as the first
See this
I hope this helps anyway?

I am afraid you do not understand, what I want to accomplish... I am not
sure how I can explain it differently...

The code you show me generates a dataset. I want code that dynamicly
examines any strong typed dataset, and generates some code/text from the
columns, that are in the strong typed dataset.

I really don't know how I can explain it differently... But I appreciate
your effort to help me. :)

- Klaus

[james]

Klaus, maybe, the following link will give you some ideas:

http://www.smithvoice.com/vbfun.htm

On the left side bar select: VB.NET and then DB Copier.net
There is a program there that generates code from a database. He will send you the source code ot his program if you email him
directly. Maybe this is what you are looking for.
james


"Klaus Jensen" <CurseThemNasty Spammers!> wrote in message news:uv******** ******@tk2msftn gp13.phx.gbl...

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

For me the answer you describe stays the same as the first
See this
I hope this helps anyway?

I am afraid you do not understand, what I want to accomplish... I am not
sure how I can explain it differently...

The code you show me generates a dataset. I want code that dynamicly
examines any strong typed dataset, and generates some code/text from the
columns, that are in the strong typed dataset.

I really don't know how I can explain it differently... But I appreciate
your effort to help me. :)

- Klaus

[David]

On 2004-11-12, Klaus Jensen <> wrote:

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

You give me more and more the idea that you have a only a string
"Mydata.Mystron glytypeddataset " and absolute nothing more and want to make
from that a strongly typed dataset. I assume that I am wrong?.
Yes, you misunderstand me. I'll try explaining it again. :)

I already have a strong typed dataset. It is located in the MyData-namespace
and is called Mystronglytyped dataset.
Lets say the dataset has a table SomeTable with two columns:
- ID (integer)
- Name (string)

In an empty class I write this...:

Class MyBusinessClass

Private _mydataset as MyData.Mystrong lytypeddataset
Private _mydatarow as MyData.Mystrong lytypeddataset. SomeTable

End Class

Next step is, I mark the line "Private _mydatarow as
MyData.Mystrong lytypeddataset. SomeTable" and run a macro, which examines the
strong typed dataset and generates code, so the class now looks like this:

Reflection isn't what you want. Reflection will only work on a compiled
assembly, and that isn't what you have.

The easiest solution here is to simply find the relevant XML file.
Don't worry about the class or the class code for the typed dataset,
find the appropriate xml file in the project and it's trivial to use an
xpath to parse out the columns in any specific table.




Public Class MyBusinessClass

Private _mydataset as MyData.Mystrong lytypeddataset
Private _mydatarow as MyData.Mystrong lytypeddataset. SomeTable 'mark this
row and run the macro

Public Property ID() As Integer
Get
Return _mydatarow.ID
End Get
Set(ByVal Value As Integer)
_mydatarow.ID = Value
End Set
End Property

Public Property Name() As String
Get
Return _mydatarow.Name
End Get
Set(ByVal Value As String)
_mydatarow.Name = Value
End Set
End Property

End Class

I hope this shows, what I have in mind. :)

[David]

On 2004-11-12, Klaus Jensen <> wrote:

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

You give me more and more the idea that you have a only a string
"Mydata.Mystron glytypeddataset " and absolute nothing more and want to make
from that a strongly typed dataset. I assume that I am wrong?.
Yes, you misunderstand me. I'll try explaining it again. :)

I already have a strong typed dataset. It is located in the MyData-namespace
and is called Mystronglytyped dataset.
Lets say the dataset has a table SomeTable with two columns:
- ID (integer)
- Name (string)

In an empty class I write this...:

Class MyBusinessClass

Private _mydataset as MyData.Mystrong lytypeddataset
Private _mydatarow as MyData.Mystrong lytypeddataset. SomeTable

End Class

Next step is, I mark the line "Private _mydatarow as
MyData.Mystrong lytypeddataset. SomeTable" and run a macro, which examines the
strong typed dataset and generates code, so the class now looks like this:

Reflection isn't what you want. Reflection will only work on a compiled
assembly, and that isn't what you have.

The easiest solution here is to simply find the relevant XML file.
Don't worry about the class or the class code for the typed dataset,
find the appropriate xml file in the project and it's trivial to use an
xpath to parse out the columns in any specific table.




Public Class MyBusinessClass

Private _mydataset as MyData.Mystrong lytypeddataset
Private _mydatarow as MyData.Mystrong lytypeddataset. SomeTable 'mark this
row and run the macro

Public Property ID() As Integer
Get
Return _mydatarow.ID
End Get
Set(ByVal Value As Integer)
_mydatarow.ID = Value
End Set
End Property

Public Property Name() As String
Get
Return _mydatarow.Name
End Get
Set(ByVal Value As String)
_mydatarow.Name = Value
End Set
End Property

End Class

I hope this shows, what I have in mind. :)