将数据集绑定到 html 表

本文关键字:html 绑定 数据集 | 更新日期: 2023-09-27 18:35:50

在下面的代码中,我有一个数据集和html表。就我而言,我有 25 个计数的数据集,我想将其绑定到 html 表,但它只绑定第一行。请帮我绑定所有行.

 MastersClient objIndent = new MastersClient();
                DataSet ds = objIndent.GetIndent(hidIndentID.Value);
                DataRow[] drIndentID = ds.Tables[0].Select("IndentID =" + hidIndentID.Value);
if (drIndentID.Length > 0)
                {  
//Count is 25
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                        {
                            txtQty.Value = drIndentID[i]["RecommentedQuantity"].ToString();
                            string strProductID = drIndentID[i]["ProductID"].ToString();
                            ddlProduct.Text = strProductID; 
                            txtDate.Text = drIndentID[i]["ProductRequiredDate"].ToString();
                        }
}


<table id="dataTable" width="350px" border="1" runat="server">
        <tr>
            <td><input id="checkbox" type="checkbox" name="chk" runat="server"/></td>
            <td><input type="text" name="txt" id="txtQty" runat="server"/></td>
            <td>
            <asp:DropDownList ID="ddlProduct" runat="server"  Style="width: 100%; height:23px" ></asp:DropDownList>   
            </td>
           <td>
           <asp:TextBox ID="txtDate" Style="text-align: left" onkeypress="return isNumberKey(event, false);"
                                                        onblur="DateValidation(this)" onkeyup="ValidateDate(this, event.keyCode)" onkeydown="return DateFormat(this, event.keyCode)"
                                                        Height="20px" runat="server" Width="80px"> </asp:TextBox>

           </td>
        </tr>
    </table>   

将数据集绑定到 html 表

Your aspx

<asp:Repeater ID="rptCategories" runat="server">
    <HeaderTemplate>
        <table id="dataTable" width="350px" border="1">
    </HeaderTemplate>
    <ItemTemplate>
       <tr>
            <td><input id="checkbox" type="checkbox" name="chk" runat="server"/></td>
            <td><input type="text" name="txt" id="txtQty" runat="server"/></td>
            <td>
            <asp:DropDownList ID="ddlProduct" runat="server"  Style="width: 100%; height:23px" >                </asp:DropDownList>   
            </td>
           <td>
           <asp:TextBox ID="txtDate" Style="text-align: left" onkeypress="return isNumberKey(event, false);"  onblur="DateValidation(this)" onkeyup="ValidateDate(this, event.keyCode)" onkeydown="return DateFormat(this, event.keyCode)"  Height="20px" runat="server" Width="80px"> </asp:TextBox>

           </td>
        </tr>
    </ItemTemplate>
    <FooterTemplate>
        </table>
    </FooterTemplate>
</asp:Repeater>

和代码隐藏

            MastersClient objIndent = new MastersClient();
            DataSet ds = objIndent.GetIndent(hidIndentID.Value);
            DataRow[] drIndentID = ds.Tables[0].Select("IndentID =" + hidIndentID.Value);
            if (drIndentID.Length > 0)
            { 
              rptCategories.DataSource=ds.Tables[0];
            }