DataList嵌入绑定DataList

最新推荐文章于 2024-04-30 22:06:17 发布

zjy1985cool

最新推荐文章于 2024-04-30 22:06:17 发布

阅读量406

点赞数 2

文章标签： dataset webform server asp xhtml html

本文链接：https://blog.csdn.net/zjy1985cool/article/details/3391926

版权

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm2.aspx.cs" Inherits="OfficeChannel.CourseChannel.WebForm2" %>
<%@ Import Namespace="System.Data" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
    <head>
        <title>NestedDataLists</title>
    </head>
    <body>
        <form id="Form2" method="post" runat="server">
        <asp:DataList ID="Parent" runat="server" Height="134px" Width="133px">
                <ItemTemplate>
                <asp:Label ID="Label1" runat="server" Text='<%# Eval("QUES") %>' Font-Bold="True" ForeColor="Red"></asp:Label>
                      


                    <asp:DataList ID="Child" runat="server" datasource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("Myrelations") %>' ForeColor="Green">
                        <ItemTemplate>
                            <%# DataBinder.Eval(Container.DataItem, "[/"AN/"]")%>
                        </ItemTemplate>
                    </asp:DataList>


                </ItemTemplate>
            </asp:DataList>
        </form>
    </body>
</html>

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

namespace OfficeChannel.CourseChannel
{
    public partial class WebForm2 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            String connStr = ConfigurationManager.ConnectionStrings["OfficeChannelConnectionString_Web"].ConnectionString; //读取WEB.CONFIG连接字符串
            SqlConnection conn = new SqlConnection(connStr);
            SqlDataAdapter SqlDa1 = new SqlDataAdapter("select * from Question", conn); //遍历问题表
            SqlDataAdapter SqlDa2 = new SqlDataAdapter("select * from Answer", conn);//遍历回答表
            DataSet ds = new DataSet();
            SqlDa1.Fill(ds, "Question");
            SqlDa2.Fill(ds, "Answer");
            ds.Relations.Add("Myrelations", ds.Tables["Question"].Columns["QuestionOrder"], ds.Tables["Answer"].Columns["QuestionOrder"]); //为两个表建立关联
            Parent.DataSource = ds.Tables["Question"];//父DataList绑定源

            Page.DataBind();//绑定
            conn.Close();
        }
    }
}

zjy1985cool

关注

2
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
DataList嵌入绑定DataList

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> NestedDataLists Font-Bold="True" ForeColor="Red">
复制链接

扫一扫