please suggest me with full coding in C#.
Sorry, it does not work like this.
Here is what is expected of enquirers:
1. TRY first
what you want to do! You may find that it's not that hard.
2. Formulate what was done by you that looks like an issue/not working.
For your question, following will help:
1. Your query should have WHERE clause for date like,
SELECT * FROM MyTable WHERE dateColumn BETWEEN @startDate AND @endDate
2. Study about ADO.NET: MSDN: ADO.NET