If you don't want to fill the DataSet manually, you will have to use a SqlDataAdapter. Basically, your SqlCommand will be a property of your SqlDataAdapter, and you will use the SqlDataAdapter.Fill method to fill your DataSet.

>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??? ***
>
>

>
>All the examples I found return a DataReader. How do I get back a data set?
>
>Also, do I need to set all those properties on each parameter object?
>
>Thanks