Try this steps.
1. Make connection to Sql
2. Fill dataset
3. make dataview
4. bind it to datagrid
5. Give input option in UI (c#) for name/date filter
6. pass the value to dataview and use filter as below
dv.Table.Select("name = "+ txtName.Text)
7. Bind the result to datagrid