how to use join query in dataset with foreach

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