Solved

JOIN queries VS DataRelation objects

Posted on 2007-04-02
1
717 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
1 Comment
 
LVL 3

Accepted Solution

by:
viveksg earned 250 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I have developed many web applications with asp & asp.net and to add and use a dropdownlist was always a very simple task, but with the new asp.net, setting the value is a bit tricky and its not similar to the old traditional method. So in this a…
In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

820 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