 |  |  |  |  |  |  |  |
Filtering a DataGridView
Please support our VB.NET advertiser: Intel Parallel Studio Home
Thread Solved |
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.?
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.?
•
•
Join Date: Dec 2006
Posts: 645
Reputation: 
Solved Threads: 17
DaniWeb Expert
This is pretty much doable and this functionality is called AutoComplete is Web Platform and Incremental Search in WinForms Arena.
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
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
•
•
Join Date: Dec 2006
Posts: 645
Reputation:
Solved Threads: 17
DaniWeb Expert
What event of the textbox did you use?
Private Sub LastNameTextBox_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles LastNameTextBox.TextChanged
•
•
Join Date: Dec 2006
Posts: 645
Reputation:
Solved Threads: 17
DaniWeb Expert
Thats good, glad you solved it. you can read more .net articles & best professional best practices here
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/Dy...teringInC.aspx
(Windows Forms and C#)
You may see it in action here:
Dynamic filtering DataGridView in C#
http://www.dotneat.net/2008/12/03/Dy...teringInC.aspx
(Windows Forms and C#)
 |
Similar Threads
- How to add rows from dataset to datagridview (C#)
- COMBOBOX VS DATAGRIDVIEW - resizing and positioning! (VB.NET)
- Searching a String in DataGridView FW 2.0 (C#)
- DataGridView EASY HELP (VB.NET)
- DataGridView - how to get invalid data in comboboxcell (C#)
- C# 2005 - ComboBoxes with Parent / Child relation in DataGridView (C#)
- Filtering data from access database (Visual Basic 4 / 5 / 6)
- Filtering data from an access database (Visual Basic 4 / 5 / 6)
- Office XP/2002 Access not filtering (MS Access and FileMaker Pro)
Other Threads in the VB.NET Forum
- Previous Thread: Crystal report
- Next Thread: dockable toolbar
Views: 8788 | Replies: 6
| Thread Tools | Search this Thread |
Latest VB.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for VB.NET
"crystal .net .net2005 30minutes 2008 access application arithmetic array assignment basic binary bing box button buttons c# center code combobox component connectionstring convert data database databasesearch datagrid datagridview design dissertation dissertations dissertationthesis dll dosconsolevb.net error excel file-dialog firewall folder google hardcopy highlighting image images isnumericfuntioncall listview login math memory mobile ms navigate net networking opacity output peertopeervideostreaming picturebox picturebox1 plugin port print printing problem problemwithinstallation project record reports" save savedialog serial server sorting sql string studio syntax temp text textbox timer toolbox updown upload useraccounts usercontrol vb vb.net vb.netcode vb.nettoolboxvisualbasic2008sidebar vb2008 vbnet view visual visualbasic visualbasic.net visualstudio visualstudio2008 web wpf
