simple question about sql server and c#

[Irakli Lekishvi]

Hi everybody.
I cant ponder how to do that. We have clients who use our transportation service. I constructed sql server table with name Debt its relationed with transportation ID and client ID. Clients always pay money at end of month. How can i do with c# or sql server that count all entries from month begining to end of month ?
Sorry for my bad English.
I hope that my question is understandable.
Please Advice me something...

[code green]

How can i do with c# or sql server that count all entries from month begining to end of month ?

Wel a SQL query would be something like

SELECT COUNT(id) FROM table WHERE date_ent BETWEEN start_date AND end_date