我用Reapter控件,如何将数据库里字段的值赋给一个变量呢?能这样写吗
<% aa=Container.DataItem("id")%>

解决方案 »

  1.   

    <asp:Repeater id="myrepeater" runat="server">
         <ItemTemplate>
              <table width="760" border="1" align="center" cellpadding="0" cellspacing="0" bgcolor="#CBFCDB">
                    <tr align="certer"><td><a href="#">
                 <ItemTemplate> 
              <asp:Label runat="server"
                Text='<%#DataBinder.Eval(Container.DataItem,"mainname")%>'/></ItemTemplate>
                  <br>
                    </a></td></tr>
            <p><p>
            <ItemTemplate>
            <tr><td>
            <%# DataBinder.Eval(Container.DataItem,"subname")%> //subname
            </td><td align="right">版主:<a href="#">
            <%# DataBinder.Eval(Container.DataItem,"banzhu")%>
    <asp:Repeater id="myrepeater" runat="server">
         <ItemTemplate>
              <table width="760" border="1" align="center" cellpadding="0" cellspacing="0" bgcolor="#CBFCDB">
                    <tr align="certer"><td><a href="#">
                 <ItemTemplate> 
              <asp:Label runat="server"
                Text='<%#DataBinder.Eval(Container.DataItem,"mainname")%>'/></ItemTemplate>
                  <br>
                    </a></td></tr>
            <p><p>
            <ItemTemplate>
            <tr><td>
            <%# DataBinder.Eval(Container.DataItem,"subname")%> 
            </td><td align="right">版主:<a href="#">
            <%# DataBinder.Eval(Container.DataItem,"banzhu")%><asp:Repeater id="myrepeater" runat="server">
         <ItemTemplate>
              <table width="760" border="1" align="center" cellpadding="0" cellspacing="0" bgcolor="#CBFCDB">
                    <tr align="certer"><td><a href="#">
                 <ItemTemplate> 
              <asp:Label runat="server"
                Text='<%#DataBinder.Eval(Container.DataItem,"mainname")%>'/></ItemTemplate>
                  <br>
                    </a></td></tr>
            <p><p>
            <ItemTemplate>
            <tr><td>
            <%# DataBinder.Eval(Container.DataItem,"subname")%> 
            </td><td align="right">版主:<a href="#">
            <%# DataBinder.Eval(Container.DataItem,"banzhu")%>//subname、mainname、banzhu是数据库里的字段
    --------------------------------------------------------------// 后台代码参考:
          String strMain2="select * from mainboards inner join subboards on (subboards.mainid=mainboards.mainid)";
            OleDbDataAdapter a=new OleDbDataAdapter(strMain2,cn);
            DataSet ds=new DataSet();
           a.Fill(ds,"mainboards");
           a.SelectCommand.CommandText="select * from subboards";
           a.Fill(ds,"subboards"); 
           myrepeater.DataSource=ds.Tables["mainboards"].DefaultView;
           myrepeater.DataBind();
           cn.Close();
      

  2.   

    <asp:Repeater id="myrepeater" runat="server">
         <ItemTemplate>
                 <ItemTemplate> 
              <asp:Label runat="server"
                Text='<%#DataBinder.Eval(Container.DataItem,"mainname")%>'/></ItemTemplate>
              <ItemTemplate>      
            <%# DataBinder.Eval(Container.DataItem,"subname")%>       
            <%# DataBinder.Eval(Container.DataItem,"banzhu")%><asp:Repeater id="myrepeater" runat="server">
         <ItemTemplate>   
                 <ItemTemplate> 
              <asp:Label runat="server"
                Text='<%#DataBinder.Eval(Container.DataItem,"mainname")%>'/></ItemTemplate>
             <ItemTemplate>
             <%# DataBinder.Eval(Container.DataItem,"subname")%> 
            <%# DataBinder.Eval(Container.DataItem,"banzhu")%>//subname、mainname、banzhu是数据库里的字段
    --------------------------------------------------------------// 后台代码参考:
          String strMain2="select * from mainboards inner join subboards on (subboards.mainid=mainboards.mainid)";
            OleDbDataAdapter a=new OleDbDataAdapter(strMain2,cn);
            DataSet ds=new DataSet();
           a.Fill(ds,"mainboards");
           a.SelectCommand.CommandText="select * from subboards";
           a.Fill(ds,"subboards"); 
           myrepeater.DataSource=ds.Tables["mainboards"].DefaultView;
           myrepeater.DataBind();
           cn.Close();