C#, apsx-sida, SQL - problem

[tesT77]

hej har samma problem...(som //eforum.idg.se/topic/346901-problem-med-c-kod/ /Moderator)

 

 

Följande C#-kod körs i en aspx-sida:

long sum = 0;

for ( int i = 0; i < 841; i++)

{

// GetIntFromSQL returns an int from an SQL-statement-resultset with one

// row, one column

sum += GetIntFromSQL("EXEC dbo.ObscureProcedure @i = "+ i.ToString());

};

Response.Write(sum.ToString());

 

 

Proceduren i Microsoft SQL Server ser ut enligt::

CREATE PROCEDURE dbo.ObscureProcedure

@i int

AS

BEGIN

SELECT

CASE

WHEN @i < 128 THEN

COUNT(*) * @i

ELSE

COUNT(*) * 128

END AS ObscureCount

FROM

VacationGadget

WHERE

@i < 606

END

 

 

Kör man proceduren i Microsoft SQL Server Management Studio enligt ...

 

EXEC dbo.ObscureProcedure @i = 330

 

 

... så får man svaret:

 

ObscureCount

------------

1625600

 

(1 row(s) affected)

 

 

http://defav.lt/3/#Background