asp.net²Ù×÷Êý¾Ý¿âÏà¹Ø[µ¼Èë]

ʹÓÃDataRelationÀà´´½¨¹Øϵ²¢ÀûÓø¸/×Ó¹Øϵ¶ÁÈ¡Êý¾ÝʾÀý
 void Page_Load(object sender, System.EventArgs e)
{
// Á¬½Ó×Ö·û´®ºÍ SQL Óï¾ä
string ConnString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];
string Sql = "SELECT * from Customers; SELECT * from Orders";
// ´´½¨ Connection ºÍ DataAdapter ¶ÔÏó
SqlConnection myConn = new SqlConnection(ConnString);
SqlDataAdapter sqlAdapter = new SqlDataAdapter(Sql, myConn);
// Ìî³äÊý¾Ý
DataSet dataSet = new DataSet();
sqlAdapter.Fill(dataSet, "Table");
// ÃüÃû±íÃû
dataSet.Tables[0].TableName = "Customers";
dataSet.Tables[1].TableName = "Orders";

// ´´½¨ Customers ºÍ Orders µÄ¸¸/×Ó±í¹Øϵ
dataSet.Relations.Add("CustomersOrders", dataSet.Tables["Customers"].Columns["CustomerID"],
dataSet.Tables["Orders"].Columns["CustomerID"]);
// ʹÓà GetChildRows() ·½·¨±éÀú×ÓÐÐ
foreach(DataRow custRow in dataSet.Tables["Customers"].Rows)
{
myLabel.Text += "<b>Parent Row: " + custRow["CustomerID"] + "  " + custRow["CompanyName"] + "</b><br>";
myLabel.Text += "Child Row: <br>";
foreach(DataRow orderRow in custRow.GetChildRows("CustomersOrders"))
{
myLabel.Text += "     " + orderRow["OrderID"] + "  " + orderRow["EmployeeID"] + "<br>";
}
}
}

½«DataSetµÄ¸Ä¶¯¸üлØSQL ServerÊý¾Ý¿â
// Á¬½Ó×Ö·û´®¼° SQL Óï¾ä
string ConnString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionSqlServer"];
string Sql = "SE