How to fetch the data based on from date to to date in c# windows

S J

I need to display loan paid statement in windows application form

Below is my design

Pls can anyone help to get result.........

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Santhakumar Munuswamy6y ago
Accepted answer
Hi Shilpa,

you have to build SQL query for fetching data based on the dates from to end

Ex. (Basic)

select * from tableName where date between @frmdate and @todate

if you want to know including loan amount paid status

select * from tableName where date between @frmdate and @todate and loanstatus=@status

you can find the reference here

http://prabhacsharptutorial.blogspot.com/2016/12/fetch-or-filter-data-from-date-to-date.html

https://www.csharp-console-examples.com/winform/filter-data-from-database-between-two-dates-in-c/

I hope it will helpful to you
Santhakumar Munuswamy6y ago
Hi Shilpa,

Could you mark as an answer and then it will help to others also. Thank you
S J6y ago
Thank you it is helpfull me
Jenith Thakkar6y ago
Hi have you got the answer
If no then update here like where you stuck at code side or sql side?