How Can Gridview1 Be Displayed Table1 And Table2 And Table3 :) Without Join Code

hello friend

i have table1 and table2 and table3..

i have category and product number and name of colums for per table

i want to do this.. select category from table1 where category= textbox1.text   and category from table2 where category= textbox1.text   and category from table 3 where category= textbox1.text 

and if there are category for per category colums of  per table, gridview should displayed  table1 and table2 and table2 in category and name and product number of colums:)

if there is category of coulums for table1, gridview should displayed just table1  in category and name and product number of colums:)

i want to 3 bind for gridview1 :) it should be without join because i dont need join..  columns name is same for tables but value of category is different but it can be same :)

cheers