我想获取介于2/2/2010到2/4/2010之间的值任何机构都有一些解决方案，所以请给 [英] 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

问题描述

我想获取介于2/2/2010到2/4/2010之间的那些值...…………(mm/dd/yyyy)………..
我在表格上使用了datetimepicker………….
我做了下面的方法来调用sqlserver程序…………
但是它不能正常工作………….
任何身体都有解决方案，所以请给……..

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

ALTER过程[dbo].[GetConsumeDetailByDate](@ sname nvarchar，@ ssname nvarchar，@ fromdate datetime，@ todate datetime)
如
从消耗中选择material_name，material_type，qty，unit，date(site_name = @ sname和site_sub_name = @ ssname，以及@fromdate和@todate之间的日期)
上面的过程不起作用…………

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 ………

推荐答案

您是否自行运行选择查询以查看它是否返回您期望的结果?

即:插入一些值，然后运行:

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写道:

Surendra Singh Tomar wrote:

从消耗位置选择物料名称，物料类型，数量，单位，日期(站点名称= @ sname和site_sub_name = @ ssname和日期在@fromdate和@todate之间)

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)

这篇关于我想获取介于2/2/2010到2/4/2010之间的值任何机构都有一些解决方案，所以请给的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！