 |  |  |  |  |  |  |  |
To Search a record in datagridview
Please support our VB.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!
 |
•
•
Join Date: Sep 2007
Posts: 72
Reputation: 
Solved Threads: 0
Junior Poster in Training
hi friends...
i want to search a record from a datagridview with an input box...
Can anyone help me plz...
It's 4 my project ...
Need help plzzzz...
i want to search a record from a datagridview with an input box...
Can anyone help me plz...
It's 4 my project ...
Need help plzzzz...
•
•
Join Date: Dec 2006
Posts: 645
Reputation:
Solved Threads: 17
DaniWeb Expert
So you need to type the parameter in a input box to filter the Grid?
•
•
Join Date: Dec 2006
Posts: 645
Reputation:
Solved Threads: 17
DaniWeb Expert
Are you using VS 2003 or VS 2005?
Database SQL or Access?
Database SQL or Access?
•
•
•
•
Originally Posted by geetajlo 
hi friends...
i want to search a record from a datagridview with an input box...
Can anyone help me plz...
It's 4 my project ...
Need help plzzzz...
•
•
Join Date: Sep 2007
Posts: 72
Reputation:
Solved Threads: 0
Junior Poster in Training
VS 2005 et database Access
You could loop through the rows in the datagridview ? Or maybe re-query the datasource?
Dim intcount As Integer = 0
For Each Row As DataGridViewRow In DataGridView1.Rows
If DataGridView1.Rows(intcount).Cells(0).Value = "StringSearch" Then
'Do Something
intcount +=1
End If
Next Row
Dim intcount As Integer = 0
For Each Row As DataGridViewRow In DataGridView1.Rows
If DataGridView1.Rows(intcount).Cells(0).Value = "StringSearch" Then
'Do Something
intcount +=1
End If
Next Row
Last edited by Triss; Nov 5th, 2007 at 4:41 am.
•
•
Join Date: Dec 2006
Posts: 645
Reputation:
Solved Threads: 17
DaniWeb Expert
Do you want to search a particuar column from the DB or just any text in the Grid?
•
•
Join Date: Dec 2006
Posts: 645
Reputation:
Solved Threads: 17
DaniWeb Expert
You Can use something like this using DataView
Dim dv As New DataView(ds.Tables(0))
dv.RowFilter = "FirstName = '" & TextBox1.Text & "'"
DataGrid1.DataSource = dv
You can replace the Textbox2.text to the value returned from the inputbox.
Dim dv As New DataView(ds.Tables(0))
dv.RowFilter = "FirstName = '" & TextBox1.Text & "'"
DataGrid1.DataSource = dv
You can replace the Textbox2.text to the value returned from the inputbox.
•
•
Join Date: Sep 2007
Posts: 72
Reputation:
Solved Threads: 0
Junior Poster in Training
hi thanks it works...
the search works, it select only the fullrows containing the firstname i type in the input box but all the other data disappear.
i don't want it to disapppear, i want it to be in the datagrid..
help me plz
the search works, it select only the fullrows containing the firstname i type in the input box but all the other data disappear.
i don't want it to disapppear, i want it to be in the datagrid..
help me plz
|
Similar Threads
- Search records in a database (ASP.NET)
- How to Search record from the Sql Server Database (ASP.NET)
- Search record from SQLDatabase (ASP.NET)
- Search facility for a drop down box (MySQL)
- search record using search button from database (ASP)
Other Threads in the VB.NET Forum
- Previous Thread: extract data
- Next Thread: Large Database record editing recommendation
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest VB.NET Posts
- Today's Posts
- Unanswered Threads
"crystal .net .net2005 .net2008 2008 access add application array assignment basic beginner box browser button buttons click code combo convert cpu cuesent data database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationthesis dissertationtopic dosconsolevb.net editvb.net exists fade filter firewall forms html image images input isnumericfuntioncall listview math mobile module mssqlbackend mysql navigate number opacity open panel picturebox picturebox2 port print printing printpreview record regex reports" reuse right-to-left savedialog serial settings shutdown socket sqldatbase sqlserver storedprocedure string temp temperature textbox timer timespan transparency txttoxmlconverter useraccounts usercontol usercontrol vb vb.net vb.nettoolboxvisualbasic2008sidebar vbnet vista visual visualbasic.net visualstudio.net web winforms wpf wrapingcode xml year