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"
Jignesh TrivediPosted May 7, 2013, 8:52 AM
if you want to combine two or more table result with in one object than you may use LINQ to Dataset join.
please refer below link it might help you.
http://msdn.microsoft.com/en-us/library/bb399415.aspx
and result you can assign to grid as a datasource.
hope this will help you.
Shankar MPosted May 7, 2013, 7:28 AM
I am not much Familiar with DataView. But hope this link might help you.
http://msdn.microsoft.com/en-us/library/4xz507ds.aspx