To Search a record in datagridview

Question

geetajlo -2 Junior Poster in Training

18 Years Ago

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...

.net:vb.net

9 Contributors
27 Replies
10K Views
5 Years Discussion Span
Latest Post 13 Years Ago Latest Post by Reverend Jim

Dani AI

Generated 11 Months Ago

If you want to keep all rows visible and simply select the matches (e.g., show all rows but select those where any column contains "female" or names start with "F"), do not change the grid’s DataSource. Instead, iterate the displayed rows and set Selected for the ones that match. The snippet below works in VS 2005 with a bound DataGridView, supports case-insensitive contains or starts-with matching, and ignores the new-row placeholder. Call it from your Search button (ensure the Click event is wired in the designer) with the textbox value.

Private Sub SelectMatches(ByVal search As String, ByVal startsWith As Boolean, ParamArray columns() As String)
    DataGridView1.ClearSelection()
    If String.IsNullOrEmpty(search) Then Exit Sub

    For Each row As DataGridViewRow In DataGridView1.Rows
        If row.IsNewRow Then Continue For
        Dim match As Boolean = False

        If columns Is Nothing OrElse columns.Length = 0 Then
            For Each cell As DataGridViewCell In row.Cells
                Dim val As String = If(cell.Value, "").ToString()
                If (startsWith AndAlso val.StartsWith(search, StringComparison.CurrentCultureIgnoreCase)) _
                   OrElse (Not startsWith AndAlso val.IndexOf(search, StringComparison.CurrentCultureIgnoreCase) >= 0) Then
                    match = True : Exit For
                End If
            Next
        Else
            For Each col In columns
                Dim val As String = If(row.Cells(col).Value, "").ToString()
                If (startsWith AndAlso val.StartsWith(search, StringComparison.CurrentCultureIgnoreCase)) _
                   OrElse (Not startsWith AndAlso val.IndexOf(search, StringComparison.CurrentCultureIgnoreCase) >= 0) Then
                    match = True : Exit For
                End If
            Next
        End If

        row.Selected = match
    Next
End Sub

Tip: To show only matches instead (hiding others), bind via BindingSource and set Filter, e.g. FirstName LIKE 'F%' for starts-with; see BindingSource.Filter and DataGridView.SelectionMode. For large datasets, requery the database with a parameterized LIKE rather than scanning rows. References: DataGridView.

All 27 Replies

binoj_daniel 14 Practically a Master Poster

18 Years Ago

So you need to type the parameter in a input box to filter the Grid?

binoj_daniel 14 Practically a Master Poster

18 Years Ago

Are you using VS 2003 or VS 2005?

Database SQL or Access?

Triss 0 Newbie Poster

18 Years Ago

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

binoj_daniel 14 Practically a Master Poster

18 Years Ago

Do you want to search a particuar column from the DB or just any text in the Grid?

kvprajapati 1,826 Posting Genius

16 Years Ago

Welcome anandkumarrs6.

We appreciate your help. Have you ever noticed that the current thread is three years old? Please do not resurrect old threads and have a look at forum rules. Please read before posting - http://www.daniweb.com/forums/thread78223.html

Thread Closed.

Salem commented: Yes! +20

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

vcombstlh 0 Newbie Poster · Answer 1 · 2007-11-04T20:22:26+00:00

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...

Ok, what's the problem? Assume you want your users to enter a term in a textbox then you will search for that term. Is that correct? Give a little more info on the issue and what you need.

geetajlo -2 Junior Poster in Training · Answer 2 · 2007-11-05T13:02:37+00:00

geetajlo -2 Junior Poster in Training

18 Years Ago

VS 2005 et database Access

Triss 0 Newbie Poster · Answer 3 · 2007-11-05T21:00:44+00:00

Triss 0 Newbie Poster

18 Years Ago

Text in the grid... I think they mean... ?

binoj_daniel 14 Practically a Master Poster · Answer 4 · 2007-11-05T22:44:45+00:00

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.

geetajlo -2 Junior Poster in Training · Answer 5 · 2007-11-06T14:12:29+00:00

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

geetajlo -2 Junior Poster in Training · Answer 6 · 2007-11-06T20:19:29+00:00

i want to search a particular rows in the datagrid..
for example Any columns containing the data the user want to type, i want only the the data to be selected

for ex the user may want to serach all female, then only the rows female will b selected

Triss 0 Newbie Poster · Answer 7 · 2007-11-06T20:24:36+00:00

Private Function Find(ByVal StrSearchString As String) As Boolean

        DataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect

        Dim intcount As Integer = 0
        For Each Row As DataGridViewRow In DataGridView1.Rows
            If DataGridView1.Rows(intcount).Cells(0).Value.ToString = StrSearchString Then
                DataGridView1.Rows(intcount).Selected = True                
                    Find = True
                Exit Function
            End If
            intcount += 1
        Next Row
        Find = False
    End Function

binoj_daniel 14 Practically a Master Poster · Answer 8 · 2007-11-06T22:40:23+00:00

binoj_daniel 14 Practically a Master Poster

18 Years Ago

I think the logic from Triss would do that. Let me know.

geetajlo -2 Junior Poster in Training · Answer 9 · 2007-11-07T11:58:47+00:00

Hey Friends but where should i put the private function find
coz am using a button with an input box..
And wat should i put in the button search ,coz, there is nothing there except the input box...

Triss 0 Newbie Poster · Answer 10 · 2007-11-07T13:25:30+00:00

Copy paste code... open form designer drop a button and a textbox on it, double click button then enter...

Call Find(textbox1.text)

Done.

geetajlo -2 Junior Poster in Training · Answer 11 · 2007-11-07T15:18:39+00:00

Hey Triss
the button search doesn't do anything whevever i click it...

y

Triss 0 Newbie Poster · Answer 12 · 2007-11-07T15:20:36+00:00

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Call Find(TextBox1.Text)
    End Sub

geetajlo -2 Junior Poster in Training · Answer 13 · 2007-11-07T15:31:49+00:00

hey i have already copy n paste the function on the form and put the code call find to the button but it doesn't works. i have enter something in the textbox 2 n then press the button but nothing happens.
Help Me plzzz

Triss 0 Newbie Poster · Answer 14 · 2007-11-07T15:58:56+00:00

Triss 0 Newbie Poster

18 Years Ago

Attach the project I will have a look if you want.

geetajlo -2 Junior Poster in Training · Answer 15 · 2007-11-13T14:53:04+00:00

Hi triss can u help me how can i search name that starts with the letter F in a datagridview.
For example if i type F in the inputbox i got every name started with the letter F.

Triss 0 Newbie Poster · Answer 16 · 2007-11-13T14:55:27+00:00

Hi I would either use the filter options or requery your datasource.

George_E 0 Newbie Poster · Answer 17 · 2007-11-16T03:53:43+00:00

Hey guys I have been closely watching your threads regarding searching a record in a datagrid as I have the same problem as Geetajilo.

I can easily search for something in a datagrid by entering a field into a textbox and pressing the search button. This works fine when the record is already in the datagrid, but however how can you retrieve a record from the database and place it in the datagrid.??

Thanks for your time

binoj_daniel 14 Practically a Master Poster · Answer 18 · 2007-11-17T00:01:08+00:00

You can do it by quering it based on a column name. So you have to write a backend query to bind your search to the GRID.

anandkumarrs6 0 Newbie Poster · Answer 19 · 2010-04-15T20:50:58+00:00

For Each CurrentRow As DataGridViewRow In DgCustomerList.Rows
            If CurrentRow.Cells(3).Value.ToString.Contains(TxtSearch.Text) Then
                CurrentRow.Selected = True
            Else
                DgCustomerList.Rows(0).Selected = True
            End If
        Next
    End Sub

rejz88 0 Newbie Poster · Answer 20 · 2013-02-21T07:56:37+00:00

PLZ HELP ME.. I WANT TO SEARCH A EMPLOYEE'S RECORD TO MY DATABASE ADODC IN SEARCH BOTTON(TEXT1) AND ONLY THE RECORDS OF EMPLOYEE VIEW IN THE DataGrid.. WHAT IS THE CODE FOR IT.? PLZZZZZZZZ.....

rejz88 0 Newbie Poster · Answer 21 · 2013-02-21T08:09:37+00:00

plz help me to sold my problem... I have a database(access) and all I want is to view all the records of the person that l've searching.. using textbox and view it in the DataGrid. I using vb6 and my database is access. what is the best code for my problem? plz........
:(

score 0 · Answer 22 · 2013-02-21T11:23:11+00:00

Please start a new thread for your question. Please ensure you post in the correct forum. Yours is a VB6 question. This is VB.net.

To Search a record in datagridview

Dani AI

Recommended Answers Collapse Answers

All 27 Replies

Recommended Answers