>I'm using C#/. I want to call a SQL stored procedure, pass parameters, and return a DataSet. Here's what I have so far:
>
>

>SqlCommand oCommand = new SqlCommand("bm_GetProjects", oConn);
>oCommand.CommandType = CommandType.StoredProcedure;
>
>SqlParameter param1 = new SqlParameter();
>param1.DbType = DbType.Int32;
>param1.Direction = ParameterDirection.Input;
>param1.ParameterName = "@AppKey";
>param1.SourceColumn = "AppKey";
>param1.SqlDbType = SqlDbType.Int;
>param1.Value = 87;
>oCommand.Parameters.Add(param1);
>
>
>SqlParameter param2 = new SqlParameter();
>param2.DbType = DbType.Int32;
>param2.Direction = ParameterDirection.Input;
>param2.ParameterName = "@CategoryTypeKey";
>param2.SourceColumn = "CategoryTypeKey";
>param2.SqlDbType = SqlDbType.Int;
>param2.Value = 87;
>oCommand.Parameters.Add(param2);
>
>
>
>SqlParameter param3 = new SqlParameter();
>param3.DbType = DbType.Int32;
>param3.Direction = ParameterDirection.Input;
>param3.ParameterName = "@ProjectStatusCodeKey";
>param3.SourceColumn = "ProjectStatusCodeKey";
>param3.SqlDbType = SqlDbType.Int;
>param3.Value = 87;
>oCommand.Parameters.Add(param3);
>
>
>oDataSet = oCommand.;       // ***  WHAT GOES HERE??? ***
>


use a sqlAdapter and then call the fill method:
<pre>
       SqlDataAdapter adapter = new SqlDataAdapter();
        adapter.SelectCommand = oCommand;
        adapter.Fill(oDataSet);
        return oDataSet;