Please help me with the data grid view search using 3-tier

[priyanka9]

I want to filter the datagridview on Search button click,i am using 3-tier architecture,the grid should be updated with the search result

[Pgmer]

you need to use dataview and filter the dataview with dataview.rowfilter method and bind the result back to the grid.

[priyanka9]

i tried but its not working

[Pgmer]

Show your code here..

[priyanka9]

 For i = 0 To (GrdUnitsOfMeasure.RowCount - 2)
                For j = 0 To (GrdUnitsOfMeasure.ColumnCount - 1)
                    If (GrdUnitsOfMeasure.Rows(i).Cells(j).Value.ToString.ToLower.StartsWith(TxtSearch.Text)) Then
                        GrdUnitsOfMeasure.Rows(i).Cells(j).Style.BackColor = Color.Red
                     else
                     MessageBox.Show("No Records Found")
                     EndIf
                     Next
                     Next

I want to highlight only the content

[Pgmer]

Where is the code for Dataview and rowfilter?

[priyanka9]

the above is
my code i didnt used the dataview or row filter

[Pgmer]

 Try
            Dim cn As SqlConnection
            Dim strCnn As String = "Your data base connection string"
            cn = New SqlConnection(strCnn)
            cn.Open()
            Dim comm As New SqlCommand("Your sp or Command text to get the data from DB", cn)
            '' If ur using Sp then Commandtype= CommandType.StoredProcedure if it is Text then comm.CommandType=CommandType.Text
            comm.CommandType = CommandType.StoredProcedure
            Dim da As New SqlDataAdapter(comm)
            Dim ds As New DataSet
            da.Fill(ds)

            Dim dv As New DataView
            dv = dsNew.Tables(0).DefaultView
            dv.RowFilter = "Name = '" & "John" & "'"

            ''Close your connections and commands.
        Catch ex As Exception
            ''Handle error if any
        End Try

try something like this code.
Note:Code above is not tested. You need to change the filter criteria to your need.