How to join multiple table in dataset [Resolved]

http://msdn.microsoft.com/en-US/library/d6s958d6(v=VS.80).aspx

Go through this link , will definitely help you

Thanks,
Sanjay

Alok, if this helps please login to Mark As Answer. | Alert Moderator

Hello,

If so u can use LINQ then follow this method.
using this u can combine any number of tables.

var result = from table1 in dt1.AsEnumerable()
join table2 in dt2.AsEnumerable() on (int)table1["ID"] equals (int)table2["ID"]
join table3 in dt3.AsEnumerable() on (int)table2["ID"] equals (int)table3["ID"]
select new
{
ID=(int)table1["ID"],
Name=(string)table1["EmployeeName"],
Department=(string)table2["Department"],
Salary=(string)table3["Salary"]
};

Regards,
Ogipansrk

Alok, if this helps please login to Mark As Answer. | Alert Moderator

try it sir select * from product p left outer join price pr on p.proid=pr.proid left outer join quantity q on p.proid=q.proid

gowthaman8870226416

Alok, if this helps please login to Mark As Answer. | Alert Moderator

https://forums.asp.net/t/1708173.aspx/1?how+can+i+inner+join+tables+within+DATASET+

Refer to this link.

Thanks,
Sanjay

Alok, if this helps please login to Mark As Answer. | Alert Moderator

How can you write this query in dataset..

Thanks & Regards,
Alokssm

Alok, if this helps please login to Mark As Answer. | Alert Moderator

If I Have only two tables then i can create The relationship..But How to perform This Relation If We Have More Than Two Tables..

Thanks & Regards,
Alokssm

Alok, if this helps please login to Mark As Answer. | Alert Moderator

There is a way but it is not a good idea. I always say to people, let SQL so SQL and let .NET Framework Manupilate Object. This should be done in a stored procedure and when the data comes should be ready for the app to consume.

Thank you for posting at Dotnetfunda
[Administrator]

Alok, if this helps please login to Mark As Answer. | Alert Moderator

Thanks Sksamantaray..It really works

Thanks & Regards,
Alokssm

Alok, if this helps please login to Mark As Answer. | Alert Moderator

Hi Vuyiswamb , Can You Explain Me Another Approach Too..

Thanks & Regards,
Alokssm

Alok, if this helps please login to Mark As Answer. | Alert Moderator

Pleae refer this link

http://forums.asp.net/t/1126203.aspx/1

Alok, if this helps please login to Mark As Answer. | Alert Moderator