How Can I get hte return_Value?

Hi all~~~

I had used sqlDataSource + SQLserver procedure

The procedure like this:

...................

BEGIN

SELECT * FROM xxx

RETURN 1

END

er~~~How can I get the return_value with sqlDataSource ??

Create a parameter, and set the Direction property to ReturnValue|||Create a parameter??Would you make an example? Thanks~~|||

SqlConnection cn =newSqlConnection(MyConnectionString);

SqlCommand cmd =newSqlCommand("spName", cn);

cmd.CommandType =CommandType.StoredProcedure;

SqlParameter prm=new SqlParameter("@.ReturnValue");

prm.Direction=ReturnValue;

cmd.Parameters.Add(prm);

// Now .ExecuteNonQuery, ExecuteReader, etc. on the command.

|||Hidouglas.reilly ~It without SqlDataSourc......