asked on

How do I use Eval() with Repeater Control?

Hi all,
I have a problem about data binding with repeater control.
My sales table has Record_ID, Date(smalldatetime), Agent_ID......... and more columns.
I created stored procedure for 7 days period to see agents daily sales report.
When i bind database with eval function using stored procedure USP_TotalDailySales @Agent_ID=value, 1 record is return like this:

Column Headers:ID,Agent_ID, 0(26.04.2010), 1(25.04.2010), 2(24.04.2010), 3(23.04.2010), 4(22.04.2010), 5(21.04.2010), 6(20.04.2010)
Record:1,1,23(Agent 1 has total sales),12,3,11,2,10,22

I want to see all of agent records. What is way to provide?

My procedure is here:

CREATE PROCEDURE USP_TotalDailySales @Agent_ID tinyint
AS
BEGIN

DECLARE @Today varchar(10)
DECLARE @Today_minus_1 varchar(10)
DECLARE @Today_minus_2 varchar(10)
DECLARE @Today_minus_3 varchar(10)
DECLARE @Today_minus_4 varchar(10)
DECLARE @Today_minus_5 varchar(10)
DECLARE @Today_minus_6 varchar(10)
DECLARE @Agent varchar(50)


SELECT @Today=COUNT(*) FROM tbl_Sales
WHERE Agent_ID=@Agent_ID AND  CONVERT(varchar(10),dbo.tbl_Sales.Date,104) BETWEEN CONVERT(varchar(10),GETDATE(),104) AND CONVERT(varchar(10),GETDATE(),104)


SELECT @Today_minus_1=COUNT(*) FROM tbl_Sales
WHERE Agent_ID=@Agent_ID AND  CONVERT(varchar(10),dbo.tbl_Sales.Date,104) BETWEEN CONVERT(varchar(10),GETDATE()-1,104) AND CONVERT(varchar(10),GETDATE()-1,104)

SELECT @Today_minus_2=COUNT(*) FROM tbl_Sales
WHERE Agent_ID=@Agent_ID AND  CONVERT(varchar(10),dbo.tbl_Sales.Date,104) BETWEEN CONVERT(varchar(10),GETDATE()-2,104) AND CONVERT(varchar(10),GETDATE()-2,104)

SELECT @Today_minus_3=COUNT(*) FROM tbl_Sales
WHERE Agent_ID=@Agent_ID AND  CONVERT(varchar(10),dbo.tbl_Sales.Date,104) BETWEEN CONVERT(varchar(10),GETDATE()-3,104) AND CONVERT(varchar(10),GETDATE()-3,104)

SELECT @Today_minus_4=COUNT(*) FROM tbl_Sales
WHERE Agent_ID=@Agent_ID AND  CONVERT(varchar(10),dbo.tbl_Sales.Date,104) BETWEEN CONVERT(varchar(10),GETDATE()-4,104) AND CONVERT(varchar(10),GETDATE()-4,104)

SELECT @Today_minus_5=COUNT(*) FROM tbl_Sales
WHERE Agent_ID=@Agent_ID AND  CONVERT(varchar(10),dbo.tbl_Sales.Date,104) BETWEEN CONVERT(varchar(10),GETDATE()-5,104) AND CONVERT(varchar(10),GETDATE()-5,104)

SELECT @Today_minus_6=COUNT(*) FROM tbl_Sales
WHERE Agent_ID=@Agent_ID AND  CONVERT(varchar(10),dbo.tbl_Sales.Date,104) BETWEEN CONVERT(varchar(10),GETDATE()-6,104) AND CONVERT(varchar(10),GETDATE()-6,104)


SELECT @Agent_ID AS ID, @Today AS '0', @Today_minus_1  AS '1',@Today_minus_2 AS '2',@Today_minus_3  AS '3',@Today_minus_4  AS '4',@Today_minus_5  AS '5',@Today_minus_6 AS '6' 


END


GO

Open in new window