I want to get those value which are between some date like 2/2/2010 to 2/4/2010 Any body have some solution so please give

See more:

C#

I want to get those value which are between some date like 2/2/2010 to 2/4/2010……………(mm/dd/yyyy)……….
I have used datetimepicker on the form………….
I made below method which call sqlserver procedure………
But it isn’t working properly………….
Any body have some solution so please give……..

GetsiteDetailByDate(cmbSiteSelect.Text, cmbSubSiteSelect.Text, dtpfromdate.Value, dtptodate.Value);

ALTER procedure [dbo].[GetConsumeDetailByDate] (@sname nvarchar,@ssname nvarchar,@fromdate datetime,@todate datetime)
as
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)
above procedure isn’t working ………