One dataview from dataset but two table

Question

Hi can i use this way Dim dv as New DataView=Dataset(select * from table1table2 where table1.id=tablel2.id)

Manoj Patel · Answer

Dear Venkata Query is not a big issue big issue is there the dataset is not support such a query string type i think. I always use as Dim Dv as New DataView =dataset(tablename) for one table at a time but i have problem that i want to data in a dataview from two table which is stored in dataset

venkata kumar · Answer

hi use this way Dim dv as New DataView=Dataset(select * from table1 t1 inner join table2 on t1.id=t2.id)