Add distinct Row to DataTable and display in ASP.Net GridView using C# and VB.Net

Hi comunidadmexi...,

Check this example. Now please take its reference and correct your code.

HTML

<asp:GridView runat="server" ID="gvitems" AutoGenerateColumns="false" OnRowDataBound="gvProducts_RowDataBound">
    <Columns>
        <asp:TemplateField HeaderText="Header1">
            <ItemTemplate>
                <asp:Label ID="lblContents" Text='<%#Eval("contents") %>' runat="server" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Header2">
            <ItemTemplate>
                <asp:Label ID="lblSIDContents" Text='<%#Eval("sID_contents") %>' runat="server" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Header3" >
            <ItemTemplate>
                <asp:Label ID="lblSUnita" Text='<%#Eval("sUnita") %>' runat="server" />
                <asp:ImageButton ID="imgAdd" runat="server" OnClick="ImageButton1_Click" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Header4">
            <ItemTemplate>
                <asp:Label ID="lblSID" Text='<%#Eval("sID") %>' runat="server" />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Namespaces

C#

using System.Data;
using System.Linq;

VB.Net

Imports System.Data
Imports System.Linq

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        GetData();
        BindGrid();
    }
}

protected void gvProducts_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        string lbset = (string)DataBinder.Eval(e.Row.DataItem, HttpUtility.HtmlDecode("contents"));
        ImageButton image = e.Row.FindControl("imgAdd") as ImageButton;
        image.ImageUrl = "img/add-page-red.png";
        image.ToolTip = "Add new row to " + HttpUtility.HtmlDecode(lbset)
            .ToString()
            .Replace("<h4><strong>", "")
            .Replace("</strong></h4>", "");
        image.Visible = lbset.ToString().StartsWith("- Set ");
    }
}

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
    ImageButton image = sender as ImageButton;
    GridViewRow row = image.NamingContainer as GridViewRow;

    DataTable dt = ViewState["Data"] as DataTable;
    DataRow dr = dt.NewRow();
    string[] contents = (row.FindControl("lblContents") as Label).Text.Split('.');
    dr["contents"] = string.Format("New row Thread {0}", contents.Length > 1 ? contents[1] : contents[0]);
    dr["sID_contents"] = (row.FindControl("lblSIDContents") as Label).Text;
    dr["sUnita"] = (row.FindControl("lblSUnita") as Label).Text;
    dr["sID"] = dt.Rows.Count + 1;
    dt.Rows.Add(dr);

    ViewState["Data"] = dt;

    BindGrid();
}

private void BindGrid()
{
    gvitems.DataSource = (ViewState["Data"] as DataTable).AsEnumerable().OrderBy(x => x["sID_contents"]).CopyToDataTable();
    gvitems.DataBind();
}

private DataTable GetData()
{
    DataTable dt = new DataTable();
    dt.Columns.AddRange(new DataColumn[]
    {
        new DataColumn("contents"),
        new DataColumn("sID_contents"),
        new DataColumn("sUnita"),
        new DataColumn("sID")
    });

    dt.Rows.Add("- Set n.1", 1, "D1C", 1);
    dt.Rows.Add("Management", 1, "D1C", 2);
    dt.Rows.Add("Miss", 1, "D1C", 3);

    dt.Rows.Add("- Set n.2", 2, "D1C", 4);
    dt.Rows.Add("Management 2", 2, "D1C", 5);
    dt.Rows.Add("Miss 2", 2, "D1C", 6);

    dt.Rows.Add("- Set n.3", 3, "D1C", 7);
    dt.Rows.Add("Management 3", 3, "D1C", 8);
    dt.Rows.Add("Miss 3", 3, "D1C", 9);

    ViewState["Data"] = dt;

    return dt;
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        GetData()
        BindGrid()
    End If
End Sub

Protected Sub gvProducts_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
    If e.Row.RowType = DataControlRowType.DataRow Then
        Dim lbset As String = CStr(DataBinder.Eval(e.Row.DataItem, HttpUtility.HtmlDecode("contents")))
        Dim image As ImageButton = TryCast(e.Row.FindControl("imgAdd"), ImageButton)
        image.ImageUrl = "img/add-page-red.png"
        image.ToolTip = "Add new row to " & HttpUtility.HtmlDecode(lbset) _
                        .ToString() _
                        .Replace("<h4><strong>", "") _
                        .Replace("</strong></h4>", "")
        image.Visible = lbset.ToString().StartsWith("- Set ")
    End If
End Sub

Protected Sub ImageButton1_Click(ByVal sender As Object, ByVal e As ImageClickEventArgs)
    Dim image As ImageButton = TryCast(sender, ImageButton)
    Dim row As GridViewRow = TryCast(image.NamingContainer, GridViewRow)
    Dim dt As DataTable = TryCast(ViewState("Data"), DataTable)
    Dim dr As DataRow = dt.NewRow()
    Dim contents As String() = (TryCast(row.FindControl("lblContents"), Label)).Text.Split("."c)
    dr("contents") = String.Format("New row Thread {0}", If(contents.Length > 1, contents(1), contents(0)))
    dr("sID_contents") = TryCast(row.FindControl("lblSIDContents"), Label).Text
    dr("sUnita") = TryCast(row.FindControl("lblSUnita"), Label).Text
    dr("sID") = dt.Rows.Count + 1
    dt.Rows.Add(dr)
    ViewState("Data") = dt
    BindGrid()
End Sub

Private Sub BindGrid()
    gvitems.DataSource = TryCast(ViewState("Data"), DataTable).AsEnumerable() _
                        .OrderBy(Function(x) x("sID_contents")) _
                        .CopyToDataTable()
    gvitems.DataBind()
End Sub

Private Function GetData() As DataTable
    Dim dt As DataTable = New DataTable()
    dt.Columns.AddRange(New DataColumn() {
                        New DataColumn("contents"),
                        New DataColumn("sID_contents"),
                        New DataColumn("sUnita"),
                        New DataColumn("sID")})
    dt.Rows.Add("- Set n.1", 1, "D1C", 1)
    dt.Rows.Add("Management", 1, "D1C", 2)
    dt.Rows.Add("Miss", 1, "D1C", 3)
    dt.Rows.Add("- Set n.2", 2, "D1C", 4)
    dt.Rows.Add("Management 2", 2, "D1C", 5)
    dt.Rows.Add("Miss 2", 2, "D1C", 6)
    dt.Rows.Add("- Set n.3", 3, "D1C", 7)
    dt.Rows.Add("Management 3", 3, "D1C", 8)
    dt.Rows.Add("Miss 3", 3, "D1C", 9)
    ViewState("Data") = dt
    Return dt
End Function

Screenshot