Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 3.5 > ASP.NET 3.5 Professionals
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #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>
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 06:25 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.