DataList 实现主细表

显示带有主次结构的数据可以通过DataRelation 类来建立，该类使用指定名称、父级和子级DataColumn 对象以及指示是否要创建约束的值，初始化新实例。

DataRelation(string relationName, DataColumn parentColumn, DataColumn childColumn, bool createConstraints

参数：

relationName:关系名称，此参数如果为空引用（Visual Basic 中为Nothing) 或空字符串（""),则当创建的对象添加到DataRelationCollection 时，将指定一个默认名称。

parentColumn:关系中的父级 DataColumn。

childColumn:关系中的子级 DataColumn。

createConstraints:指示是否要创建约束的值。如果要创建约束，则为true；否则为false。

< asp:DataList  ID ="DataListBook"  Runat ="server"  CellPadding ="0"  CellSpacing ="0" >
                                     < ItemTemplate >
                                         < table >
                                             < tr >
                                                 < td >
                                                     <% ... #DataBinder.Eval(Container.DataItem,"EditionName") %>
                                                    -- <% ... #DataBinder.Eval(Container.DataItem,"SubjectName") %>
                                                 </ td >
                                             </ tr >
                                             < tr >
                                                 < td >
                                                     < asp:DataList  ID ="DataListBookContent"  Runat =server  DataSource ='<%#  ((System.Data.DataRowView)Container.DataItem).CreateChildView("BookPublish") % > '>
                                                         < ItemTemplate >
                                                             <% ... #DataBinder.Eval(Container.DataItem,"Name") %>
                                                         </ ItemTemplate >
                                                     </ asp:DataList >
                                                 </ td >
                                             </ tr >
                                         </ table >
                                     </ ItemTemplate >
                                 </ asp:DataList >

 使用下面代码为子DataList动态指定数据源。

DataSource='<%# ((System.Data.DataRowView)Container.DataItem).CreateChildView("BookPublish") %>'>

后台代码：

/**/ /// <summary>
        /// 根据年级、版本、科目查询  所有书本
        /// </summary>
        /// <param name="gradeID">年级</param>
        /// <param name="editionid">版本</param>
        /// <param name="subjectid">科目</param>
        /// <returns></returns>
         public  DataSet GetBook( int  gradeID, int  editionid, int  subjectid)
         ... {
            try
            ...{
                SqlParameter [] parameters = ...{
                                                 new SqlParameter("@GradeId",SqlDbType.Int),
                                                 new SqlParameter("@editionid",SqlDbType.Int),
                                                 new SqlParameter("@subjectid",SqlDbType.Int)                                                 
                                             };
                parameters[0].Value = gradeID;
                parameters[1].Value = editionid;
                parameters[2].Value = subjectid;
                ds = Sxy.Site.BaseClass.SxyDataAccessBase.RunProcedure("Sxy_GetBooksByGES_Page",parameters,"ds1");
                ds.Tables[0].TableName = "EditionList";
                ds.Tables[1].TableName = "BookList";
                ds.Relations.Add("BookPublish",ds.Tables["EditionList"].Columns["pkid"],ds.Tables["BookList"].Columns["pkid"]);
                return ds;
            }
            catch(System.Exception er)
            ...{
                throw er;
            }
        }

web层数据绑定：

DataListBook.DataSource = ds.Tables["EditionList"].DefaultView;
DataListBook.DataBind();

或：

DataListBook.DataSource = ds;
DataListBook.DataBind();