Returning Output Param from SQL Connection

Question

Is this possible or the right way to go about this (if you're not using a stored proc):

conn.CommandText = "set @TotalPts = select SUM (pts) from cars where completedDate is not null and customerID = @customerID";
                conn.AddParam("@customerID", customerID);
                conn.AddOutputParam("@TotalPts", SqlDbType.Int);

                return (int)conn.OutputParamValue;

I want to get back the sum so I can return it in my C# method. I'm not sure how to set the output param in the string.

Rasik Jain · Accepted Answer · 2009-11-06 20:18:44Z

2

You can instead use ExecuteScalar method as following.

conn.CommandText = select SUM (pts) 
                    from cars 
                    where completedDate is not null 
                           and customerID = @customerID";

obj count=cmd.ExecuteScaler();

Convert that count to Integer using Convert.ToInt32 function.

answered Nov 6, 2009 at 20:18

Rasik Jain

1,0967 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

eglasius · Accepted Answer · 2009-11-06 20:16:47Z

0

Use ExecuteScalar along with "select SUM (pts) from cars where completedDate is not null and customerID = @customerID".

It will give u what's in the first row / column, which is what u want.

answered Nov 6, 2009 at 20:16

eglasius

35.9k5 gold badges69 silver badges110 bronze badges

Comments

Omer Bokhari · Accepted Answer · 2009-11-06 20:26:40Z

0

"I'm not sure how to set the output param in the string."

select @TotalPts = SUM(pts) from ...

edited Nov 6, 2009 at 20:26

answered Nov 6, 2009 at 20:21

Omer Bokhari

60k12 gold badges46 silver badges60 bronze badges

Collectives™ on Stack Overflow

Returning Output Param from SQL Connection

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related