Filtering a DataGridView

[furjaw]

Visual Basic.Net:

I have a DataGridView in Last Name sequence.
Is it possible to when a user types the first letter of a last name
that it displays all rows with last names that start with that letter.
When he types the second letter, it displays all records whose last name starts with those 2 letters, etc.?

[binoj_daniel]

This is pretty much doable and this functionality is called AutoComplete is Web Platform and Incremental Search in WinForms Arena.

[furjaw]

It works great!!!
Below is the code that I ended up with:

If LastNameTextBox.TextLength > 0 Then
PatientBindingSource.Filter = String.Format("LastName Like '" & LastNameTextBox.Text) & "*'"
Else
PatientBindingSource.Filter = String.Empty
End If

[binoj_daniel]

What event of the textbox did you use?

[furjaw]

Private Sub LastNameTextBox_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles LastNameTextBox.TextChanged

[binoj_daniel]

Thats good, glad you solved it. you can read more .net articles & best professional best practices here

[iloire]

Hi guys, there is an example of code posted of exactly that you want to do (it evens uses the First Name field and does "on the fly data filtering" based on filter condition)

You may see it in action here:

Dynamic filtering DataGridView in C#
http://www.dotneat.net/2008/12/03/DynamicDataGridViewFilteringInC.aspx

(Windows Forms and C#)

[iedapRo]

hi, there.. i try used your code, but it doesn't help...

If LastNameTextBox.TextLength > 0 Then
PatientBindingSource.Filter = String.Format(

[kvprajapati]

Hi iedapRo.

This thread is almost three yeard old. If you want to ask question, start your own (new) thread. Please read daniweb member rule and http://www.daniweb.com/forums/thread78223.html

Thread Closed.

[isharpk]

Use % sign on both side of given string.

If LastNameTextBox.TextLength > 0 Then
PatientBindingSource.Filter = String.Format("LastName Like '%" & LastNameTextBox.Text) & "%'"
Else
PatientBindingSource.Filter = String.Empty
End If