Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

JOIN queries VS DataRelation objects

Posted on 2007-04-02
1
Medium Priority
?
720 Views
Last Modified: 2008-01-09
When do you use JOIN queries and when do you use DataRelation objects when working with Gridview?
0
Comment
Question by:VBdotnet2005
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 3

Accepted Solution

by:
viveksg earned 750 total points
ID: 18841442
If u want to query parent-child tables and simply display it in gridview, use join. I mean fetch the values from db trhu an SP using JOIN.
Datarelation is used when u have a dataset with dift tables. That means, two tables with parent table values and child table values. Now u can use datarelation to show it in grid view. To make it clear, think u r displaying a list of questions in a page, and u want to display the answer just below it when a user clicks on the question. In these type of scenarios, u can use data relation.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question