showing only the filtered column in the datagridview
<p>i am a newbie and a student 
i have a windows form in which is have a datadrid view.
 i have table in sql server, i have binded with the datagrid,
in the table there is a 3 column and in which one column named date of small-date-time datatype,
i just binded the datagrid view to the table and it is showing all the rows of the three column i want to filter that. i have three column one is "name" second is "surname" and third is "date" date contains smalldatetime datatype and i want to show all the three columns but the columns which has the "date" columns as 30/12/12 if the date is 31/12/12 means the record from the previous date
sorry for the bad explanation i am weak in english
i dont know what to use here 
can i achieve this?</p>
