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();