C#

why not just do: Select @RC instead?

it will return a DataSet to c#...fill the DataSet using a sqladapter and then access the variable:

DataSet ds = new DataSet();

//Do stuff

int result = (int)ds.Tables[0].Row[0][0];



hope that helps

SELECT @rc

SqlCommand cmd = new SqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = "MyStoredProcName";
cmd.CommandType = CommandType.StoredProcedure;
int result = (int)cmd.ExecuteScalar()

SqlParameter returnParam= new SqlParameter("RETURN_VALUE",SqlDbType.Int);
returnParam.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(returnParam);

int result = (int)(cmd.Parameters["RETURN_VALUE"].Value)
// or, if returnParam is still in scope
int result = (int)returnParam.Value

Xodiak wrote:

it will return a DataSet to c#...fill the DataSet using a sqladapter and then access the variable:

int result = (int)mySqlCommand.ExecuteScalar();