Getting data in datagrid using linq...

See more:

VB

LINQ

I have a datagrid and when it loads all the records are fetched from database and displayed in the datagrid. In the form I also have functionality to search the record by id. but I want to get it done by using LINQ i.e it should search from datagrid and display the record of that id which I enter. Below is the code for fetching the record by id using datareader.
-----------------------------------------------------------------
code:
-----------------------------------------------------------------

Private Sub btnsearch_Click(sender As Object, e As EventArgs) Handles btnsearch.Click
       DGV_empno.Rows.Clear()
       Try
           con.Open()
           com = New SqlCommand("SELECT * from emp_master where empid=@empid", con)
           com.Parameters.AddWithValue("@empid", txtempno.Text)
           dr = com.ExecuteReader
           While dr.Read
               i = DGV_empno.Rows.Add(+1)
               DGV_empno.Rows(i).Cells(0).Value = dr("empid")
               DGV_empno.Rows(i).Cells(1).Value = dr("empname")
               DGV_empno.Rows(i).Cells(2).Value = dr("dob")
               DGV_empno.Rows(i).Cells(3).Value = dr("doj")
               DGV_empno.Rows(i).Cells(4).Value = dr("dept")
               DGV_empno.Rows(i).Cells(5).Value = dr("desig")
               DGV_empno.Rows(i).Cells(6).Value = dr("exp")
               DGV_empno.Rows(i).Cells(7).Value = dr("salary")
           End While

       Catch ex As Exception
           MsgBox(ex.Message)
       Finally
           dr.Close()
           con.Close()
       End Try


   End Sub