DevForce Community Forum : Display data from two table http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Display data from two table Sat, 11 Apr 2026 16:17:07 -700 Fri, 27 Aug 2010 13:46:53 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2099 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Display data from two table : Sounds good. Glad I could help.... http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8250#8250 Author: DenisK
Subject: 2099
Posted: 27-Aug-2010 at 1:46pm

Sounds good. Glad I could help.]]> Fri, 27 Aug 2010 13:46:53 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8250#8250 Display data from two table : HiThanks very muchits working... http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8247#8247 Author: bala
Subject: 2099
Posted: 27-Aug-2010 at 12:27pm

Hi

Thanks very much

its working just need more figureout due to list.. but finally acheived result..

Thanks a Million..
]]> Fri, 27 Aug 2010 12:27:51 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8247#8247 Display data from two table : The EntityManager that you put... http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8245#8245 Author: DenisK
Subject: 2099
Posted: 27-Aug-2010 at 10:49am

The EntityManager that you put is your EntityManager assigned to your model. Please see my code sample below working with the NorthwindIB database that comes when you install your DevForce.

var _mgr = new NorthwindIBEntityManager();

var query2 = from employee in _mgr.Employees
                   join order in _mgr.Orders
                   on employee.EmployeeID equals order.EmployeeID
                   where employee.EmployeeID == 5
                   select new {
                     employee.EmployeeID,
                     employee.FirstName,
                     employee.LastName,
                     order.OrderID,
                     order.ShipCity
                   };

dataGrid.ItemsSource = query2.ToList();
]]> Fri, 27 Aug 2010 10:49:41 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8245#8245 Display data from two table : HiThis is still giving errorEn... http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8244#8244 Author: bala
Subject: 2099
Posted: 27-Aug-2010 at 10:43am

Hi

This is still giving error
EntityManager.Students

Error:Does not contrain the defination of Students and no extension method studen accepting first
arugment type 'Students.Model.StudentEntities

Still i am stucking on this..


Thanks
]]> Fri, 27 Aug 2010 10:43:24 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8244#8244 Display data from two table : I would rewrite your query like... http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8243#8243 Author: DenisK
Subject: 2099
Posted: 27-Aug-2010 at 10:35am

I would rewrite your query like this

var query2 = from STUDENT in EntityManager.Students
                             join SORDER in EntityManager.Sorders
                             on STUDENT.ID equals SORDER.SORDER_ID
                             select new
                             {
                                 STUDENT.ID,
                                 STUDENT.NAME,
                                 STUDENT.ADDRESS,
                                 SORDER.SORDER_ID,
                                 SORDER.OCITY
                             };

then assign it like this

DataGrid.ItemsSource = query2.ToList();

Please try that and let me know.
]]> Fri, 27 Aug 2010 10:35:42 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8243#8243 Display data from two table : I try to assing but giving errorThere... http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8239#8239 Author: bala
Subject: 2099
Posted: 27-Aug-2010 at 4:46am

I try to assing but giving error

There is no ExecuteAsync() for query2

query.Ex....



Do you know How can I assing with this query. I made query with lambda but they also have error
]]> Fri, 27 Aug 2010 04:46:46 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8239#8239 Display data from two table : Bala;Try assigning the grid's... http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8231#8231 Author: DenisK
Subject: 2099
Posted: 26-Aug-2010 at 5:01pm

Bala;

Try assigning the grid's ItemsSource to query2.ToList();
]]> Thu, 26 Aug 2010 17:01:37 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8231#8231 Display data from two table : HiI can displya record from single... http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8210#8210 Author: bala
Subject: 2099
Posted: 26-Aug-2010 at 9:55am

Hi
I can displya record from single table with this code

 var query = _mgr.STUDENTs;
query.ExecuteAsync(op => op.Results.ForEach(Students.Add));
   StudentGrid.ItemsSource = Students;

but I like to make join with another table and wanted to show data in single grid

for that i write this linq
var query2 = from STUDENT in Students
                             join SORDER in Sorders
                             on STUDENT.ID equals SORDER.SORDER_ID
                             select new
                             {
                                 STUDENT.ID,
                                 STUDENT.NAME,
                                 STUDENT.ADDRESS,
                                 SORDER.SORDER_ID,
                                 SORDER.OCITY
                             };
               
problem is I am not able to bind this query with datagrid

any help?
]]> Thu, 26 Aug 2010 09:55:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2099&PID=8210#8210