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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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