If you are doing a fill, would it work to return two recordsets, one of which being your desired value?

>I have a SQL proc that accepts two params and returns a record and which also has an
>output parameter with an error state.
>
>Using C#, I need to return the record and the output parameter.
>
>So far, I have the following, but I'm not sure I'm going the right direction. Can anyone help?
>
>
>
>

>// Create and open a connection
>SqlConnection oConnection = new SqlConnection(oDBInfo.sConnString);
>oConnection.Open();
>
>// Set up a data adapter
>SqlDataAdapter oDataAdapter = new SqlDataAdapter("sp_MyProc", oConnection);
>oDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
>
>
>// Create a data set
>DataSet oDataSet = new DataSet("MyTable");
>
>// Fill the data set
>oDataAdapter.Fill(oDataSet);
>