首页 > 代码库 > 移除GridView中的重复项
移除GridView中的重复项
1. The HTML Markup
<div> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" HeaderStyle-BackColor="#3AC0F2" HeaderStyle-ForeColor="White"> <Columns> <asp:BoundField DataField="Id" HeaderText="Id" ItemStyle-Width="30" /> <asp:BoundField DataField="Name" HeaderText="Name" ItemStyle-Width="150" /> <asp:BoundField DataField="City" HeaderText="City" ItemStyle-Width="150" /> </Columns> </asp:GridView> <br /> <asp:Button ID="btnRemove" runat="server" Text="Remove Duplicates" OnClick="btnRemove_Click" /> </div>
2. 绑定GridView的方法
public void BindGridview() { DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Id"), new DataColumn("Name"), new DataColumn("City") }); dt.Rows.Add(1, "John Hammond", "United States"); dt.Rows.Add(1, "John Hammond", "United States"); dt.Rows.Add(2, "Mudassar Khan", "India"); dt.Rows.Add(2, "Mudassar Khan", "India"); dt.Rows.Add(3, "Suzanne Mathews", "France"); dt.Rows.Add(3, "Suzanne Mathews", "France"); dt.Rows.Add(3, "Suzanne Mathews", "France"); dt.Rows.Add(4, "Robert Schidner", "Russia"); dt.Rows.Add(4, "Robert Schidner", "Russia"); dt.Rows.Add(4, "Robert Schidner", "Russia"); dt.Rows.Add(4, "Robert Schidner", "Russia"); ViewState["dt"] = dt; GridView1.DataSource = dt; GridView1.DataBind(); } 3. 移除重复项的方法
public void RemoveDuplicateReords() { DataTable dt = (DataTable)ViewState["dt"]; dt = dt.DefaultView.ToTable(true, "Id", "Name", "City"); GridView1.DataSource = dt; GridView1.DataBind(); }更多的详细信息，请访问下面的链接
http://www.aspsnippets.com/Articles/Remove-Delete-Duplicate-Rows-Records-from-DataTable-using-C-and-VBNet.aspx
移除GridView中的重复项
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。