Have you run your select query on its own to see if it returns the results you expect?
ie: Plug some values in, and run this:
Surendra Singh Tomar wrote:
select material_name,material_type,qty,unit,date from consume where (site_name=@sname and site_sub_name=@ssname and date between @fromdate and @todate)