how to use join query in dataset with foreach

Question

how to use join query in dataset with foreach loop how to show through foreach loop

Prasanth Radhakrishnan · Answer

Try this. // Fill the DataSet . DataSet ds = new DataSet(); ds.Locale = CultureInfo.InvariantCulture; FillDataSet(ds); DataTable products = ds.Tables[Product]; var query = products.AsEnumerable(). Select(product => new { ProductName = product.Field (Name) ProductNumber = product.Field (ProductNumber) Price = product.Field (ListPrice) }); Console.WriteLine(Product Info:); foreach (var productInfo in query) { Console.WriteLine(Product name: {0} Product number: {1} List price: ${2}  productInfo.ProductName productInfo.ProductNumber productInfo.Price); } Reference : https://msdn.microsoft.com/en-us/library/bb552415(v=vs.110).aspx