Dear Experts,
I am working in wpf with vb.net
I have a global dataset, in this dataset having more then 10 tables,
one table one dataview is working fine as 'Dim dv as New DataView(DataSet("tblname"))'
but problem is there i want create a dataview from two tables
tables as
citymst(citycode, cityname)
Clientmst(cname,caddress,ccitycode)
i want to display in a datagrid
name,address, cityname
how to write code for dataview as below query
"select name,address, cityname from clientmst, citymst where citycode=ccitycode"