存储过程分页

shenhui_163 2008-01-20 05:28:09

这是俺的一个存储过程在查询分析器里运行没有问题.但是让.NET调用的时候就说什么第几行的14有错误,请各位大侠指点一下
CREATE PROCEDURE dbo.USP_ShowGridViewForPage
(
@InfoClassID INT,
@LifeInfoTreatment INT,
@BeginDateTime DATETIME,
@CurrentPage INT
)
AS
DECLARE
@StrSql VARCHAR(2000)
--SET @StrSql = 'SELECT TOP 15 * FROM tb_LifeInfo WHERE (LifeInfoID NOT IN(SELECT TOP ' + cast((15 * (@CurrentPage - 1)) AS VARCHAR) + ' LifeInfoID FROM tb_LifeInfo WHERE InfoClassID = '+ CAST(@InfoClassID AS VARCHAR) +' AND LifeInfoTreatment = '+CAST(@LifeInfoTreatment AS VARCHAR)+' AND LifeInfoDate BETWEEN '+ CAST(@BeginDateTime AS VARCHAR) +' AND '+CAST(GETDATE() AS VARCHAR)+ ' ORDER BY LifeInfoTime DESC)) ORDER BY LifeInfoTime DESC '
--SET @StrSql = 'SELECT TOP 15 * FROM tb_LifeInfo WHERE (LifeInfoID NOT IN(SELECT TOP ' + cast((15 * (@CurrentPage - 1)) AS VARCHAR) + ' LifeInfoID FROM tb_LifeInfo WHERE InfoClassID = '+ CAST(@InfoClassID AS VARCHAR) +' AND LifeInfoTreatment = '+CAST(@LifeInfoTreatment AS VARCHAR)+' ORDER BY LifeInfoTime DESC)) ORDER BY LifeInfoTime DESC '
--SET @StrSql = 'SELECT TOP 15 * FROM tb_LifeInfo WHERE (LifeInfoID NOT IN(SELECT TOP ' + cast((15 * (@CurrentPage - 1)) AS VARCHAR) + ' LifeInfoID FROM tb_LifeInfo WHERE InfoClassID = 2))'
SET @StrSql = 'SELECT TOP 15 LifeInfoID , LifeInfoTitle , LifeInfoDate , LifeInfoTime , LifeInfoContacter , LifeInfoContactPhone , LifeInfoTreatment
FROM tb_LifeInfo
WHERE
(
LifeInfoID NOT IN
(
SELECT TOP '+CAST((15*(@CurrentPage-1))AS VARCHAR)+' LifeInfoID
FROM tb_LifeInfo
WHERE InfoClassID = '+CAST(@InfoClassID AS VARCHAR)+' AND LifeInfoTreatment = '+CAST(@LifeInfoTreatment AS VARCHAR)+' AND LifeInfoDate BETWEEN '+CAST(@BeginDateTime AS VARCHAR)+' AND GETDATE()
)
)
AND InfoClassID = '+CAST(@InfoClassID AS VARCHAR)+' AND LifeInfoTreatment = '+CAST(@LifeInfoTreatment AS VARCHAR)+' AND LifeInfoDate BETWEEN '+CAST(@BeginDateTime AS VARCHAR)+' AND GETDATE()
'
EXEC(@StrSql)

GO

...全文