Asp.net show data from multiple tables to single grdivwew

Question

Hi All I want to know how should I bind data from multiple tables (sql table) to a sigle gridview. There is no relation between those multuiple tables( I have to show data from 3 tables into single gridview).

Vijay Yadav · Answer

Hi.. Thanks for your reply. It is working fine when i have no primary key in any table but if i have priamry key then it is throwing below error Failed to enable constraints. One or more rows contain values violating non-null unique or foreign-key constraints. Because when it shows data from from 2nd table the primary key column of the 1st table get null value..hence it is throwing error.. Any idea how to solve it?

Senthilkumar · Answer

Please try the following and let me know. DataTable dtAll = new DataTable(); DataTable dtOne = LoadTable1(); DataTable dtTwo = LoadTable2(); DataTable dtThree = LoadTable3(); dtAll = dtOne.Copy(); dtAll.Merge(dtTwotrue); dtAll.Merge(dtThreetrue);