To Search a record in datagridview

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

[binoj_daniel]

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

[binoj_daniel]

Are you using VS 2003 or VS 2005?

Database SQL or Access?

[vcombstlh]

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]

VS 2005 et database Access

[Triss]

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]

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

[Triss]

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

[binoj_daniel]

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]

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]

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]

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]

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

[geetajlo]

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]

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]

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

y

[Triss]

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

[geetajlo]

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]

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

[geetajlo]

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.