 |  |  |  |  |  |  |  |
To Search a record in datagridview
Please support our VB.NET advertiser: Intel Parallel Studio Home
 |
•
•
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.
Latest VB.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
.net .net2008 2008 access add advanced application array assignment basic beginner box browser button buttons center click client code combo convert cpu cuesent data database datagrid datagridview datetimepicker designer dissertation dissertations dissertationtopic eclipse editvb.net employees excel exists filter forms function html images isnumericfuntioncall listview map mobile module msaccess mssqlbackend mysql net number open page pan panel pdf picturebox picturebox2 port position print printing printpreview read record regex reuse right-to-left save search serial settings socket sorting sqldatbase sqlserver storedprocedure temp textbox timer timespan transparency txttoxmlconverter usercontol vb vb.net vba vbnet vista visual visualbasic visualbasic.net visualstudio.net web winsock wpf wrapingcode xml year
