Search (Filter) record between Month range and Year using C# in ASP.Net

Hi nisss,

You need to add another condition in the where clause for Year.

Use the below code and check.

sqlUsers.SelectCommand = "SELECT a.leaveId , p.Id, p.Name, a.start, a.end, a.total, a.dateapply, a.Type, a.Status " +
" FROM  profile as p INNER JOIN leaveapp as a On a.Id = p.Id " +
" Where (Month(a.start) BETWEEN '" + tbSearch.Text.Split('-')[0].Trim() 
+ "' AND '" + tbSearch.Text.Split('-')[1].Trim().Split(',')[0].Trim() + "')" 
+ " AND Year = '" + tbSearch.Text.Split('-')[1].Trim().Split(',')[1].Trim() + "'" 
+ " ORDER BY a.start DESC";