数据表如下 id parentid name 1 0 分类1
2 1 标题1
3 1 标题2
4 0 分类2
5 4 标题3
6 4 标题4
7 4 标题5
想要实现的效果 分类1
标题1
标题2
分类2
标题3
标题4
标题5我想实现以上的效果,看网上的例子都是用pubs库里的authors和titleauthor这两个表来演示的。我这也测试通过了!可是我现在需要在同一个表里操作,却总提示父列和子列不具有类型匹配的列。请教一下,该怎么建立父子关系?我很菜,请说的详细一点,或例子完整些,谢谢了!aspx:
<asp:repeater id="parentRepeater" runat="server">
<itemtemplate> <%# DataBinder.Eval(Container.DataItem, "[\"name\"]")%>
<asp:repeater id="childRepeater" runat="server" DataSource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("relation") %>'>
<itemtemplate>
<%# DataBinder.Eval(Container.DataItem, "[\"name\"]")%>
</itemtemplate>
</asp:repeater> </itemtemplate>
</asp:repeater> cs: public void Page_Load(object sender, EventArgs e)
{
// 为Authors表创建 Connection 和 DataAdapter
SqlConnection cnn = new SqlConnection("server=(local);database=xiaoym;uid=sa;pwd=;");
SqlDataAdapter cmd1 = new SqlDataAdapter("select * from forums where layer='0'",cnn); //创建填充 DataSet.
DataSet ds = new DataSet();
cmd1.Fill(ds,"authors"); // 为Titles表创建 DataAdapter
SqlDataAdapter cmd2 = new SqlDataAdapter("select * from forums where parentid!='0'",cnn);
cmd2.Fill(ds,"titles"); // 创建 Authors 表和 Titles 表之间的关系.
ds.Relations.Add("relation",
ds.Tables["authors"].Columns["fid"],
ds.Tables["titles"].Columns["parentid"]); // 绑定Authors到父Repeater
parentRepeater.DataSource = ds.Tables["authors"];
Page.DataBind(); cnn.Close();
cnn.Dispose();
}
2 1 标题1
3 1 标题2
4 0 分类2
5 4 标题3
6 4 标题4
7 4 标题5
想要实现的效果 分类1
标题1
标题2
分类2
标题3
标题4
标题5我想实现以上的效果,看网上的例子都是用pubs库里的authors和titleauthor这两个表来演示的。我这也测试通过了!可是我现在需要在同一个表里操作,却总提示父列和子列不具有类型匹配的列。请教一下,该怎么建立父子关系?我很菜,请说的详细一点,或例子完整些,谢谢了!aspx:
<asp:repeater id="parentRepeater" runat="server">
<itemtemplate> <%# DataBinder.Eval(Container.DataItem, "[\"name\"]")%>
<asp:repeater id="childRepeater" runat="server" DataSource='<%# ((DataRowView)Container.DataItem).Row.GetChildRows("relation") %>'>
<itemtemplate>
<%# DataBinder.Eval(Container.DataItem, "[\"name\"]")%>
</itemtemplate>
</asp:repeater> </itemtemplate>
</asp:repeater> cs: public void Page_Load(object sender, EventArgs e)
{
// 为Authors表创建 Connection 和 DataAdapter
SqlConnection cnn = new SqlConnection("server=(local);database=xiaoym;uid=sa;pwd=;");
SqlDataAdapter cmd1 = new SqlDataAdapter("select * from forums where layer='0'",cnn); //创建填充 DataSet.
DataSet ds = new DataSet();
cmd1.Fill(ds,"authors"); // 为Titles表创建 DataAdapter
SqlDataAdapter cmd2 = new SqlDataAdapter("select * from forums where parentid!='0'",cnn);
cmd2.Fill(ds,"titles"); // 创建 Authors 表和 Titles 表之间的关系.
ds.Relations.Add("relation",
ds.Tables["authors"].Columns["fid"],
ds.Tables["titles"].Columns["parentid"]); // 绑定Authors到父Repeater
parentRepeater.DataSource = ds.Tables["authors"];
Page.DataBind(); cnn.Close();
cnn.Dispose();
}
<ItemTemplate >
<span style ="font-weight :bold "><%#Eval ("pname") %></span>
<ul>
<asp:Repeater ID="detal" runat ="server" DataSource ='<%#GetCity(Eval("pid").ToString()) %>'>
<ItemTemplate >
<li><%#Eval("city_name") %></li>
</ItemTemplate>
</asp:Repeater>
</ul>
</ItemTemplate>
</asp:repeater>
重点:DataSource ='<%#Getawd(Eval("pid").ToString()) %>' 调用GetCity方法获取子类protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
BindGrid();
}
//获取大类的类别
protected void BindGrid()
{
string cmdText = "select pid, pname from pro";
DataTable dt = vc.GetDataTable(cmdText );
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
//获取小类内容
protected DataTable GetCity(string id)
{
string cmdText = "select city_name from city where promo_id = " + id + "";
DataTable dt = vc.GetDataTable(cmdText);
return dt;
}方法二:在第一个Repeater的ItemDataBound事件中绑定第二个Repeater,HTML代码中第一个Repeater不赋予DataSource
protected void repeatTitle_ItemDataBound(object sender, RepeaterItemEventArgs e)
{ DataRowView dr = (DataRowView)e.Item.DataItem;
DataTable mydt = GetCity(dr[0].ToString());
if (mydt.Rows.Count > 0)
{
Repeater myRepeat = (Repeater)e.Item.FindControl("repeatCont");
myRepeat.DataSource = mydt;
myRepeat.DataBind();
mydt.Dispose();
}
else
{
e.Item.Visible = false; //没有数据时不显示
}
}
protected void BindGrid()
{
string cmdText = "select * from forums";
DataTable dt = vc.GetDataTable(cmdText);
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
//获取小类内容
protected DataTable GetCity(string id)
{
string cmdText = "select * from forums where parentid = " + id + "";
DataTable dt = vc.GetDataTable(cmdText);
return dt;
}