indradeo says:
SqlCommand cmd =
new
SqlCommand(
"SELECT COUNT (info_type) Total FROM pptlk where info_type in ('PEP-TALKS') and dt=CAST(GETDATE() AS DATE)"
, con);
Use the DATEPART() function returns a specified part of a date.
Replace above with below code.
SqlCommand cmd = new SqlCommand("SELECT COUNT(info_type) Total FROM pptlk WHERE info_type IN ('PEP-TALKS') AND DATEPART(M,dt)=DATEPART(M,GETDATE())", con);