看以下代码,一直过不去,是什么原因
public DataSet GetArriveAnalysis(DateTime dStart,DateTime dEnd, ref int rowsCount)
{
Database db = DatabaseFactory.CreateDatabase("PODDB");
SqlParameter[] parameters = {
new SqlParameter("@PickDateStart", SqlDbType.DateTime),
new SqlParameter("@PickDateEnd",SqlDbType.DateTime)
};
parameters[0].Value = dStart;
parameters[1].Value = dEnd;
DataSet ds = db.ExecuteDataSet("sp_ArriveAnalysis",parameters); //就是这行报错,错误如题
rowsCount = ds.Tables[0].Rows.Count;
return ds;
}存储过程如下:
ALTER PROCEDURE [dbo].[sp_ArriveAnalysis]
@PickDateStart datetime,
@PickDateEnd datetime
AS
BEGIN
select TargetCity,Sum(Weight),Count(DONo) from t_UploadForm where pickdate>=@PickDateStart and PickDate<=@PickDateEnd
group by TargetCity select * from #ret
END
public DataSet GetArriveAnalysis(DateTime dStart,DateTime dEnd, ref int rowsCount)
{
Database db = DatabaseFactory.CreateDatabase("PODDB");
SqlParameter[] parameters = {
new SqlParameter("@PickDateStart", SqlDbType.DateTime),
new SqlParameter("@PickDateEnd",SqlDbType.DateTime)
};
parameters[0].Value = dStart;
parameters[1].Value = dEnd;
DataSet ds = db.ExecuteDataSet("sp_ArriveAnalysis",parameters); //就是这行报错,错误如题
rowsCount = ds.Tables[0].Rows.Count;
return ds;
}存储过程如下:
ALTER PROCEDURE [dbo].[sp_ArriveAnalysis]
@PickDateStart datetime,
@PickDateEnd datetime
AS
BEGIN
select TargetCity,Sum(Weight),Count(DONo) from t_UploadForm where pickdate>=@PickDateStart and PickDate<=@PickDateEnd
group by TargetCity select * from #ret
END
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货