This sample shows different DataSet Loading Examples
public void DataSetLinq109() { var customers = testDS.Tables["Customers"].AsEnumerable(); var orders = testDS.Tables["Orders"].AsEnumerable(); var smallOrders = from c in customers from o in orders where c.Field<string>("CustomerID") == o.Field<string>("CustomerID") && o.Field<decimal>("Total") < 500.00M select new { CustomerID = (string)c["CustomerID"], OrderID = (int)o["OrderID"], Total = (decimal)o["Total"] }; DataTable myOrders = new DataTable(); myOrders.Columns.Add("CustomerID", typeof(string)); myOrders.Columns.Add("OrderID", typeof(int)); myOrders.Columns.Add("Total", typeof(decimal)); foreach (var result in smallOrders.Take(10)) { myOrders.Rows.Add(new object[] { result.CustomerID, result.OrderID, result.Total }); } PrettyPrintDataTable(myOrders); }
public void DataSetLinq109() { var customers = testDS.Tables["Customers"].AsEnumerable(); var orders = testDS.Tables["Orders"].AsEnumerable(); var smallOrders = from c in customers from o in orders where c.Field<string>("CustomerID") == o.Field<string>("CustomerID") && o.Field<decimal>("Total") < 500.00M select new { CustomerID = (string)c["CustomerID"], OrderID = (int)o["OrderID"], Total = (decimal)o["Total"] }; DataTable myOrders = new DataTable(); myOrders.Columns.Add("CustomerID", typeof(string)); myOrders.Columns.Add("OrderID", typeof(int)); myOrders.Columns.Add("Total", typeof(decimal)); foreach (var result in smallOrders.Take(10)) { myOrders.Rows.Add(new object[] { result.CustomerID, result.OrderID, result.Total }); } PrettyPrintDataTable(myOrders); }
For more information, see: