DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["connstring"]);
SqlDataAdapter saSub = new SqlDataAdapter("select sb_id,sb_caption from tblSubarea order by sb_order",conn);
saSub.Fill(ds,"tblSubarea");SqlDataAdapter saBd = new SqlDataAdapter("select bd_id,bd_caption,bd_sy from tblBd order by bd_by",conn);
saBd.Fill(ds,"tblBd");ds.Relations.Add("myre",ds.Tables["tblSubarea"].Columns["sb_id"],ds.Tables["tblBd"].Columns["bod_sy"]);
parent.DataSource = ds.Tables["tblSubarea"].DefaultView;
Page.DataBind();conn.Close();"myre"里面有些什么?
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["connstring"]);
SqlDataAdapter saSub = new SqlDataAdapter("select sb_id,sb_caption from tblSubarea order by sb_order",conn);
saSub.Fill(ds,"tblSubarea");SqlDataAdapter saBd = new SqlDataAdapter("select bd_id,bd_caption,bd_sy from tblBd order by bd_by",conn);
saBd.Fill(ds,"tblBd");ds.Relations.Add("myre",ds.Tables["tblSubarea"].Columns["sb_id"],ds.Tables["tblBd"].Columns["bod_sy"]);
parent.DataSource = ds.Tables["tblSubarea"].DefaultView;
Page.DataBind();conn.Close();"myre"里面有些什么?
MSDN
DataRelationCollection.Add 方法 (String, DataColumn, DataColumn)
http://msdn2.microsoft.com/zh-CN/library/system.data.datarelation.aspx在 ADO.NET 数据集中浏览多个相关表:
http://www.microsoft.com/china/msdn/archives/library/dv_vstechart/html/vbtchNavigatingMultipleRelatedTablesInADONETDataset.asp