That did it. Thanks!


>>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;
>