SqlDataReader-Ouput Parameter And SqlConnection

[C# Programming]

Hi,

I am using a procedure which selects some rows and handles a output parameter.

I am executing this procedure using SqlDataReader.

Problem Is ,

If Connection is kept open after ExecuteReader(), Sql Reader is working fine and able to do data binding. But, output parameter is returing null value.

If Connection is closed, I am able to get the correct output parameter value. But, SqlDataReader is not working.

Any Ideas to make both working regardless of connection status.

Thanks,
Nagaraj

Umbraco Developer (http://www.umbracosolution.com)