Querying across tables using Listview

Cort · February 26th, 2010, 08:06 PM

I know you can query across two tables using a template field but can you do that in a Listview?

Imar · February 27th, 2010, 06:30 AM

Hi there,

I am not sure what you're asking. You don't "query" with a TemplateField or a ListView. You only display data with them. Querying is typically done with a DataSource control or by setting the DataSource property. Queries used by these controls can use multiple tables and then a ListView or other data-bound control can display whatever you throw at it.

So, can you elaborate a bit about what you're trying to accomplish or what you're asking exactly?

Cheers,

Imar

Cort · February 27th, 2010, 10:29 PM

Yes, Actually I'm quite lost.

In the GridView, I remembered being able to use a template field and the eval statement to get data related to the original table I brought up; so with a Category table with a Product table linked to it using a foreign key I can use the foreign key to get data from the Product table (eval - catID.ProductName).

So I use Linq to capture all the fields (if I have my jargon right) from one table and then use Gridview to access a related table.

I know I was able to get to related tables in the Gridview but can't pull it off now. I need to figure out how that happened. Too bad I didn't keep an example.

Imar · February 28th, 2010, 05:17 AM

You can do the same in an ItemTemplate in the ListView. The ItemTemplate is like one big TemplateField.

So something like this inside the ItemTemplate would work:

<asp:Label ID="Label1" Text='<%# Eval("SomeColumn").ToString() + Eval("SomeOtherColumn").ToString() %>' runat="server"></asp:Label>

Hope this helps,

Imar

Cort · February 28th, 2010, 01:23 PM

Sweet. I thought it must capable of doing this - just couldn't find anything on it - looked all over the internet and in several books. Thanks!