Select all the rows between comma separated field using Linq in ASP.Net

Hi nauna,

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

SQL

CREATE TABLE ProductTable
(
    ID INT PRIMARY KEY IDENTITY,
    Category VARCHAR(100),
    ProductName VARCHAR(100)
)

INSERT INTO ProductTable VALUES('Fashion, Men, Toys','Product A')
INSERT INTO ProductTable VALUES('Women, Fashion','Product B')
INSERT INTO ProductTable VALUES('Men, Kids','Product C')

HTML

Search by Category:
<asp:TextBox ID="txtcategory" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Search" OnClick="Button1_Click" />
<br />
<br />
<asp:GridView runat="server" ID="gvDetails" />

Code

C#

protected void Button1_Click(object sender, EventArgs e)
{
    TestEntities db = new TestEntities();
    List<Product> result = new List<Product>();
    for (int i = 0; i < txtcategory.Text.Trim().Split(',').Length; i++)
    {
        string cat = txtcategory.Text.Trim().Split(',')[i];
        var q = (from p in db.ProductTables
                    where p.Category.Contains(cat)
                    select new Product
                    {
                        Category = p.Category,
                        Name = p.ProductName
                    }).ToList();
        result.AddRange(q);

    }

    result = result.GroupBy(p => p.Name).Select(g => g.FirstOrDefault()).ToList();
    gvDetails.DataSource = result;
    gvDetails.DataBind();
}

public class Product
{
    public string Category { get; set; }
    public string Name { get; set; }
}

VB.Net

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs)
    Dim db As TestEntities = New TestEntities()
    Dim result As List(Of Product) = New List(Of Product)()

    For i As Integer = 0 To txtcategory.Text.Trim().Split(","c).Length - 1
        Dim cat As String = txtcategory.Text.Trim().Split(","c)(i)
        Dim q = (From p In db.ProductTables
                 Where p.Category.Contains(cat)
                 Select New Product With {
                    .Category = p.Category,
                    .Name = p.ProductName
                }).ToList()
        result.AddRange(q)
    Next

    result = result.GroupBy(Function(p) p.Name).Select(Function(g) g.FirstOrDefault()).ToList()
    gvDetails.DataSource = result
    gvDetails.DataBind()
End Sub

Public Class Product
    Public Property Category As String
    Public Property Name As String
End Class

Screenshot