Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 3.5 > ASP.NET 3.5 Professionals
| Search | Today's Posts | Mark Forums Read
ASP.NET 3.5 Professionals If you are an experienced ASP.NET programmer, this is the forum for your 3.5 questions. Please also see the Visual Web Developer 2008 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 3.5 Professionals section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old March 7th, 2009, 07:06 PM
Authorized User
 
Join Date: Jun 2003
Location: , , .
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default Advanced Data Query and Databinding

I have the following situation. I have two data sources of different types that I need to join.

The first data source is a direct database query, I'd like to use Linq for. Each row has a DocId column.

The other data source is an array of Document objects that is returned from a web service call. Each Document has an array of properties. Each property is a key-value pair.

I want to join the first datasource's DocId column on each Document object's property with a key of DocId. I then want to bind a datagrid to the resulting data source.

One, can I even do this? Can I combine LinqToObjects with LinqToSQL like this? Must I convert my Document objects from having an array of key-value propeties to having named properties, especially since I need to bind the resulting data to a datagrid?

i.e.
<Property name="DocId" value="1001" />
into
<DocId>1001</DocId>


Similar Threads
Thread Thread Starter Forum Replies Last Post
Query data and exporting data from one sheet to an testman Excel VBA 2 April 28th, 2005 02:40 PM
Chapter 14, Advanced Data Handling Techniques ou812 BOOK: Beginning ASP 3.0 3 May 14th, 2004 02:05 PM
Databinding with an inner join Louisa VB.NET 2002/2003 Basics 2 December 12th, 2003 04:57 AM
Please Help with advanced sql query mstuart60 SQL Language 1 June 22nd, 2003 03:19 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.