将数据集绑定到 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>
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];
}