Here??™s an example:
273
Part III: LINQ to SQL
try
{
int salesPersonID = Convert.ToInt32(textBox1.Text);
DataSet ds = new DataSet();
string connectionInfo = "Data Source=avalonserver;Initial Catalog=AdventureWorks;
Integrated Security=true";
SqlDataAdapter da = new SqlDataAdapter(
"SELECT SalesOrderID, OrderDate, " +
"SalesOrderNumber, SalesPersonID, ContactID, TotalDue " +
"FROM sales.salesorderheader " +
"WHERE SalesPersonID = @ID; " +
"SELECT od.SalesOrderID, od.SalesOrderDetailID, od.OrderQty, " +
"od.ProductID, od.UnitPrice, od.LineTotal " +
"FROM sales.salesorderdetail od " +
"INNER JOIN Sales.SalesOrderHeader oh ON od.SalesOrderID = oh.SalesOrderID " +
"WHERE oh.SalesPersonID = @ID; ", connectionInfo);
da.SelectCommand.Parameters.AddWithValue("@ID", salesPersonID);
da.TableMappings.Add("Table", "SalesOrderHeader");
da.TableMappings.Add("Table1", "SalesOrderDetail");
da.Fill(ds);
DataTable header = ds.Tables["SalesOrderHeader"];
DataTable detail = ds.Tables["SalesOrderDetail"];
DataRelation dr = new DataRelation("OrderHeaderDetail",
header.
Pages:
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441