dynamic search in c#

Here is a good tutorial that shows how to use DataGridView to retrieve and display data from an SQL DB:
http://www.dotnetperls.com/sqldataadapter[^]

Here is another tutorial on DataGridViewin general:
http://www.dotnetperls.com/datagridview[^]

When you say "dynamically" i take it you mean that you want it to appear to "refresh" or "update" to reflect changes without the user's intervention.

I would suggest you use a system timer at a 1 second interval, and on timer overflow:
1. retrieve all data from the DB
2. remove all content from the DataGridView
3. write new contents in