Filter data in datagridview by using a textbox in VB.NET

Question

1.00/5 (1 vote)

See more:

Hi Everyone , please someone can tell me if there is a way to filter data from datagridview using a Textbox ?

thank you.

What I have tried:

Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
        Dim str As String = "Data Source=;Initial Catalog=user;Persist Security Info=True;User ID=sa;Password="
        Dim con As New SqlConnection(str)
        Dim com As String = "Select DATE ,Login ,Operation ,Nbr_docs ,tps_traite ,moy_doc_hr ,moy_sec_doc ,taux_err   from AWB_CHQ_RETOUR "
        Dim Adpt As New SqlDataAdapter(com, con)
        Dim ds As New DataSet()
        Adpt.Fill(ds, "AWB_CHQ_RETOUR")
        DataGridView1.DataSource = ds.Tables(0)
    End Sub <pre>

this is the code I use to poulate the DatagridView , and I have six buttons similar to this , that populate my datagrid from other tables .

Posted 22-May-17 1:39am

Member 13191952

Updated 22-May-17 7:47am

v4

Add a Solution

2 solutions

Solution 1

Yes there is.

Research material from Google[^]

[EDIT - here is a link to the MSDN documentation Building a Drop-Down Filter List for a DataGridView Column Header Cell[^]

Posted 22-May-17 1:53am

CHill60

Updated 22-May-17 3:17am

v2

Comments

Member 13191952 22-May-17 8:03am

Really ! ohhhh

CHill60 22-May-17 8:07am

Yes, really. This is not a code-writing service.
The 2nd link from that list takes you to Filter Columns Value in DataGridView - Visual Basic .NET[^] which explicitly filters data from datagridview using a Textbox - which is apparently what you want to do.

Member 13191952 22-May-17 8:08am

I already seen that but I don't want to use an sql command in the textbox , I want just to filter what is displaying in the DataGridview

Member 13191952 22-May-17 8:05am

I already seen that but I don't want to use an sql command in the textbox , I want just to filter what is displaying in the DataGridview

CHill60 22-May-17 8:09am

"I already seen that" - There are 173,000 results on that link!
You don't have to read them all. The 2nd link uses the .Filter method.

Member 13191952 22-May-17 8:15am

but int the textbox they use select from a table and I don't want to use is what I want is just filtering displayed data in the gridview Directly

CHill60 22-May-17 8:24am

No they do not. They use

source1.Filter = "[Item Code] = '" & TextBox1.Text & "'"

Source1 is the binding source for the datagridview. That is how you filter a datagridview.

Member 13191952 22-May-17 9:33am

I understand but Iam binding the Datagridview from differents button wich are related to different tables in my database , so how can I specify the Binding source

CHill60 22-May-17 9:41am

I edited my solution with a link to a complete solution

Member 13191952 22-May-17 9:54am

it's not what I want , my datagrid is not binding from a datasource , I use many sql command to bind it , so when I compilate I don't have already columns until I click on a button

CHill60 22-May-17 9:57am

Tell you what, why don't you use the Improve question link to post the code you use to populate the DataGridView because I can't guess what your problem is

Member 13191952 22-May-17 10:19am

I update it

Maciej Los 22-May-17 13:47pm

Google is always good alternative.

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2017-05-22T07:47:00

There's few ways to achieve that:
1) using filter on DataSet/DataTable through the Select[^] method.
See:
Filtering and Sorting in Datasets[^]
How to: Filter and Sort Directly in Data Tables[^]

2) using Filter method[^] for BindingSource (Caroline - CHill60[^] already mentioned about that method)

3) using SqlCommand to grab filtered data from database
You have to use the same code as you use to populate data to DataGridView. The only differ is in SELECT statement.

SQL

SELECT DATE ,Login ,Operation ,Nbr_docs ,tps_traite ,moy_doc_hr ,moy_sec_doc ,taux_err
from AWB_CHQ_RETOUR
WHERE Login = 'SomeLoginHere'

4) using Linq to DataSet[^]
See:
LINQ to DataSet Examples[^]
101 LINQ Samples in C#[^]
Creating a DataTable From a Query (LINQ to DataSet)[^]

VB.NET

DataTable dt = DirectCast(DataGridView1.DataSource, DataTable)
Dim qry = dt.AsEnumerable() _
  .Where(Function(x) x.Field(Of String)("Login")="SomeLoginHere")
Dim boundTable As DataTable = qry.CopyToDataTable
DataGridView1.DataSource = boundTable

Filter data in datagridview by using a textbox in VB.NET

2 solutions

Solution 1

Solution 4

Add your solution here

Preview 0

Filter data in datagridview by using a textbox in VB.NET

2 solutions

Solution 1

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us