Extract values from comma separated string using C# and VB.Net in ASP.Net

Hi georgeacuster,

Please refer below sample.

HTML

<asp:GridView ID="gvData" runat="server">
</asp:GridView>

Namespace

C#

using System.Data;

VB.Net

Imports System.Data

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    string items = "Dispatching System,proposal,to be sent,main,2022-006,related,2022-017,related";
    List<string> value1 = items.Split(',').ToList();
    DataTable dt = new DataTable();
    dt.Columns.Add("t");
    dt.Columns.Add("q");
    for (int i = 4; i < value1.Count; i++)
    {
        dt.Rows.Add(value1[i], value1[i + 1]);
        i++;
    }
    gvData.DataSource = dt;
    gvData.DataBind();
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    Dim items As String = "Dispatching System,proposal,to be sent,main,2022-006,related,2022-017,related"
    Dim value1 As List(Of String) = items.Split(","c).ToList()
    Dim dt As DataTable = New DataTable()
    dt.Columns.Add("t")
    dt.Columns.Add("q")

    For i As Integer = 4 To value1.Count - 1
        dt.Rows.Add(value1(i), value1(i + 1))
        i += 1
    Next

    gvData.DataSource = dt
    gvData.DataBind()
End Sub

Screenshot