Populating a list box with variable names from LINQ generated class

Question

I'm quite new to Visual Basic - using Visual Studio 2008 and can't seem to find a way to do the following:

I have a few tables in a SQL Server database and have used LINQ to SQL to create classes of those tables.

Here's a cut down example of what I'd like: listbox1 filled with table names - APS, SMPS, WCPC, CFLAPS Then from the SelectedIndexChanged event, listbox2 should populate column headers of the selected table.

I have no issues getting data from the database, and can access all of these headers through the anonymous type objects created from a LINQ query (eg APS.ID, APS.count etc), but populating a listbox with these variable names rather than the data inside them seems rather elusive.

This is probably a cross platform coding question rather than VB specific, so if you have a solution in C# or whatever I'd be happy if you could let me know.

Anthony · Accepted Answer · 2009-11-17 00:35:45Z

1

What I would suggest is using reflection to find the name of each property. I found this C# example you may find useful.

edited Nov 17, 2009 at 0:35

answered Nov 17, 2009 at 0:26

Anthony

1,7191 gold badge20 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mahesh Velaga Over a year ago

In my opinion also, Reflection is the way to go !

Alexandra Rusina · Accepted Answer · 2009-11-17 18:58:03Z

0

What you probably need here is to analyze an expression tree. Basically, if you have a LINQ to SQL query, you get an IQueryable object that has the "expression" property. This property should provide you the info about your anonymous types and their properties. Here is a good starting point for you (yes, it's written for C#, but it works for VB as well): http://blogs.msdn.com/charlie/archive/2008/01/31/expression-tree-basics.aspx

answered Nov 17, 2009 at 18:58

Alexandra Rusina

11.3k2 gold badges23 silver badges17 bronze badges

Collectives™ on Stack Overflow

Populating a list box with variable names from LINQ generated class

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related