Filter ASP.Net GridView using LINQ to SQL in C# and VB.Net

Hi Rezu2215,

Refer below sample.

HTML

Name :
<asp:TextBox runat="server" ID="txtName" />
<br />
<asp:Button ID="Button1" Text="Search" runat="server" OnClick="Search" />
<asp:GridView ID="gvCustomers" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="CustomerId" HeaderText="CustomerId" />
        <asp:BoundField DataField="Name" HeaderText="Name" />
        <asp:BoundField DataField="Country" HeaderText="Country" />
    </Columns>
</asp:GridView>

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        TestEntities test = new TestEntities();
        var query = (from c in test.Customers select c);
        gvCustomers.DataSource = query;
        gvCustomers.DataBind();
    }
}

protected void Search(object sender, EventArgs e)
{
    TestEntities test = new TestEntities();
    var query = (from c in test.Customers
                    where c.Name.Contains(txtName.Text)
                    select c);

    gvCustomers.DataSource = query;
    gvCustomers.DataBind();
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim test As TestEntities = New TestEntities()
        Dim query = (From c In test.Customers Select c)
        gvCustomers.DataSource = query
        gvCustomers.DataBind()
    End If
End Sub

Protected Sub Search(ByVal sender As Object, ByVal e As EventArgs)
    Dim test As TestEntities = New TestEntities()
    Dim query = (From c In test.Customers Where c.Name.Contains(txtName.Text) Select c)
    gvCustomers.DataSource = query
    gvCustomers.DataBind()
End Sub

Screenshot