Manoj Patel

Manoj Patel

  • NA
  • 26
  • 14.9k

dataview from two dataset tables

May 7 2013 5:14 AM

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"



Answers (2)