DataList嵌套,新手问题

[zhangxian_gege]

........ 已绑定List1,并且可以正常运行
绑定List2时，查询语句需要调用List1的CatalogID列，请问是这样调用的吗？


<!--产品类别列表开始-->
<asp:datalist id="List1" Runat="server">
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "[CatalogName]","{0}") %>
<!--小类别开始-->
<%
SqlDataAdapter myCommand3 = new SqlDataAdapter("select * from Products_Catalog where depth=1 and parentid='"+DataBinder.Eval(Container.DataItem, "[Catalogid]","{0}").ToString()+"' order by RootID", myConnection);
DataSet ds3= new DataSet();
myCommand3.Fill(ds3, "Titles");
List2.DataSource = ds3.Tables["Titles"].DefaultView;
List2.DataBind();
%>
<asp:datalist id="List2" BorderWidth="0" Runat="server" GridLines="Vertical">
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "[CatalogName]","{0}")%>
</ItemTemplate>
</asp:DataList>
<!---小类别结束--->
</ItemTemplate>
</asp:datalist></TD>
<!--产品类别列表结束-->

[jimu8130]

怎么后台代码和前台混在一起写了

[jimu8130]

<!--小类别开始-->
<%
SqlDataAdapter myCommand3 = new SqlDataAdapter("select * from Products_Catalog where depth=1 and parentid='"+DataBinder.Eval(Container.DataItem, "[Catalogid]","{0}").ToString()+"' order by RootID", myConnection);
DataSet ds3= new DataSet();
myCommand3.Fill(ds3, "Titles");
List2.DataSource = ds3.Tables["Titles"].DefaultView;
List2.DataBind();
%>
把这段代码应该放在datalist1的itemdatabound事件里面

[zhangxian_gege]

请问在SQL查询语句中是这样引用的吗？

[xuyiazl]

没连到数据库